[OpenbravoERP-commits] devel/pi: Fixes issue 0022864: Wrong bracket on existsTransactio...

[hg]

details:   https://code.openbravo.com/erp/devel/pi/rev/7814d070ffe3
changeset: 19425:7814d070ffe3
user:      Jon Alegría <jon.alegria <at> openbravo.com>
date:      Thu Jan 24 12:08:50 2013 +0100
summary:   Fixes issue 0022864: Wrong bracket on existsTransactions function in
CostingRuleProcess.java

diffstat:

 src/org/openbravo/costing/CostingRuleProcess.java |  4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diffs (14 lines):

diff -r 83103c66d7ac -r 7814d070ffe3 
src/org/openbravo/costing/CostingRuleProcess.java
--- a/src/org/openbravo/costing/CostingRuleProcess.java Thu Jan 24 11:50:58 
2013 +0100
+++ b/src/org/openbravo/costing/CostingRuleProcess.java Thu Jan 24 12:08:50 
2013 +0100
@@ -176,8 +176,8 @@
     where.append("   and p." + Product.PROPERTY_STOCKED + " = true");
     where.append("   and p." + Product.PROPERTY_ORGANIZATION + ".id in 
(:porgs)");
     where.append("   and exists (select 1 from " + 
MaterialTransaction.ENTITY_NAME);
-    where.append("     where " + MaterialTransaction.PROPERTY_PRODUCT + " = 
p)");
-    where.append("      and " + MaterialTransaction.PROPERTY_ORGANIZATION + " 
.id in (:childOrgs)");
+    where.append("     where " + MaterialTransaction.PROPERTY_PRODUCT + " = 
p");
+    where.append("      and " + MaterialTransaction.PROPERTY_ORGANIZATION + " 
.id in (:childOrgs))");
 
     OBQuery<Product> pQry = OBDal.getInstance().createQuery(Product.class, 
where.toString());
     pQry.setFilterOnReadableOrganization(false);

------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits