Fixes issue 8952: Duplicated records in Copy Lines button in Sales Order Window
authorRakhee Mohanlal <rakhee.mohanlal@openbravo.com>
Tue, 30 Jun 2009 13:01:05 +0530
changeset 4073 494695dc653b
parent 4072 7f9b17719565
child 4074 0e7e33c1eed4
Fixes issue 8952: Duplicated records in Copy Lines button in Sales Order Window
src/org/openbravo/erpCommon/ad_actionButton/CopyFromOrder_data.xsql
--- a/src/org/openbravo/erpCommon/ad_actionButton/CopyFromOrder_data.xsql	Mon Jun 29 16:05:18 2009 +0200
+++ b/src/org/openbravo/erpCommon/ad_actionButton/CopyFromOrder_data.xsql	Tue Jun 30 13:01:05 2009 +0530
@@ -27,7 +27,7 @@
     <SqlMethodComment></SqlMethodComment>
     <Sql>
       <![CDATA[
-        SELECT M_PRODUCT_ID, PRODUCTNAME, M_ATTRIBUTESETINSTANCE_ID, DESCRIPTION, CLASS_OFFER,
+        SELECT DISTINCT M_PRODUCT_ID, PRODUCTNAME, M_ATTRIBUTESETINSTANCE_ID, DESCRIPTION, CLASS_OFFER,
         OFFER_NAME, PRICESTD, LASTPRICESO, C_TAX_ID, NAMETAX, C_UOM_ID, UOMSYMBOL, '0' AS QTY, '' AS PRICELIMIT, '' AS PRICELIST, '' AS STDPRECISION, '' AS PRICEPRECISION FROM (
         SELECT CL.M_PRODUCT_ID AS M_PRODUCT_ID, M.NAME AS PRODUCTNAME,
         MA.M_ATTRIBUTESETINSTANCE_ID AS M_ATTRIBUTESETINSTANCE_ID, MA.DESCRIPTION AS DESCRIPTION,