details: https://code.openbravo.com/erp/devel/pi/rev/acb7c4bb1944
changeset: 21375:acb7c4bb1944
user: Sandra Huguet <sandra.huguet <at> openbravo.com>
date: Tue Oct 22 09:11:41 2013 +0200
summary: Related to issue 24309
diffstat:
src-db/database/model/functions/C_COMMISSIONRUN_PROCESS.xml | 11 ++++-------
1 files changed, 4 insertions(+), 7 deletions(-)
diffs (44 lines):
diff -r af69b7e7a6c8 -r acb7c4bb1944
src-db/database/model/functions/C_COMMISSIONRUN_PROCESS.xml
--- a/src-db/database/model/functions/C_COMMISSIONRUN_PROCESS.xml Tue Oct
22 11:06:09 2013 +0530
+++ b/src-db/database/model/functions/C_COMMISSIONRUN_PROCESS.xml Tue Oct
22 09:11:41 2013 +0200
@@ -50,7 +50,6 @@
v_IsDiscountPrinted CHAR(1);
v_CommissionName VARCHAR(60);
v_countNoCost NUMBER(10);
- v_user varchar2(32);
v_isdeferredexpense M_Product.IsDeferredExpense%TYPE;
v_expplantype M_Product.ExpPlanType%TYPE;
@@ -107,12 +106,11 @@
BEGIN
FOR Cur_Data IN (SELECT com.Name, com.C_Currency_ID,
com.C_BPartner_ID, pl.C_BPartner_Location_ID,
PaymentRulePO, PO_PaymentTerm_ID, PO_PriceList_ID,
- POReference, IsDiscountPrinted, p.SalesRep_ID, com.M_Product_ID,
C_UOM_ID, p.name as bpartnername, us.ad_user_id
- FROM C_BPARTNER p , AD_User us, C_COMMISSION com LEFT JOIN
C_BPARTNER_LOCATION pl ON com.C_BPartner_ID = pl.C_BPartner_ID
+ POReference, IsDiscountPrinted, p.SalesRep_ID, com.M_Product_ID,
C_UOM_ID, p.name as bpartnername
+ FROM C_BPARTNER p, C_COMMISSION com LEFT JOIN C_BPARTNER_LOCATION
pl ON com.C_BPartner_ID = pl.C_BPartner_ID
LEFT JOIN M_Product prd ON
com.M_Product_ID = prd.M_Product_ID
WHERE com.C_Commission_ID = CUR_ComRun.C_Commission_ID
- AND com.C_BPartner_ID = p.C_BPartner_ID
- and us.C_BPartner_ID = p.C_BPartner_ID) LOOP
+ AND com.C_BPartner_ID = p.C_BPartner_ID) LOOP
v_CommissionName:=Cur_Data.Name;
v_C_Currency_ID:=Cur_Data.C_Currency_ID;
v_C_BPartner_ID:=Cur_Data.C_BPartner_ID;
@@ -126,7 +124,6 @@
v_Product_ID:=Cur_Data.M_Product_ID;
v_UOM_ID:=Cur_Data.C_UOM_ID;
v_partnername:=Cur_Data.bpartnername;
- v_user:=Cur_Data.ad_user_id;
EXIT;
END LOOP;
END;
@@ -181,7 +178,7 @@
CUR_ComRun.AD_Client_ID, CUR_ComRun.AD_Org_ID, 'Y', now(), '0', now(), '0',
'N', v_DocumentNo, 'DR', 'CO', 'N', 'N',
v_C_DocType_ID, v_C_DocType_ID, CUR_ComRun.Description,
- v_user,
+ NULL,
CUR_ComRun.Updated, NULL, 'N', CUR_ComRun.Updated, CUR_ComRun.Updated, --
DateInvoiced=DateAcct
v_C_PaymentTerm_ID, v_C_BPartner_ID, v_C_BPartner_Location_ID, NULL,
v_POReference, CUR_ComRun.Updated, v_IsDiscountPrinted,
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
