details: /erp/devel/pi/rev/c044844ee200
changeset: 6706:c044844ee200
user: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
date: Mon Mar 15 15:12:16 2010 +0530
summary: Fixes issue 12430: Error launching work requirement and material
requisitions from MRP
diffstat:
src-db/database/model/functions/MRP_REQUISITION.xml | 6 +++---
src-db/database/model/functions/MRP_WORKREQUIREMENT.xml | 4 ++--
2 files changed, 5 insertions(+), 5 deletions(-)
diffs (37 lines):
diff -r c72b2f028c8f -r c044844ee200
src-db/database/model/functions/MRP_REQUISITION.xml
--- a/src-db/database/model/functions/MRP_REQUISITION.xml Mon Mar 15
10:11:19 2010 +0100
+++ b/src-db/database/model/functions/MRP_REQUISITION.xml Mon Mar 15
15:12:16 2010 +0530
@@ -63,9 +63,9 @@
v_Client_ID := Cur_Parameter.AD_Client_ID;
v_Org_ID := Cur_Parameter.AD_Org_ID;
END LOOP; -- Get Parameter
-
- SELECT NAME || ' ' || TO_CHAR(DATEDOC), Description
- INTO v_Description0, v_Description
+
+ SELECT NAME || ' ' || TO_CHAR(DATEDOC), Description, AD_ORG_ID
+ INTO v_Description0, v_Description, v_Org_ID
FROM MRP_RUN_PRODUCTION
WHERE MRP_RUN_PRODUCTION_ID = v_Record_ID;
diff -r c72b2f028c8f -r c044844ee200
src-db/database/model/functions/MRP_WORKREQUIREMENT.xml
--- a/src-db/database/model/functions/MRP_WORKREQUIREMENT.xml Mon Mar 15
10:11:19 2010 +0100
+++ b/src-db/database/model/functions/MRP_WORKREQUIREMENT.xml Mon Mar 15
15:12:16 2010 +0530
@@ -67,7 +67,7 @@
FOR Cur_workproposal IN (
SELECT MRP_RUN_PRODUCTIONLINE.* , MA_PROCESSPLAN.EXPLODEPHASES,
MA_PROCESSPLAN.CONVERSIONRATE, MA_PROCESSPLAN.SECONDARYUNIT,
- ROUND((MRP_RUN_PRODUCTIONLINE.qty/A.PROQTY)+0.0005,3) AS PROCESSPLANQTY
+ ROUND((MRP_RUN_PRODUCTIONLINE.qty/A.PROQTY)+0.0005,3) AS PROCESSPLANQTY,
MRP_RUN_PRODUCTIONLINE.AD_ORG_ID
FROM MRP_RUN_PRODUCTIONLINE, MA_PROCESSPLAN,
(SELECT DISTINCT produced, proqty, ma_processplan_id
FROM MA_PROCESSPLAN_TOTALIZED) A
@@ -80,7 +80,7 @@
ORDER BY PLANNEDDATE
) LOOP
v_ResultStr:='Create Work Requirement';
-
+V_ORG_ID :=Cur_workproposal.AD_ORG_ID;
Ad_Sequence_Next('MA_WorkRequirement', v_Client_ID, v_WR_ID);
Ad_Sequence_Doc('DocumentNo_MA_WorkRequirement', v_Client_ID, 'Y',
v_DocumentNo) ;
INSERT INTO MA_WORKREQUIREMENT (
------------------------------------------------------------------------------
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
