details: /erp/devel/pi/rev/aadbbebc99d1
changeset: 6967:aadbbebc99d1
user: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
date: Fri Apr 09 16:21:01 2010 +0530
summary: Fixes issue for invalid function error
diffstat:
src-db/database/model/functions/MRP_WORKREQUIREMENT.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (21 lines):
diff -r 7e9e2ac8a348 -r aadbbebc99d1
src-db/database/model/functions/MRP_WORKREQUIREMENT.xml
--- a/src-db/database/model/functions/MRP_WORKREQUIREMENT.xml Fri Apr 09
16:05:56 2010 +0530
+++ b/src-db/database/model/functions/MRP_WORKREQUIREMENT.xml Fri Apr 09
16:21:01 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,
MRP_RUN_PRODUCTIONLINE.AD_ORG_ID
+ ROUND((MRP_RUN_PRODUCTIONLINE.qty/A.PROQTY)+0.0005,3) AS PROCESSPLANQTY,
MRP_RUN_PRODUCTIONLINE.AD_ORG_ID AS ADORG_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;
+V_ORG_ID :=Cur_workproposal.ADORG_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
