details: http://code.openbravo.com/erp/devel/pi/rev/88460deb3db2
changeset: 4493:88460deb3db2
user: Ben Sommerville <ben.sommerville <at> eintel.com.au>
date: Fri Aug 14 13:28:44 2009 +1000
summary: Fixes issue 0010272: AD_SYNCHRONIZE doesn't check if AD_PROCESS_PARA
is in development when updating CentrallyMaintained status
diffstat:
src-db/database/model/functions/AD_SYNCHRONIZE.xml | 7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)
diffs (17 lines):
diff -r b10bedd14f64 -r 88460deb3db2
src-db/database/model/functions/AD_SYNCHRONIZE.xml
--- a/src-db/database/model/functions/AD_SYNCHRONIZE.xml Fri Aug 14
06:30:41 2009 +0530
+++ b/src-db/database/model/functions/AD_SYNCHRONIZE.xml Fri Aug 14
13:28:44 2009 +1000
@@ -900,6 +900,13 @@
FROM AD_ELEMENT e
WHERE AD_PROCESS_PARA.AD_Element_ID=e.AD_Element_ID
)
+ AND EXISTS
+ (SELECT 1
+ FROM AD_PROCESS P
+ LEFT JOIN AD_MODULE M ON P.AD_MODULE_ID = M.AD_MODULE_ID
+ WHERE AD_PROCESS_PARA.AD_PROCESS_ID = P.AD_PROCESS_ID
+ AND M.ISINDEVELOPMENT='Y'
+ )
;
-- Parameter Fields
DBMS_OUTPUT.PUT_LINE('Synchronize Process Parameter') ;
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
