details: https://code.openbravo.com/erp/devel/pi/rev/30a7643fa5b0
changeset: 15164:30a7643fa5b0
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Tue Jan 17 15:35:03 2012 +0100
summary: issue 19278: Error with parcial "Goods Shipments" and Invoices.
The previous query fails in Oracle
diffstat:
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql | 5
+++--
1 files changed, 3 insertions(+), 2 deletions(-)
diffs (18 lines):
diff -r 65dffb0597a8 -r 30a7643fa5b0
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
--- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
Tue Jan 17 13:30:39 2012 +0100
+++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
Tue Jan 17 15:35:03 2012 +0100
@@ -363,11 +363,12 @@
WHERE o.C_ORDER_ID = s.C_ORDER_ID
AND o.C_ORDER_ID = ic.C_ORDER_ID
AND ic.term = 'N')
- AND (SELECT CASE o.INVOICERULE WHEN 'O' THEN SUM(ol.qtyordered) =
SUM(ol.qtydelivered) ELSE true END
+ AND EXISTS (SELECT 1
FROM C_ORDER o , C_ORDERLINE ol
WHERE o.C_ORDER_ID = s.C_ORDER_ID
AND o.C_ORDER_ID = ol.C_ORDER_ID
- GROUP BY o.INVOICERULE)
+ GROUP BY o.INVOICERULE
+ HAVING o.INVOICERULE <> 'O' OR (SUM(ol.qtyordered) =
SUM(ol.qtydelivered)))
ORDER BY NAME
]]>
</Sql>
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
