details: https://code.openbravo.com/erp/devel/pi/rev/6bc6e8515310
changeset: 34504:6bc6e8515310
user: Sandra Huguet <sandra.huguet <at> openbravo.com>
date: Fri Aug 10 15:02:15 2018 +0200
summary: related to issue 39017 code review changes
fix group by clause
diffstat:
src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 389e4c0f5e99 -r 6bc6e8515310
src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql Fri Aug
10 14:45:30 2018 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql Fri Aug
10 15:02:15 2018 +0200
@@ -81,7 +81,7 @@
AND M_REQUISITIONLINE.AD_ORG_ID IN ('1')
AND 1=1
GROUP BY M_REQUISITIONLINE.M_REQUISITIONLINE_ID,
M_REQUISITIONLINE.NEEDBYDATE, M_REQUISITIONLINE.QTY,
M_REQUISITIONLINE.ORDEREDQTY,
- QUANTITYORDER, AUMQTY, C_AUM, C_UOM.C_UOM_ID, C_UOM1.NAME, C_UOM.NAME,
C_UOM2.NAME, pl.istaxincluded, pl.M_PRICELIST_ID, M_PRODUCT.NAME,
M_ATTRIBUTESETINSTANCE.DESCRIPTION,
+ QUANTITYORDER, AUMQTY, C_AUM, C_UOM.C_UOM_ID, C_UOM1.NAME, C_UOM.NAME,
C_UOM2.NAME, pl.istaxincluded, pl.name, M_PRODUCT.NAME,
M_ATTRIBUTESETINSTANCE.DESCRIPTION,
AD_USER.NAME, C_BPARTNER.NAME, M_REQUISITIONLINE.GROSS_UNIT_PRICE,
M_REQUISITIONLINE.PRICEACTUAL,
M_REQUISITIONLINE.C_BPARTNER_ID, M_REQUISITION.C_BPARTNER_ID,
M_REQUISITIONLINE.M_PRICELIST_ID, M_REQUISITION.M_PRICELIST_ID,
M_REQUISITIONLINE.M_PRODUCT_ID,
M_REQUISITIONLINE.M_ATTRIBUTESETINSTANCE_ID, M_REQUISITION.AD_USER_ID
------------------------------------------------------------------------------
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
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
