Fixed ISSUE-44175. Removed unused non-public xsql files / SqlMethod. default tip
authorStefan Hühner <stefan.huehner@openbravo.com>
Fri, 22 May 2020 16:35:33 +0200
changeset 37357 181b1d0e3a28
parent 37356 eb7e83516d4d
Fixed ISSUE 44175. Removed unused non-public xsql files / SqlMethod.

All those files / methods are never used and are neither part of the API
So they can be just removed as unused resources.
src/org/openbravo/base/secureApp/Attribute_data.xsql
src/org/openbravo/base/secureApp/Seguridad_data.xsql
src/org/openbravo/common/actionhandler/CashflowForecast_data.xsql
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
src/org/openbravo/erpCommon/ad_callouts/LocatorCombo_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SE_Expense_Amount_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SE_Order_BPartner_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SE_ProjectLine_Value_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SL_Internal_Consumption_Product_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SL_Order_Product_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SL_Order_Stock_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SL_Production_Product_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SL_RequisitionLine_Product_data.xsql
src/org/openbravo/erpCommon/ad_forms/AcctSchema_data.xsql
src/org/openbravo/erpCommon/ad_forms/DocLCCost_data.xsql
src/org/openbravo/erpCommon/ad_forms/DocMatchInv_data.xsql
src/org/openbravo/erpCommon/ad_forms/DocProduction_data.xsql
src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql
src/org/openbravo/erpCommon/ad_forms/ShowSessionPreferences_data.xsql
src/org/openbravo/erpCommon/ad_process/ClientCombo_data.xsql
src/org/openbravo/erpCommon/ad_process/UpdateAuditTrail_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportInvoices_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportProduction_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql
src/org/openbravo/erpCommon/utility/Alert_data.xsql
src/org/openbravo/erpCommon/utility/ReferencedLink_data.xsql
src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql
src/org/openbravo/erpReports/ReportRegisterByVatJR_data.xsql
--- a/src/org/openbravo/base/secureApp/Attribute_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/base/secureApp/Attribute_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -15,20 +15,6 @@
 
 <SqlClass name="AttributeData" package="org.openbravo.base.secureApp">
    <SqlClassComment></SqlClassComment>
-   <SqlMethod name="select" type="preparedStatement" return="multiple">
-      <SqlMethodComment></SqlMethodComment>
-      <Sql><![CDATA[
-        SELECT distinct a.C_ACCTSCHEMA_ID as VALUE, a.C_CURRENCY_ID as Attribute, a.HASALIAS, 
-        ae.ELEMENTTYPE, '' as AD_Window_ID, '' as C_CURRENCY_ID
-        FROM C_AcctSchema a, C_AcctSchema_Element ae 
-        WHERE a.C_AcctSchema_ID=ae.C_ACCTSCHEMA_ID 
-        AND ae.ISACTIVE = 'Y'
-        AND a.AD_CLIENT_ID IN ('1') 
-        AND a.AD_ORG_ID IN ('1')
-      ]]></Sql>
-      <Parameter name="clientlist" optional="true" type="replace" after="AND a.AD_CLIENT_ID IN (" text="'1'"/>
-      <Parameter name="orglist" optional="true" type="replace" after="AND a.AD_ORG_ID IN (" text="'1'"/>
-   </SqlMethod>
    <SqlMethod name="selectAcctSchema" type="preparedStatement" return="multiple">
       <SqlMethodComment></SqlMethodComment>
       <Sql><![CDATA[
--- a/src/org/openbravo/base/secureApp/Seguridad_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/base/secureApp/Seguridad_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -32,18 +32,6 @@
       <Parameter name="adRoleId"/>
       <Parameter name="adUserId"/>
    </SqlMethod>
-   <SqlMethod name="valido" type="preparedStatement" return="String" default="-1">
-      <SqlMethodComment></SqlMethodComment>
-      <Sql>
-        SELECT AD_USER_ID 
-        FROM AD_USER 
-        WHERE ISACTIVE = 'Y' 
-        AND USERNAME = ? 
-        AND PASSWORD = ?
-      </Sql>
-      <Parameter name="user"/>
-      <Parameter name="passwd"/>
-   </SqlMethod>
    <SqlMethod name="loggedOK" type="preparedStatement" return="boolean">
       <SqlMethodComment></SqlMethodComment>
       <Sql>
--- a/src/org/openbravo/common/actionhandler/CashflowForecast_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/common/actionhandler/CashflowForecast_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -176,8 +176,4 @@
     <Parameter name="financialAccountId" optional="true" after="AND 3=3"><![CDATA[ AND fa.fin_financial_account_id = ? ]]></Parameter>
     <Parameter name="datePlanned" optional="true" after="and 4=4"><![CDATA[ AND fat.statementdate <= TO_DATE(?) ]]></Parameter>
   </SqlMethod>
-  <SqlMethod name="set" type="constant" return="multiple">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql></Sql>
-  </SqlMethod>
 </SqlClass>
--- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -888,11 +888,4 @@
     <Field name="rownum" value="count"/>
     <Parameter name="mInoutId"/>
     </SqlMethod>
-    <SqlMethod name="hasSecondaryUOM" type="preparedStatement" return="string">
-      <SqlMethodComment></SqlMethodComment>
-      <Sql><![CDATA[
-        SELECT (CASE WHEN (SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM M_PRODUCT_UOM WHERE M_PRODUCT_ID = ? AND ISACTIVE = 'Y')) IS NULL THEN 0 ELSE 1 END) FROM DUAL
-      ]]></Sql>
-      <Parameter name="mProductId"></Parameter>
-   </SqlMethod>
 </SqlClass>
--- a/src/org/openbravo/erpCommon/ad_callouts/LocatorCombo_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,40 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" ?>
-<!--
- *************************************************************************
- * The contents of this file are subject to the Openbravo  Public  License
- * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
- * Version 1.1  with a permitted attribution clause; you may not  use this
- * file except in compliance with the License. You  may  obtain  a copy of
- * the License at http://www.openbravo.com/legal/license.html 
- * Software distributed under the License  is  distributed  on  an "AS IS"
- * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
- * License for the specific  language  governing  rights  and  limitations
- * under the License. 
- * The Original Code is Openbravo ERP. 
- * The Initial Developer of the Original Code is Openbravo SLU 
- * All portions are Copyright (C) 2001-2011 Openbravo SLU 
- * All Rights Reserved. 
- * Contributor(s):  ______________________________________.
- ************************************************************************
--->
-
-
-    <SqlClass name="LocatorComboData" package="org.openbravo.erpCommon.ad_callouts">
-       <SqlClassComment>Clase LocatorComboData</SqlClassComment>
-       <SqlMethod name="select" type="preparedStatement" return="multiple">
-          <SqlMethodComment>RelaciĆ³n de pasillos de un almacen de la aplicacion</SqlMethodComment>
-          <Sql><![CDATA[
-            SELECT L.M_LOCATOR_ID, AD_COLUMN_IDENTIFIER(TO_CHAR('M_Locator'),TO_CHAR(M_LOCATOR_ID),TO_CHAR(?)) AS NAME, '' AS ID 
-            FROM M_LOCATOR L, M_WAREHOUSE W
-			WHERE W.M_WAREHOUSE_ID = L.M_WAREHOUSE_ID
-            AND L.IsActive='Y' 
-            AND W.M_WAREHOUSE_ID = ? 
-            AND L.AD_Client_ID = ? 
-            ORDER BY NAME
-            
-          ]]></Sql>
-            <Parameter name="language"/>
-            <Parameter name="warehouse"/>
-            <Parameter name="client"/>
-       </SqlMethod>
-    </SqlClass>
--- a/src/org/openbravo/erpCommon/ad_callouts/SE_Expense_Amount_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_callouts/SE_Expense_Amount_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -31,20 +31,6 @@
       ]]>
     </Sql>
   </SqlMethod>
-  <SqlMethod name="selectConvertedAmt" type="preparedStatement" return="String" default="">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-        select c_currency_convert(TO_NUMBER(?),?,?,TO_DATE(?),null, ?,?) from dual
-      ]]>
-    </Sql>
-    <Parameter name="expenseAmount"/>
-    <Parameter name="currencyFrom"/>
-    <Parameter name="currencyTo"/>
-    <Parameter name="dateExpense"/>
-    <Parameter name="client"/>
-    <Parameter name="org"/>
-  </SqlMethod>
   <SqlMethod name="selectPrecision" type="preparedStatement" return="String" default="">
     <SqlMethodComment></SqlMethodComment>
     <Sql>
--- a/src/org/openbravo/erpCommon/ad_callouts/SE_Order_BPartner_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_callouts/SE_Order_BPartner_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -76,19 +76,6 @@
     </Sql>
     <Parameter name="cBpartnerId"/>
   </SqlMethod>
-  <SqlMethod name="selectPaymentTerm" type="preparedStatement" return="String" default="">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-        select c_paymentterm_id 
-        from c_paymentterm 
-        where isactive='Y' 
-        AND isdefault='Y' 
-        AND AD_Client_ID IN ('1') 
-      ]]>
-    </Sql>
-    <Parameter name="clientlist" optional="true" type="replace" after="AND AD_Client_ID IN (" text="'1'"/>
-  </SqlMethod>
   <SqlMethod name="userIdSalesRep" type="preparedStatement" return="String" default="">
     <SqlMethodComment></SqlMethodComment>
     <Sql>
--- a/src/org/openbravo/erpCommon/ad_callouts/SE_ProjectLine_Value_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_callouts/SE_ProjectLine_Value_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -68,8 +68,4 @@
     <Parameter name="mProductId"/>
     <Parameter name="cProjectId"/>    
   </SqlMethod>
-  <SqlMethod name="set" type="constant" return="multiple">
-      <SqlMethodComment></SqlMethodComment>
-      <Sql></Sql>
-   </SqlMethod>
 </SqlClass>
--- a/src/org/openbravo/erpCommon/ad_callouts/SL_Internal_Consumption_Product_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,52 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" ?>
-<!--
- *************************************************************************
- * The contents of this file are subject to the Openbravo  Public  License
- * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
- * Version 1.1  with a permitted attribution clause; you may not  use this
- * file except in compliance with the License. You  may  obtain  a copy of
- * the License at http://www.openbravo.com/legal/license.html 
- * Software distributed under the License  is  distributed  on  an "AS IS"
- * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
- * License for the specific  language  governing  rights  and  limitations
- * under the License. 
- * The Original Code is Openbravo ERP. 
- * The Initial Developer of the Original Code is Openbravo SLU 
- * All portions are Copyright (C) 2001-2010 Openbravo SLU 
- * All Rights Reserved. 
- * Contributor(s):  ______________________________________.
- ************************************************************************
--->
-
-
-
-
-
-<SqlClass name="SLInternalConsumptionProductData" package="org.openbravo.erpCommon.ad_callouts">
-  <SqlMethod name="select" type="preparedStatement" return="multiple">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-      SELECT * FROM DUAL
-      ]]>
-    </Sql>
-  </SqlMethod>
-  <SqlMethod name="selectAttribute" type="preparedStatement" return="String" default="">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      SELECT DESCRIPTION 
-      FROM M_ATTRIBUTESETINSTANCE 
-      WHERE M_ATTRIBUTESETINSTANCE_ID = ?
-    </Sql>
-    <Parameter name="mAttributesetinstanceId"/>
-  </SqlMethod>
-  <SqlMethod name="selectLocator" type="preparedStatement" return="String" default="">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      SELECT VALUE 
-      FROM M_LOCATOR 
-      WHERE M_LOCATOR_ID = ?
-    </Sql>
-    <Parameter name="mLocatorId"/>
-  </SqlMethod>
-</SqlClass>
--- a/src/org/openbravo/erpCommon/ad_callouts/SL_Order_Product_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_callouts/SL_Order_Product_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -30,16 +30,6 @@
     </Sql>
     <Parameter name="cOrderId"/>
   </SqlMethod>
-  <SqlMethod name="selectInvoice" type="preparedStatement" return="multiple">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-      SELECT C_INVOICE_ID AS ID, DATEINVOICED, C_BPARTNER_ID, M_PRICELIST_ID
-      	FROM C_INVOICE WHERE C_INVOICE_ID = ?
-      ]]>
-    </Sql>
-    <Parameter name="cInvoiceId"/>
-  </SqlMethod>
   <!--SqlMethod name="strMProductUOMID" type="preparedStatement" return="String" default="">
     <SqlMethodComment></SqlMethodComment>
     <Sql>
--- a/src/org/openbravo/erpCommon/ad_callouts/SL_Order_Stock_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_callouts/SL_Order_Stock_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -54,12 +54,4 @@
     <Parameter name="cUOMId"/>
     <Parameter name="MAttributesetinstanceID"/>
   </SqlMethod>
-  <SqlMethod name="isSotrx" type="preparedStatement" return="string" default="Y">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      SELECT ISSOTRX FROM C_ORDER
-      WHERE C_ORDER_ID = ?
-    </Sql>
-    <Parameter name="cOrderId"/>
-  </SqlMethod>
 </SqlClass>
--- a/src/org/openbravo/erpCommon/ad_callouts/SL_Production_Product_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,52 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" ?>
-<!--
- *************************************************************************
- * The contents of this file are subject to the Openbravo  Public  License
- * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
- * Version 1.1  with a permitted attribution clause; you may not  use this
- * file except in compliance with the License. You  may  obtain  a copy of
- * the License at http://www.openbravo.com/legal/license.html 
- * Software distributed under the License  is  distributed  on  an "AS IS"
- * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
- * License for the specific  language  governing  rights  and  limitations
- * under the License. 
- * The Original Code is Openbravo ERP. 
- * The Initial Developer of the Original Code is Openbravo SLU 
- * All portions are Copyright (C) 2001-2010 Openbravo SLU 
- * All Rights Reserved. 
- * Contributor(s):  ______________________________________.
- ************************************************************************
--->
-
-
-
-
-
-<SqlClass name="SLProductionProductData" package="org.openbravo.erpCommon.ad_callouts">
-  <SqlMethod name="select" type="preparedStatement" return="multiple">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-      SELECT * FROM DUAL
-      ]]>
-    </Sql>
-  </SqlMethod>
-  <SqlMethod name="selectAttribute" type="preparedStatement" return="String" default="">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      SELECT DESCRIPTION 
-      FROM M_ATTRIBUTESETINSTANCE 
-      WHERE M_ATTRIBUTESETINSTANCE_ID = ?
-    </Sql>
-    <Parameter name="mAttributesetinstanceId"/>
-  </SqlMethod>
-  <SqlMethod name="selectLocator" type="preparedStatement" return="String" default="">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      SELECT VALUE 
-      FROM M_LOCATOR 
-      WHERE M_LOCATOR_ID = ?
-    </Sql>
-    <Parameter name="mLocatorId"/>
-  </SqlMethod>
-</SqlClass>
--- a/src/org/openbravo/erpCommon/ad_callouts/SL_RequisitionLine_Product_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_callouts/SL_RequisitionLine_Product_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -70,13 +70,4 @@
     </Sql>
     <Parameter name="mProductId"/>
   </SqlMethod>
-  <SqlMethod name="attribute" type="preparedStatement" return="String" default="">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      SELECT description 
-      FROM M_AttributeSetInstance 
-      WHERE M_AttributeSetInstance_ID = ? 
-    </Sql>
-    <Parameter name="mAttributesetinstanceId"/>
-  </SqlMethod>
 </SqlClass>
--- a/src/org/openbravo/erpCommon/ad_forms/AcctSchema_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/AcctSchema_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -46,23 +46,6 @@
       </Sql>
     <Parameter name="C_AcctSchema_ID"/>
    </SqlMethod>
-   <SqlMethod name="selectAcctSchemas" type="preparedStatement" return="multiple">
-      <SqlMethodComment></SqlMethodComment>
-      <Sql>
-      <![CDATA[
-		SELECT distinct ad_org_acctschema.C_AcctSchema_ID
-		FROM ad_org_acctschema, c_acctschema
-		WHERE ad_org_acctschema.c_acctschema_id = c_acctschema.c_acctschema_id
-		 and ad_org_acctschema.AD_Client_ID=?
-		 and (ad_isorgincluded(?, ad_org_acctschema.AD_org_ID, ad_org_acctschema.AD_Client_ID) <> -1 OR ? = '0')
-		 and c_acctschema.isactive = 'Y'
-		 and ad_org_acctschema.isactive = 'Y'
-      ]]>
-      </Sql>
-    <Parameter name="AD_Client_ID"/>
-    <Parameter name="AD_Org_ID"/>
-    <Parameter name="AD_Org_ID"/>
-   </SqlMethod>
   <SqlMethod name="selectAcctSchemaTable" type="preparedStatement" return="boolean" default="false">
     <SqlMethodComment></SqlMethodComment>
     <Sql>
--- a/src/org/openbravo/erpCommon/ad_forms/DocLCCost_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/DocLCCost_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -20,17 +20,6 @@
 
 <SqlClass name="DocLCCostData" package="org.openbravo.erpCommon.ad_forms">
   <SqlClassComment></SqlClassComment>
-  <SqlMethod name="select" type="preparedStatement" return="multiple">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-        SELECT '' AS M_LC_COST_ID, '' AS AD_CLIENT_ID, '' AS AD_ORG_ID, '' AS ISACTIVE,
-          '' AS CREATED, '' AS CREATEDBY, '' AS UPDATED, '' AS UPDATEDBY, '' AS DATETRX, '' AS PROCESSING,
-          '' AS PROCESSED, '' AS POSTED, '' AS DATEACCT, '' AS DATEDOC, '' AS C_CURRENCY_ID, '' AS DIFFERENCEAMT
-        FROM DUAL
-      ]]>
-    </Sql>
-  </SqlMethod>
   <SqlMethod name="selectRegistro" type="preparedStatement" return="multiple">
     <SqlMethodComment></SqlMethodComment>
     <Sql>
--- a/src/org/openbravo/erpCommon/ad_forms/DocMatchInv_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/DocMatchInv_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -65,14 +65,6 @@
     <Parameter name="client"/>
     <Parameter name="id"/>
     </SqlMethod>
-  <SqlMethod name="selectProductAverageCost" type="preparedStatement" return="string">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      SELECT COALESCE(M_GET_PRODUCT_COST(?, TO_DATE(?), TO_CHAR(NULL)),0) FROM DUAL
-    </Sql>
-    <Parameter name="mProductID"/>
-    <Parameter name="date"/>
-  </SqlMethod>
   <SqlMethod name="selectInvoiceData" type="preparedStatement" return="multiple">
     <SqlMethodComment></SqlMethodComment>
     <Sql>
--- a/src/org/openbravo/erpCommon/ad_forms/DocProduction_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/DocProduction_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -50,52 +50,4 @@
      <Parameter name="client"/>
      <Parameter name="id"/>
    </SqlMethod>
-
-  <SqlMethod name="selectReceiptAcct" type="preparedStatement" return="multiple">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-        select coalesce(
-          (SELECT C_RECEIVABLE_ACCT 
-          FROM c_bp_customer_acct
-          WHERE C_BPARTNER_ID = ?
-          AND C_AcctSchema_ID = ?
-          AND STATUS = ?),
-          (SELECT C_RECEIVABLE_ACCT 
-          FROM c_bp_customer_acct
-          WHERE C_BPARTNER_ID = ?
-          AND C_AcctSchema_ID = ?
-          AND STATUS is null)) as ACCT from dual
-     ]]>
-     </Sql>
-     <Parameter name="partnerID"/>
-     <Parameter name="AcctSchema"/>
-     <Parameter name="Status"/>
-     <Parameter name="partnerID"/>
-     <Parameter name="AcctSchema"/>
-   </SqlMethod>
-
-   <SqlMethod name="selectNoReceiptAcct" type="preparedStatement" return="multiple">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-        select coalesce (
-          (SELECT V_LIABILITY_ACCT 
-          FROM c_bp_vendor_acct
-          WHERE C_BPARTNER_ID = ?
-          AND C_AcctSchema_ID = ?
-          AND STATUS = ?),
-          (SELECT V_LIABILITY_ACCT
-          FROM c_bp_vendor_acct
-          WHERE C_BPARTNER_ID = ?
-          AND C_AcctSchema_ID = ?
-          AND STATUS is null)) as ACCT from dual
-     ]]>
-     </Sql>
-     <Parameter name="partnerID"/>
-     <Parameter name="AcctSchema"/>
-     <Parameter name="Status"/>
-     <Parameter name="partnerID"/>
-     <Parameter name="AcctSchema"/>
-   </SqlMethod>
  </SqlClass>
--- a/src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -157,18 +157,6 @@
      </Sql>
      <Parameter name="recordID2" optional="false" type="replace" after="Record_ID2 IN (" text="'1'"/>
    </SqlMethod>
-  <SqlMethod name="updateFactAcct" type="preparedStatement" connection="true" return="rowCount">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-        UPDATE Fact_Acct SET FACTACCTTYPE = 'O'
-        WHERE AD_TABLE_ID = ?
-        AND RECORD_ID = ?
-     ]]>
-     </Sql>
-     <Parameter name="table"/>
-     <Parameter name="record"/>
-   </SqlMethod>
   <SqlMethod name="selectLocationFromLocator" type="preparedStatement" return="multiple">
     <SqlMethodComment></SqlMethodComment>
     <Sql>
--- a/src/org/openbravo/erpCommon/ad_forms/ShowSessionPreferences_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/ShowSessionPreferences_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -32,19 +32,6 @@
     ]]></Sql>
     <Parameter name="windows" optional="true" type="argument" after="WHERE ISACTIVE='Y' " text="AND AD_WINDOW.AD_WINDOW_ID IN "/>
   </SqlMethod>
-  <SqlMethod name="selectTrl" type="preparedStatement" return="multiple">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql><![CDATA[
-      SELECT AD_WINDOW.AD_WINDOW_ID AS ID, (CASE WHEN AD_WINDOW_TRL.NAME IS NULL THEN AD_WINDOW.NAME ELSE AD_WINDOW_TRL.NAME END) AS NAME 
-      FROM AD_WINDOW, AD_WINDOW_TRL 
-      WHERE AD_WINDOW.ISACTIVE='Y' 
-      AND AD_WINDOW.AD_WINDOW_ID = AD_WINDOW_TRL.AD_WINDOW_ID
-      AND AD_WINDOW_TRL.AD_LANGUAGE = ? 
-      ORDER BY 2
-    ]]></Sql>
-    <Parameter name="windows" optional="true" type="argument" after="WHERE AD_WINDOW.ISACTIVE='Y' " text="AND AD_WINDOW.AD_WINDOW_ID IN "/>
-    <Parameter name="adLanguage"/>
-  </SqlMethod>
   <SqlMethod name="usuario" type="preparedStatement" return="String" default="">
     <SqlMethodComment></SqlMethodComment>
     <Sql><![CDATA[
--- a/src/org/openbravo/erpCommon/ad_process/ClientCombo_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_process/ClientCombo_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -24,32 +24,6 @@
 
 <SqlClass name="ClientComboData" package="org.openbravo.erpCommon.ad_process">
    <SqlClassComment></SqlClassComment>
-   <SqlMethod name="select" type="preparedStatement" return="multiple">
-      <SqlMethodComment></SqlMethodComment>
-      <Sql>
-        SELECT A_C.AD_CLIENT_ID, A_C.NAME, '' AS ID
-        FROM AD_CLIENT A_C
-        WHERE A_C.ISACTIVE = 'Y'
-        AND EXISTS (SELECT 1 FROM AD_ROLE_ORGACCESS WHERE AD_ROLE_ORGACCESS.AD_CLIENT_ID = A_C.AD_CLIENT_ID AND AD_ROLE_ORGACCESS.AD_ROLE_ID = ? AND AD_ROLE_ORGACCESS.ISACTIVE = 'Y')
-        ORDER BY A_C.NAME
-      </Sql>
-        <Parameter name="rol"/>
-   </SqlMethod>
-
-      <SqlMethod name="selectAllClients" type="preparedStatement" return="multiple">
-      <Sql>
-        SELECT A_C.AD_CLIENT_ID, A_C.NAME 
-        FROM AD_CLIENT A_C
-        ORDER BY A_C.NAME
-      </Sql>
-   </SqlMethod>
-      <SqlMethod name="selectAllClients1" type="preparedStatement" return="multiple">
-      <Sql>
-        SELECT A_C.AD_CLIENT_ID AS ID, A_C.NAME 
-        FROM AD_CLIENT A_C
-        ORDER BY A_C.NAME
-      </Sql>
-   </SqlMethod>
       <SqlMethod name="selectAllClientsNoSystem1" type="preparedStatement" return="multiple">
       <Sql>
         <![CDATA[      
--- a/src/org/openbravo/erpCommon/ad_process/UpdateAuditTrail_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,37 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" ?>
-<!--
- *************************************************************************
- * The contents of this file are subject to the Openbravo  Public  License
- * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
- * Version 1.1  with a permitted attribution clause; you may not  use this
- * file except in compliance with the License. You  may  obtain  a copy of
- * the License at http://www.openbravo.com/legal/license.html
- * Software distributed under the License  is  distributed  on  an "AS IS"
- * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
- * License for the specific  language  governing  rights  and  limitations
- * under the License.
- * The Original Code is Openbravo ERP.
- * The Initial Developer of the Original Code is Openbravo SLU
- * All portions are Copyright (C) 2013 Openbravo SLU
- * All Rights Reserved.
- * Contributor(s):  ______________________________________.
- ************************************************************************
--->
-
-<SqlClass name="UpdateAuditTrailData" package="org.openbravo.erpCommon.ad_process">
-  <SqlMethod name="select" type="preparedStatement" return="multiple">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-        SELECT 1 AS DUMMY FROM DUAL
-      ]]>
-    </Sql>
-  </SqlMethod>
-  <SqlMethod name="updateAuditTrail" type="callableStatement" return="object" object="UpdateAuditTrailData">
-      <SqlMethodComment>procedure AD_Create_Audit_Triggers</SqlMethodComment>
-      <Sql><![CDATA[
-        CALL AD_Create_Audit_Triggers(?)
-      ]]></Sql>
-      <Parameter name="adPinstanceId"></Parameter>
-   </SqlMethod>
-</SqlClass>
--- a/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -20,108 +20,6 @@
 
 <SqlClass name="ReportGeneralLedgerData" package="org.openbravo.erpCommon.ad_reports">
   <SqlClassComment></SqlClassComment>
-  <SqlMethod name="select" type="preparedStatement" return="multiple">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-      SELECT * FROM (
-        SELECT *
-        FROM ( SELECT '0' AS RN1, C.* FROM (
-          SELECT VALUE, NAME, DATEACCT,
-              SUM(AMTACCTDR) AS AMTACCTDR, SUM(AMTACCTCR) AS AMTACCTCR, (SUM(AMTACCTDR)-SUM(AMTACCTCR)) AS TOTAL,
-              FACT_ACCT_GROUP_ID, ID, groupbyid, groupbyname,
-              DESCRIPTION, ISDEBIT,
-              0 AS TOTALACCTDR, 0 AS TOTALACCTCR, 0 AS TOTALACCTSUB,
-              0 AS PREVIOUSDEBIT, 0 AS PREVIOUSCREDIT, 0 AS PREVIOUSTOTAL,
-              0 AS FINALDEBIT, 0 AS FINALCREDIT, 0 AS FINALTOTAL,
-              TO_CHAR(DATEACCT,'J') AS DATEACCTNUMBER,
-              ? AS groupby, '' as bpid, '' as bpname, '' as pdid, '' as pdname, '' as pjid, '' as pjname, 
-              factaccttype, '' as fact_acct_id, 0 AS AMTACCTDRPREVSUM, 0 AS AMTACCTCRPREVSUM
-          FROM
-            (SELECT FACT_ACCT.ACCTVALUE AS VALUE, FACT_ACCT.ACCTDESCRIPTION AS NAME,
-                DATEACCT, AMTACCTDR, AMTACCTCR,
-                FACT_ACCT_GROUP_ID, FACT_ACCT.ACCOUNT_ID AS ID, FACT_ACCT.DESCRIPTION,
-                CASE ?
-                  WHEN 'BPartner' THEN c_bpartner.c_bpartner_id
-                  WHEN 'Product' THEN m_product.m_product_id
-                  WHEN 'Project' THEN c_project.c_project_id
-                  ELSE '' END AS groupbyid,
-                CASE ?
-                  WHEN 'BPartner' THEN (case AD_COLUMN_IDENTIFIER('C_Bpartner',c_bpartner.c_bpartner_id, ?) when '**' then '' else AD_COLUMN_IDENTIFIER('C_Bpartner',c_bpartner.c_bpartner_id, ?) end)
-                  WHEN 'Product' THEN (case  AD_COLUMN_IDENTIFIER('M_Product',m_product.m_product_id, ?) when '**' then '' else AD_COLUMN_IDENTIFIER('M_Product',m_product.m_product_id, ?) end)
-                  WHEN 'Project' THEN (case  AD_COLUMN_IDENTIFIER('C_Project',c_project.c_project_id, ?) when '**' then '' else AD_COLUMN_IDENTIFIER('C_Project',c_project.c_project_id, ?) end)
-                  ELSE '' END AS groupbyname,
-                CASE WHEN (AMTACCTDR > 0 AND AMTACCTCR = 0) OR (AMTACCTCR < 0 AND AMTACCTDR = 0) THEN 'Y' ELSE 'N' END AS ISDEBIT,
-		CASE WHEN FACT_ACCT.FACTACCTTYPE = 'O' THEN 1 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = 'N' THEN 2 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = 'R' THEN 3 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = 'C' THEN 4 END) END) END) END AS FACTACCTTYPE
-            FROM FACT_ACCT
-              LEFT JOIN C_BPARTNER ON FACT_ACCT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
-              LEFT JOIN M_PRODUCT ON FACT_ACCT.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
-              LEFT JOIN C_PROJECT ON FACT_ACCT.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID
-              LEFT JOIN(
-                  select account_id, record_id2, sum(amtacctdr-amtacctcr) as sum
-                  from fact_acct f1
-                  where 5=5
-                  group by account_id, record_id2
-                ) f2 ON fact_acct.account_id = f2.account_id and fact_acct.record_id2 = f2.record_id2
-            WHERE (?='Y' OR FACT_ACCT.ACCOUNT_ID IN (
-                      SELECT c_elementvalue_id as name
-                      FROM C_ELEMENTVALUE
-                      WHERE value >= (  select value from c_elementvalue where c_elementvalue_id = ?)
-                        and value <= (  select value from c_elementvalue where c_elementvalue_id = ?)
-                        and c_elementvalue.ELEMENTLEVEL = 'S'
-                    ))
-              AND FACT_ACCT.AD_ORG_ID IN ('1')
-              AND FACT_ACCT.AD_CLIENT_ID IN ('1')
-              AND (? = 'N' OR (fact_acct.RECORD_ID2 IS NULL) OR (SUM != 0))
-              AND 1=1
-              AND  FACT_ACCT.AD_ORG_ID IN ('2')
-              AND 2=2
-              AND 3=3) D
-            WHERE 6=6
-            GROUP BY groupbyname, groupbyid, VALUE, NAME, ID,
-            DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, DESCRIPTION, ISDEBIT
-            HAVING SUM(AMTACCTDR) - SUM(AMTACCTCR) <> 0
-            ORDER  BY groupbyname, groupbyid, VALUE, NAME, ID,
-            DATEACCT, FACTACCTTYPE,  FACT_ACCT_GROUP_ID, DESCRIPTION, ISDEBIT
-          ) C
-        ) B WHERE 1=1
-      ) A ORDER BY  groupbyname, groupbyid, VALUE, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, DESCRIPTION, ISDEBIT
-      ]]></Sql>
-    <Field name="rownum" value="count"/>
-    <Parameter name="rownum" type="replace" optional="true" after="FROM ( SELECT " text="'0'" />
-    <Parameter name="groupbytext"/>
-    <Parameter name="groupby"/>
-    <Parameter name="groupby"/>
-    <Parameter name="adLanguage"/>
-    <Parameter name="adLanguage"/>
-    <Parameter name="adLanguage"/>
-    <Parameter name="adLanguage"/>
-    <Parameter name="adLanguage"/>
-    <Parameter name="adLanguage"/>
-    <Parameter name="parDateFrom" optional="true" after="where 5=5"><![CDATA[AND DATEACCT >= TO_DATE(?) ]]></Parameter>
-    <Parameter name="parDateTo" optional="true" after="where 5=5"><![CDATA[AND DATEACCT < TO_DATE(?) ]]></Parameter>
-    <Parameter name="allaccounts"/>
-    <Parameter name="accountFrom"/>
-    <Parameter name="accountTo"/>
-    <Parameter name="adUserOrg" type="replace" optional="true" after="AND FACT_ACCT.AD_ORG_ID IN (" text="'1'"/>
-    <Parameter name="adUserClient" type="replace" optional="true" after="AND FACT_ACCT.AD_CLIENT_ID IN (" text="'1'"/>
-    <Parameter name="hideMatched"/>
-    <Parameter name="acctschema" optional="true" after="AND 1=1"><![CDATA[AND FACT_ACCT.C_ACCTSCHEMA_ID = ? ]]></Parameter>
-    <Parameter name="parDateFrom2" optional="true" after="AND 1=1"><![CDATA[AND FACT_ACCT.DATEACCT >= TO_DATE(?) ]]></Parameter>
-    <Parameter name="parDateTo2" optional="true" after="AND 1=1"><![CDATA[AND FACT_ACCT.DATEACCT < TO_DATE(?) ]]></Parameter>
-    <Parameter name="org" type="replace" optional="true" after="AND  FACT_ACCT.AD_ORG_ID IN (" text="'2'"/>
-    <Parameter name="cBpartnerId" optional="true" type="argument" after="AND 2=2"><![CDATA[ AND FACT_ACCT.C_BPARTNER_ID IN]]></Parameter>
-    <Parameter name="mProductId" optional="true" type="argument" after="AND 2=2"><![CDATA[ AND FACT_ACCT.M_PRODUCT_ID IN]]></Parameter>
-    <Parameter name="cProjectId" optional="true" type="argument" after="AND 2=2"><![CDATA[ AND FACT_ACCT.C_PROJECT_ID IN]]></Parameter>
-    <Parameter name="paramAmtFrom" optional="true" after="3=3"><![CDATA[ AND (FACT_ACCT.AMTACCTDR + FACT_ACCT.AMTACCTCR)>=TO_NUMBER(?) ]]></Parameter>
-    <Parameter name="paramAmtTo" optional="true" after="3=3"><![CDATA[ AND (FACT_ACCT.AMTACCTDR + FACT_ACCT.AMTACCTCR)<=TO_NUMBER(?) ]]></Parameter>
-    <Parameter name="accountId" optional="true" after="WHERE 6=6"><![CDATA[AND ID = ? ]]></Parameter>
-    <Parameter name="factAcctId" optional="true" after="WHERE 6=6"><![CDATA[and to_char(DATEACCT,'J')||FACT_ACCT_GROUP_ID||DESCRIPTION||ISDEBIT < ? ]]></Parameter>
-    <Parameter name="cBPartner" optional="true" after="WHERE 6=6"><![CDATA[AND groupbyid = ? ]]></Parameter>
-    <Parameter name="pgLimit" type="argument" optional="true" after=",  FACT_ACCT_GROUP_ID, DESCRIPTION, ISDEBIT"><![CDATA[ LIMIT ]]></Parameter>
-    <Parameter name="oraLimit1" type="argument" optional="true" after=") C"><![CDATA[ WHERE ROWNUM <= ]]></Parameter>
-    <Parameter name="oraLimit2" type="argument" optional="true" after="WHERE 1=1"><![CDATA[ AND RN1 BETWEEN ]]></Parameter>
-  </SqlMethod>
 
   <SqlMethod name="select2" type="preparedStatement" return="scrollable">
     <SqlMethodComment></SqlMethodComment>
@@ -387,77 +285,6 @@
     <Parameter name="factAcctId" optional="true" after="WHERE 1=1"><![CDATA[ and to_char(DATEACCT,'J')||FACTACCTTYPE||FACT_ACCT_GROUP_ID||FACT_ACCT_ID < ? ]]></Parameter>
   </SqlMethod>
 
-  <SqlMethod name="selectXLS" type="preparedStatement" return="multiple">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-      SELECT VALUE, NAME, DATEACCT,
-          SUM(AMTACCTDR) AS AMTACCTDR, SUM(AMTACCTCR) AS AMTACCTCR,
-          FACT_ACCT_GROUP_ID, ID, bpid, bpname, pdid, pdname, pjid, pjname,
-          DESCRIPTION, FACTACCTTYPE
-      FROM
-        (SELECT FACT_ACCT.ACCTVALUE AS VALUE, FACT_ACCT.ACCTDESCRIPTION AS NAME,
-            DATEACCT, AMTACCTDR, AMTACCTCR,
-            FACT_ACCT_GROUP_ID, FACT_ACCT.ACCOUNT_ID AS ID, FACT_ACCT.DESCRIPTION,
-            c_bpartner.c_bpartner_id as bpid, m_product.m_product_id as pdid, c_project.c_project_id as pjid,
-            (case AD_COLUMN_IDENTIFIER('C_Bpartner',c_bpartner.c_bpartner_id, ?) when '**' then '' else AD_COLUMN_IDENTIFIER('C_Bpartner',c_bpartner.c_bpartner_id, ?) end) as bpname, (case AD_COLUMN_IDENTIFIER('M_Product',m_product.m_product_id, ?) when '**' then '' else AD_COLUMN_IDENTIFIER('M_Product',m_product.m_product_id, ?) end) as pdname, (case AD_COLUMN_IDENTIFIER('C_Project',c_project.c_project_id, ?) when '**' then '' else AD_COLUMN_IDENTIFIER('C_Project',c_project.c_project_id, ?) end)  as pjname,
-            CASE WHEN (AMTACCTDR > 0 AND AMTACCTCR = 0) OR (AMTACCTCR < 0 AND AMTACCTDR = 0) THEN 'Y' ELSE 'N' END AS ISDEBIT,
-            CASE WHEN FACT_ACCT.FACTACCTTYPE = 'O' THEN 1 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = 'N' THEN 2 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = 'R' THEN 3 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = 'C' THEN 4 END) END) END) END AS FACTACCTTYPE
-        FROM FACT_ACCT
-          LEFT JOIN C_BPARTNER ON FACT_ACCT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
-          LEFT JOIN M_PRODUCT ON FACT_ACCT.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
-          LEFT JOIN C_PROJECT ON FACT_ACCT.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID
-          LEFT JOIN(
-              select account_id, record_id2, sum(amtacctdr-amtacctcr) as sum
-              from fact_acct f1
-              where 5=5
-              group by account_id, record_id2
-            ) f2 ON fact_acct.account_id = f2.account_id and fact_acct.record_id2 = f2.record_id2
-        WHERE (?='Y' OR FACT_ACCT.ACCOUNT_ID IN (
-                  SELECT c_elementvalue_id as name
-                  FROM C_ELEMENTVALUE
-                  WHERE value >= (  select value from c_elementvalue where c_elementvalue_id = ?)
-                    and value <= (  select value from c_elementvalue where c_elementvalue_id = ?)
-                    and c_elementvalue.ELEMENTLEVEL = 'S'
-                ))
-          AND FACT_ACCT.AD_ORG_ID IN ('1')
-          AND FACT_ACCT.AD_CLIENT_ID IN ('1')
-          AND (? = 'N' OR (fact_acct.RECORD_ID2 IS NULL) OR (SUM != 0))
-          AND 1=1
-          AND  FACT_ACCT.AD_ORG_ID IN ('2')
-          AND 2=2
-          AND 3=3) D
-        WHERE 6=6
-        GROUP BY VALUE, NAME, ID, FACTACCTTYPE, DATEACCT, FACT_ACCT_GROUP_ID, description, bpname, bpid, pdname, pdid, pjname, pjid, ISDEBIT
-        HAVING SUM(AMTACCTDR) - SUM(AMTACCTCR) <> 0
-        ORDER BY VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, description,  bpname, bpid, pdname, pdid, pjname, pjid, ISDEBIT
-      ]]></Sql>
-    <Field name="rownum" value="count"/>
-    <Parameter name="adLanguage"/>
-    <Parameter name="adLanguage"/>
-    <Parameter name="adLanguage"/>
-    <Parameter name="adLanguage"/>
-    <Parameter name="adLanguage"/>
-    <Parameter name="adLanguage"/>
-    <Parameter name="parDateFrom" optional="true" after="where 5=5"><![CDATA[AND DATEACCT >= TO_DATE(?) ]]></Parameter>
-    <Parameter name="parDateTo" optional="true" after="where 5=5"><![CDATA[AND DATEACCT < TO_DATE(?) ]]></Parameter>
-    <Parameter name="allaccounts"/>
-    <Parameter name="accountFrom"/>
-    <Parameter name="accountTo"/>
-    <Parameter name="adUserOrg" type="replace" optional="true" after="AND FACT_ACCT.AD_ORG_ID IN (" text="'1'"/>
-    <Parameter name="adUserClient" type="replace" optional="true" after="AND FACT_ACCT.AD_CLIENT_ID IN (" text="'1'"/>
-    <Parameter name="hideMatched"/>
-    <Parameter name="acctschema" optional="true" after="AND 1=1"><![CDATA[AND FACT_ACCT.C_ACCTSCHEMA_ID = ? ]]></Parameter>
-    <Parameter name="parDateFrom2" optional="true" after="AND 1=1"><![CDATA[AND FACT_ACCT.DATEACCT >= TO_DATE(?) ]]></Parameter>
-    <Parameter name="parDateTo2" optional="true" after="AND 1=1"><![CDATA[AND FACT_ACCT.DATEACCT < TO_DATE(?) ]]></Parameter>
-    <Parameter name="org" type="replace" optional="true" after="AND  FACT_ACCT.AD_ORG_ID IN (" text="'2'"/>
-    <Parameter name="cBpartnerId" optional="true" type="argument" after="AND 2=2"><![CDATA[ AND FACT_ACCT.C_BPARTNER_ID IN]]></Parameter>
-    <Parameter name="mProductId" optional="true" type="argument" after="AND 2=2"><![CDATA[ AND FACT_ACCT.M_PRODUCT_ID IN]]></Parameter>
-    <Parameter name="cProjectId" optional="true" type="argument" after="AND 2=2"><![CDATA[ AND FACT_ACCT.C_PROJECT_ID IN]]></Parameter>
-    <Parameter name="paramAmtFrom" optional="true" after="3=3"><![CDATA[ AND (FACT_ACCT.AMTACCTDR + FACT_ACCT.AMTACCTCR)>=TO_NUMBER(?) ]]></Parameter>
-    <Parameter name="paramAmtTo" optional="true" after="3=3"><![CDATA[ AND (FACT_ACCT.AMTACCTDR + FACT_ACCT.AMTACCTCR)<=TO_NUMBER(?) ]]></Parameter>
-  </SqlMethod>
-
   <SqlMethod name="selectXLS2" type="preparedStatement" return="scrollable">
     <SqlMethodComment></SqlMethodComment>
     <Sql>
@@ -543,42 +370,6 @@
     <Parameter name="org"/>
   </SqlMethod>
 
-  <SqlMethod name="selectTotal" type="preparedStatement" return="multiple">
-      <SqlMethodComment></SqlMethodComment>
-      <Sql><![CDATA[
-      SELECT COALESCE(SUM(AMTACCTDR),0) AS TOTALACCTDR, COALESCE(SUM(AMTACCTCR),0) AS TOTALACCTCR,
-      COALESCE(SUM(AMTACCTDR-AMTACCTCR),0) AS TOTAL
-      FROM FACT_ACCT
-      LEFT JOIN(
-        select account_id, record_id2, sum(amtacctdr-amtacctcr) as sum
-        from fact_acct f1
-        where 5=5
-        group by account_id, record_id2
-      ) f2 ON fact_acct.account_id = f2.account_id and fact_acct.record_id2 = f2.record_id2
-      WHERE 1=1
-      AND FACT_ACCT.ACCOUNT_ID = ?
-      AND DATEACCT >= TO_DATE(?)
-      AND DATEACCT < TO_DATE(?)
-      AND FACT_ACCT.AD_ORG_ID IN ('1')
-      AND (? = 'N' OR ((fact_acct.RECORD_ID2 IS NULL) OR (DATEACCT < TO_DATE(?)) OR (SUM != 0)))
-      ]]></Sql>
-      <Parameter name="dateFrom" optional="true" after="where 5=5"><![CDATA[AND DATEACCT >= TO_DATE(?) ]]></Parameter>
-      <Parameter name="dateTo" optional="true" after="where 5=5"><![CDATA[AND DATEACCT < TO_DATE(?) ]]></Parameter>
-      <Parameter name="bpartner" optional="true" type="argument" after="1=1"><![CDATA[ AND FACT_ACCT.C_BPARTNER_ID IN]]></Parameter>
-      <Parameter name="bpartnerNULL" optional="true" type="argument" after="1=1"><![CDATA[ AND FACT_ACCT.C_BPARTNER_ID IS NULL]]></Parameter>
-      <Parameter name="product" optional="true" type="argument" after="1=1"><![CDATA[ AND FACT_ACCT.M_PRODUCT_ID IN]]></Parameter>
-      <Parameter name="productNULL" optional="true" type="argument" after="1=1"><![CDATA[ AND FACT_ACCT.M_PRODUCT_ID IS NULL]]></Parameter>
-      <Parameter name="project" optional="true" type="argument" after="1=1"><![CDATA[ AND FACT_ACCT.C_PROJECT_ID IN]]></Parameter>
-      <Parameter name="projectNULL" optional="true" type="argument" after="1=1"><![CDATA[ AND FACT_ACCT.C_PROJECT_ID IS NULL]]></Parameter>
-      <Parameter name="acctschema" optional="true" after="1=1"><![CDATA[ AND FACT_ACCT.C_ACCTSCHEMA_ID = ? ]]></Parameter>
-      <Parameter name="account"/>
-      <Parameter name="initialYearBalance"/>
-      <Parameter name="dateTo2"/>
-      <Parameter name="orgs" type="replace" optional="true" after="AND FACT_ACCT.AD_ORG_ID IN (" text="'1'"/>
-      <Parameter name="hideMatched"/>
-      <Parameter name="dateFrom"/>
-   </SqlMethod>
-
   <SqlMethod name="selectTotal2" type="preparedStatement" return="multiple">
       <SqlMethodComment></SqlMethodComment>
       <Sql><![CDATA[
@@ -603,28 +394,6 @@
       <Parameter name="orgs" type="replace" optional="true" after="AND FACT_ACCT.AD_ORG_ID IN (" text="'1'"/>
    </SqlMethod>
    
-  <SqlMethod name="yearInitialDate" type="preparedStatement" return="string">
-      <SqlMethodComment></SqlMethodComment>
-      <Sql><![CDATA[
-      SELECT TO_CHAR(MAX(INI),?) AS STARTDATE
-      FROM
-        (
-        SELECT MIN(P.STARTDATE) AS INI
-        FROM C_YEAR Y, C_PERIOD P, C_PERIODCONTROL PC
-        WHERE Y.C_YEAR_ID = P.C_YEAR_ID
-          AND P.C_PERIOD_ID = PC.C_PERIOD_ID
-          AND P.STARTDATE <= TO_DATE(?)
-          AND PC.AD_CLIENT_ID IN ('1')
-          AND PC.AD_ORG_ID IN ('1')
-        GROUP BY Y.YEAR
-        ) PERIOD
-      ]]></Sql>
-      <Parameter name="dateTemplate"/>
-      <Parameter name="date"/>
-      <Parameter name="client" type="replace" optional="true" after="AND PC.AD_CLIENT_ID IN (" text="'1'"/>
-      <Parameter name="orgs" type="replace" optional="true" after="AND PC.AD_ORG_ID IN (" text="'1'"/>
-   </SqlMethod>
-
   <SqlMethod name="selectSubaccountDescription" type="preparedStatement" return="string">
     <SqlMethodComment></SqlMethodComment>
     <Sql><![CDATA[
@@ -634,20 +403,4 @@
     ]]></Sql>
     <Parameter name="elementValueId"/>
   </SqlMethod>
-  <SqlMethod name="getFinancialOrgs" type="preparedStatement" return="multiple">
-     <SqlMethodComment></SqlMethodComment>
-     <Sql><![CDATA[
-     	SELECT NODE_ID AS ID
-	FROM AD_TREENODE
-	WHERE AD_TREE_ID = ?
-	AND (AD_ISORGINCLUDED(?, NODE_ID, ?) <> -1
-	  OR AD_ISORGINCLUDED(NODE_ID, ?, ?) <> -1)
-     ]]></Sql>
-     <Parameter name="adTreeId"/>
-     <Parameter name="adOrgId"/>
-     <Parameter name="adClientId"/>
-     <Parameter name="adOrgId"/>
-     <Parameter name="adClientId"/>
-  </SqlMethod>
-
 </SqlClass>
--- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoices_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoices_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -118,10 +118,6 @@
     <Parameter name="sales" optional="true" type="none" after="2=2" text="AND I2.ISSOTRX = 'Y'"/>
     <Parameter name="purchase" optional="true" type="none" after="2=2" text="AND I2.ISSOTRX = 'N'"/>
   </SqlMethod>
-  <SqlMethod name="set" type="constant" return="multiple">
-      <SqlMethodComment></SqlMethodComment>
-      <Sql></Sql>
-  </SqlMethod>
   <SqlMethod name="bPartnerDescription" type="preparedStatement" return="String" default="">
     <SqlMethodComment></SqlMethodComment>
     <Sql>
--- a/src/org/openbravo/erpCommon/ad_reports/ReportProduction_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportProduction_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -57,29 +57,4 @@
       <SqlMethodComment></SqlMethodComment>
       <Sql></Sql>
   </SqlMethod>
-  <SqlMethod name="selectSummering" type="preparedStatement" return="multiple">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-    <![CDATA[
-      SELECT M_PRODUCT.NAME AS PRODUCT_NAME, SUM(ROUND(M_PRODUCTIONLINE.MOVEMENTQTY,2)) AS MOVEMENTQTY, C_UOM.NAME AS UOM_NAME
-      FROM M_PRODUCTION, M_PRODUCTIONPLAN, M_PRODUCTIONLINE, M_PRODUCT, C_UOM
-      WHERE M_PRODUCTION.M_PRODUCTION_ID = M_PRODUCTIONPLAN.M_PRODUCTION_ID
-      AND M_PRODUCTIONPLAN.M_PRODUCTIONPLAN_ID = M_PRODUCTIONLINE.M_PRODUCTIONPLAN_ID
-      AND M_PRODUCTIONLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
-      AND M_PRODUCTIONLINE.C_UOM_ID = C_UOM.C_UOM_ID
-      AND M_PRODUCTION.AD_CLIENT_ID IN ('1')
-      AND M_PRODUCTION.AD_ORG_ID IN ('1')
-      AND M_PRODUCTION.PROCESSED = 'Y'
-      AND M_PRODUCTIONLINE.MOVEMENTQTY > 0
-      AND M_PRODUCTION.MOVEMENTDATE >= to_date(?)
-      AND M_PRODUCTION.MOVEMENTDATE < to_date(?)
-      AND M_PRODUCTION.ISSOTRX = 'Y'
-      GROUP BY M_PRODUCT.NAME, C_UOM.NAME
-      HAVING SUM(ROUND(M_PRODUCTIONLINE.MOVEMENTQTY,2)) > 0
-     ]]></Sql>
-      <Parameter name="adUserClient" type="replace" optional="true" after="M_PRODUCTION.AD_CLIENT_ID IN (" text="'1'"/>
-      <Parameter name="adUserOrg" type="replace" optional="true" after="M_PRODUCTION.AD_ORG_ID IN (" text="'1'"/>
-      <Parameter name="dateFrom"/>
-      <Parameter name="dateTo"/>
-  </SqlMethod>
 </SqlClass>
--- a/src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -468,10 +468,6 @@
       <Parameter name="categoryProduct" optional="true" after="WHERE 3 = 3"><![CDATA[ AND pc.M_PRODUCT_CATEGORY_ID= ? ]]></Parameter>
   </SqlMethod>
   
-  <SqlMethod name="set" type="constant" return="multiple">
-      <SqlMethodComment></SqlMethodComment>
-      <Sql></Sql>
-  </SqlMethod>
   <SqlMethod name="getCostingMigrationDate" type="preparedStatement" return="date">
     <SqlMethodComment></SqlMethodComment>
     <Sql>
--- a/src/org/openbravo/erpCommon/utility/Alert_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/utility/Alert_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -25,19 +25,6 @@
    		<![CDATA[
 	       SELECT AD_Alert_ID, AD_Client_ID, AD_Org_ID, IsActive, 
 	              Created, CreatedBy, Updated, UpdatedBy, Description, AD_AlertRule_ID,
-                  AD_Role_ID, AD_User_ID, Record_Id, Referencekey_ID
-      		 FROM AD_Alert
-      		WHERE AD_AlertRule_ID = ?
-      ]]>
-   	</Sql>
-   	<Parameter name="adAlertId" />
-   </SqlMethod>
-   <SqlMethod name="select" type="preparedStatement" return="multiple">
-   	<SqlMethodComment></SqlMethodComment>
-   	<Sql>
-   		<![CDATA[
-	       SELECT AD_Alert_ID, AD_Client_ID, AD_Org_ID, IsActive, 
-	              Created, CreatedBy, Updated, UpdatedBy, Description, AD_AlertRule_ID,
                   AD_Role_ID, AD_User_ID, Record_Id
       		 FROM AD_Alert
       		WHERE AD_AlertRule_ID = ? AND Record_Id = ?
--- a/src/org/openbravo/erpCommon/utility/ReferencedLink_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/utility/ReferencedLink_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -39,17 +39,6 @@
     <Parameter name="adWindowId"/>
     <Parameter name="adTableId"/>
   </SqlMethod>
-   <SqlMethod name="selectWindows" type="preparedStatement" return="multiple">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-        SELECT AD_WINDOW_ID, PO_WINDOW_ID
-        FROM AD_TABLE 
-        WHERE AD_TABLE_ID = ?
-      ]]>
-    </Sql>
-    <Parameter name="adTableId"/>
-  </SqlMethod>
   <SqlMethod name="selectParent" type="preparedStatement" return="multiple">
     <SqlMethodComment></SqlMethodComment>
     <Sql>
--- a/src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -312,16 +312,4 @@
     </Sql>
     <Parameter name="key"/>
   </SqlMethod>
-  
-   <SqlMethod name="selectColumnName" type="preparedStatement" return="string">
-    <SqlMethodComment></SqlMethodComment>
-    <Sql>
-      <![CDATA[
-        SELECT COLUMNNAME as ID
-        FROM AD_COLUMN
-        WHERE AD_column_ID = ?
-      ]]>
-    </Sql>
-    <Parameter name="key"/>
-  </SqlMethod>
 </SqlClass>
--- a/src/org/openbravo/erpReports/ReportRegisterByVatJR_data.xsql	Mon May 18 15:46:01 2020 +0200
+++ b/src/org/openbravo/erpReports/ReportRegisterByVatJR_data.xsql	Fri May 22 16:35:33 2020 +0200
@@ -56,10 +56,5 @@
     <Parameter name="parDateFrom" optional="true" after="and 1=1"><![CDATA[ and taxregline.invoicedate >= to_date(?,'DD/MM/YYYY') ]]></Parameter>
     <Parameter name="parDateTo" optional="true" after="and 1=1"><![CDATA[ and taxregline.invoicedate <= to_date(?,'DD/MM/YYYY')]]></Parameter>
   </SqlMethod>
-
-  <SqlMethod name="set" type="constant" return="multiple">
-      <SqlMethodComment></SqlMethodComment>
-      <Sql></Sql>
-  </SqlMethod>
   
 </SqlClass>