[OpenbravoERP-commits] devel/pi: Fixes issue 0022939: Organization of warehouse and org...

[hg]

details:   https://code.openbravo.com/erp/devel/pi/rev/934faa344e9e
changeset: 20233:934faa344e9e
user:      Jon Alegría <jon.alegria <at> openbravo.com>
date:      Mon Apr 29 18:53:21 2013 +0200
summary:   Fixes issue 0022939: Organization of warehouse and organization of 
storage
bins can be different

diffstat:

 src-db/database/model/triggers/M_WAREHOUSE_TRG.xml |  3 +++
 1 files changed, 3 insertions(+), 0 deletions(-)

diffs (13 lines):

diff -r 64fe941faa56 -r 934faa344e9e 
src-db/database/model/triggers/M_WAREHOUSE_TRG.xml
--- a/src-db/database/model/triggers/M_WAREHOUSE_TRG.xml        Mon Apr 29 
18:19:42 2013 +0200
+++ b/src-db/database/model/triggers/M_WAREHOUSE_TRG.xml        Mon Apr 29 
18:53:21 2013 +0200
@@ -74,6 +74,9 @@
   ELSIF (UPDATING) THEN
     UPDATE M_WAREHOUSE_ACCT SET AD_ORG_ID = :new.AD_ORG_ID
     WHERE M_WAREHOUSE_ID = :new.M_WAREHOUSE_ID;
+    
+    UPDATE M_LOCATOR SET AD_ORG_ID = :new.AD_ORG_ID
+    WHERE M_WAREHOUSE_ID = :new.M_WAREHOUSE_ID;
   END IF;
 END M_WAREHOUSE_TRG
 ]]></body>

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits