details: https://code.openbravo.com/erp/devel/pi/rev/77881ff51216
changeset: 33610:77881ff51216
user: David Miguelez <david.miguelez <at> openbravo.com>
date: Tue Feb 27 11:04:56 2018 +0100
summary: Related to Issue 37882. Adds new column in group by clause
to avoid problems in Oracle.
diffstat:
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql | 2
+-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 38a4c363f9c8 -r 77881ff51216
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
--- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
Mon Feb 26 12:11:05 2018 -0500
+++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
Tue Feb 27 11:04:56 2018 +0100
@@ -357,7 +357,7 @@
l.M_PRODUCT_UOM_ID,l.M_ATTRIBUTESETINSTANCE_ID,
coalesce(l.a_asset_id,i.a_asset_id), coalesce(l.c_project_id,i.c_project_id),
l.AUMQTY, l.C_AUM,
coalesce(l.c_costcenter_id,i.c_costcenter_id) ,
- coalesce(l.user1_id,i.user1_id) , coalesce(l.user2_id, i.user2_id),
l.c_bpartner_id, l.explode, l.bom_parent_id
+ coalesce(l.user1_id,i.user1_id) , coalesce(l.user2_id, i.user2_id),
l.c_bpartner_id, l.explode, l.bom_parent_id, i.C_DOCTYPE_ID
HAVING ((l.explode='Y') OR
(l.QtyInvoiced-SUM(COALESCE(mi.Qty,0))<>0))
ORDER BY NAME, l.Line
]]>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
