details: /erp/devel/pi/rev/00600b268925
changeset: 6702:00600b268925
user: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
date: Sat Mar 13 10:31:41 2010 +0530
summary: Fixes Issue 12308: Closed Purchase Orders in Purchasing Plan.
diffstat:
src-db/database/model/functions/MRP_RUN_INITIALIZE.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 690d2af86089 -r 00600b268925
src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
--- a/src-db/database/model/functions/MRP_RUN_INITIALIZE.xml Fri Mar 12
18:20:53 2010 +0000
+++ b/src-db/database/model/functions/MRP_RUN_INITIALIZE.xml Sat Mar 13
10:31:41 2010 +0530
@@ -178,7 +178,7 @@
ol.C_OrderLine_ID,
GREATEST(COALESCE(ol.DatePromised, ol.DateOrdered, o.DateOrdered),
p_PlanningDate) AS planningDate,
COALESCE(ol.DateOrdered, o.Dateordered)
AS dateordered,
o.IsSOTrx
- FROM C_ORDER o, C_ORDERLINE ol LEFT JOIN
(SELECT C_ORDERLINE_ID, SUM(QTY) as qty FROM m_matchpo group by c_orderline_id)
matchpo on ol.c_orderline_id = matchpo.c_orderline_id
+ FROM C_ORDER o, C_ORDERLINE ol LEFT JOIN
(SELECT C_ORDERLINE_ID, SUM(QTY) as qty FROM m_matchpo WHERE m_inoutline_id is
not null group by c_orderline_id) matchpo on ol.c_orderline_id =
matchpo.c_orderline_id
WHERE o.C_ORDER_ID = ol.C_ORDER_ID
--AND C_Order_Status(o.C_ORDER_ID) IN (1,
2, 3)
AND o.PROCESSED = 'Y'
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
