details: /erp/devel/pi/rev/9325816dbd05
changeset: 7836:9325816dbd05
user: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
date: Mon Jul 12 09:58:36 2010 +0530
summary: Fixes Issue 13780: mrp_run_initialize does not filter by active
products
diffstat:
src-db/database/model/functions/MRP_RUN_INITIALIZE.xml | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diffs (11 lines):
diff -r 8010e964ec1c -r 9325816dbd05
src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
--- a/src-db/database/model/functions/MRP_RUN_INITIALIZE.xml Sun Jul 11
18:54:55 2010 +0200
+++ b/src-db/database/model/functions/MRP_RUN_INITIALIZE.xml Mon Jul 12
09:58:36 2010 +0530
@@ -91,6 +91,7 @@
AND Ad_Isorgincluded(p_Org_ID, p.AD_ORG_ID,
p_Client_ID) > -1
AND p.AD_Client_ID = p_Client_ID
AND ((p_Production = 'Y' AND p.ISPURCHASED = 'N') OR
(p_Production = 'N' AND p.ISPURCHASED = 'Y'))
+ AND P.ISACTIVE = 'Y'
AND (p_Production = 'Y' OR
(p_Vendor_ID IS NULL
OR EXISTS (SELECT 1
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
