Bug 0006783 Reverted commit 11699.
authorRafa Roda Palacios <rafael.roda@openbravo.com>
Wed, 14 Jan 2009 14:03:19 +0000
changeset 2585 eec65c012021
parent 2584 7fa6d984c0d3
child 2586 683779f1e610
Bug 0006783 Reverted commit 11699.
src/org/openbravo/erpCommon/ad_reports/InoutEdition_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportInvoices_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoice_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvided_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/InoutEdition_data.xsql	Wed Jan 14 12:48:54 2009 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/InoutEdition_data.xsql	Wed Jan 14 14:03:19 2009 +0000
@@ -65,7 +65,6 @@
       AND M_INOUT.M_INOUT_ID = M_INOUTLINE.M_INOUT_ID
       AND M_INOUTLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
       AND M_INOUTLINE.C_UOM_ID = C_UOM.C_UOM_ID
-      AND C_BPARTNER.ISACTIVE = 'Y' 
       AND M_INOUT.AD_ORG_ID IN ('1')
       AND M_INOUT.AD_CLIENT_ID IN ('1')
       AND 1=1
--- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoices_data.xsql	Wed Jan 14 12:48:54 2009 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoices_data.xsql	Wed Jan 14 14:03:19 2009 +0000
@@ -54,7 +54,6 @@
       AND IL.C_INVOICELINE_ID = C_INVOICELINE.C_INVOICELINE_ID
       AND C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID
       AND C_INVOICELINE.C_TAX_ID = C_TAX.C_TAX_ID
-      AND B.ISACTIVE = 'Y'
       AND I.AD_Client_ID IN ('1')
       AND I.AD_ORG_ID IN ('1')
       AND 1=1
@@ -78,7 +77,6 @@
       AND IL.C_BPARTNER_ID = B.C_BPARTNER_ID
       AND C_INVOICETAX.C_INVOICE_ID= I2.C_INVOICE_ID
       AND C_INVOICETAX.C_TAX_ID = C_TAX.C_TAX_ID
-      AND B.ISACTIVE = 'Y'
       AND I2.AD_Client_ID IN ('2')
       AND I2.AD_ORG_ID IN ('2')
       AND 2=2) A
--- a/src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoice_data.xsql	Wed Jan 14 12:48:54 2009 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoice_data.xsql	Wed Jan 14 14:03:19 2009 +0000
@@ -65,8 +65,7 @@
       AND AD_REF_LIST.AD_REFERENCE_ID = '150'
       AND C_ORDER.PROCESSED = 'Y'
       AND C_ORDER.ISSOTRX = 'Y'
-      AND C_ORDERLINE.QTYORDERED<>C_ORDERLINE.QTYINVOICED
-      AND C_BPARTNER.ISACTIVE = 'Y' 
+      AND C_ORDERLINE.QTYORDERED<>C_ORDERLINE.QTYINVOICED 
       AND C_ORDER.AD_Client_ID IN ('1')
       AND C_ORDER.AD_ORG_ID IN ('1')
       AND 1=1
@@ -106,7 +105,6 @@
                  WHERE C2.c_order_id = C.c_order_id
                  and c2.c_order_id=cl.c_order_id
                  and cl.QTYORDERED<>cl.QTYINVOICED)
-      AND C_BPARTNER.ISACTIVE = 'Y' 
       AND C.AD_Client_ID IN ('2')
       AND C.AD_ORG_ID IN ('2')
       AND 2=2
--- a/src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql	Wed Jan 14 12:48:54 2009 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql	Wed Jan 14 14:03:19 2009 +0000
@@ -52,7 +52,6 @@
       WHERE C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID
       AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
       AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID
-      AND C_BPARTNER.ISACTIVE = 'Y'
       AND C_ORDER.AD_CLIENT_ID IN ('1')
       AND C_ORDER.AD_ORG_ID IN ('1')
       AND 1=1
--- a/src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvided_data.xsql	Wed Jan 14 12:48:54 2009 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvided_data.xsql	Wed Jan 14 14:03:19 2009 +0000
@@ -50,7 +50,6 @@
       WHERE C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID 
       AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
       AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID
-      AND C_BPARTNER.ISACTIVE = 'Y'
       AND C_ORDER.AD_CLIENT_ID IN ('1')
       AND C_ORDER.AD_ORG_ID IN ('1')
       AND 1=1