src/org/openbravo/erpCommon/ad_reports/ReportCashFlow_data.xsql
author David Baz Fayos <david.baz@openbravo.com>
Tue, 27 May 2008 15:26:10 +0000
changeset 1044 8691bbc94032
parent 522 d6372e5718ca
child 1156 6aa22c3eac9a
permissions -rw-r--r--
Removed old frame parameter of windowTableId
carlos@0
     1
<?xml version="1.0" encoding="UTF-8" ?>
carlos@0
     2
<!--
carlos@0
     3
 *************************************************************************
carlos@0
     4
 * The contents of this file are subject to the Openbravo  Public  License
carlos@0
     5
 * Version  1.0  (the  "License"),  being   the  Mozilla   Public  License
carlos@0
     6
 * Version 1.1  with a permitted attribution clause; you may not  use this
carlos@0
     7
 * file except in compliance with the License. You  may  obtain  a copy of
carlos@0
     8
 * the License at http://www.openbravo.com/legal/license.html 
carlos@0
     9
 * Software distributed under the License  is  distributed  on  an "AS IS"
carlos@0
    10
 * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
carlos@0
    11
 * License for the specific  language  governing  rights  and  limitations
carlos@0
    12
 * under the License. 
carlos@0
    13
 * The Original Code is Openbravo ERP. 
carlos@0
    14
 * The Initial Developer of the Original Code is Openbravo SL 
carlos@522
    15
 * All portions are Copyright (C) 2001-2008 Openbravo SL 
carlos@0
    16
 * All Rights Reserved. 
carlos@0
    17
 * Contributor(s):  ______________________________________.
carlos@0
    18
 ************************************************************************
carlos@0
    19
-->
carlos@0
    20
carlos@0
    21
carlos@0
    22
<SqlClass name="ReportCashFlowData" package="org.openbravo.erpCommon.ad_reports">
carlos@0
    23
carlos@0
    24
  <SqlMethod name="select" type="preparedStatement" return="multiple">
carlos@0
    25
    <SqlMethodComment></SqlMethodComment>
carlos@0
    26
    <Sql>
carlos@0
    27
      <![CDATA[
carlos@0
    28
          SELECT ? as PARENT, AR.AD_ACCOUNTINGRPT_ELEMENT_ID AS ID, AR.NAME, AR.DESCRIPTION, AR.ISSUMMARY, AR.ISSHOWN, 
carlos@0
    29
          AD_TREENODE.NODE_ID, COALESCE(CASE       
carlos@0
    30
          AR.ISSUMMARY WHEN 'N' THEN      sum(amount) ELSE 0 END,0) AS TOTAL, AR.FILTEREDBYORGANIZATION,       
carlos@0
    31
          AR.TEMPORARYFILTERTYPE, '' AS VALUE, ? AS LEVEL_ACCOUNT, (CASE TO_NUMBER(?) WHEN 0 THEN       
carlos@522
    32
          'SinBordes' ELSE 'SinBordesSinFondo' END) AS CLASS_ACCOUNT, 'TEXT-INDENT: '||TO_CHAR(TO_NUMBER(?)*10)||'pt' AS CLASS_STYLE,
carlos@522
    33
          '' AS PADRE      
carlos@0
    34
          FROM AD_ACCOUNTINGRPT_ELEMENT AR left join (SELECT AMOUNT, C_ACCTSCHEMA_ID
carlos@0
    35
          FROM FACT_ACCT, FACT_ACCT_CFS
carlos@0
    36
          WHERE FACT_ACCT.AD_CLIENT_ID IN ('1')      
carlos@0
    37
          AND FACT_ACCT.AD_ORG_ID IN ('1')
carlos@0
    38
		  AND FACT_ACCT.FACT_ACCT_ID = FACT_ACCT_CFS.FACT_ACCT_ID      
carlos@0
    39
          AND 1=1) A on AR.C_ACCTSCHEMA_ID = A.C_ACCTSCHEMA_ID,       
carlos@0
    40
          AD_TREE, AD_TREENODE      
carlos@0
    41
          WHERE AD_TREE.AD_TREE_ID = AD_TREENODE.AD_TREE_ID      
carlos@0
    42
          AND AD_TREENODE.NODE_ID = AR.AD_ACCOUNTINGRPT_ELEMENT_ID      
carlos@423
    43
          AND AR.AD_ACCOUNTINGRPT_ELEMENT_ID = TO_NUMBER(?)
eduardo@445
    44
          AND A.C_ACCTSCHEMA_ID = TO_NUMBER(?)
carlos@0
    45
          AND AD_TREE.TREETYPE = 'AR'      
carlos@0
    46
          GROUP BY REPORT_TYPE, AR.AD_ACCOUNTINGRPT_ELEMENT_ID, AR.NAME, AR.DESCRIPTION, AR.ISSUMMARY, AR.ISSHOWN, 
carlos@0
    47
          AD_TREENODE.NODE_ID,       
carlos@0
    48
          AR.FILTEREDBYORGANIZATION, AR.TEMPORARYFILTERTYPE 
carlos@0
    49
      ]]>
carlos@0
    50
    </Sql>
carlos@0
    51
    <Parameter name="parent"/>
carlos@0
    52
    <Parameter name="level"/>
carlos@0
    53
    <Parameter name="level"/>
carlos@0
    54
    <Parameter name="level"/>
carlos@0
    55
    <Parameter name="adClientId" optional="true" type="replace" after="FACT_ACCT.AD_CLIENT_ID IN (" text="'1'"/>
carlos@0
    56
    <Parameter name="adOrgId" optional="true" type="replace" after="AND FACT_ACCT.AD_ORG_ID IN (" text="'1'"/>
carlos@423
    57
    <Parameter name="periodFrom" optional="true" after="AND 1=1"><![CDATA[ AND FACT_ACCT.DATEACCT >= TO_DATE(?)]]></Parameter>
carlos@423
    58
    <Parameter name="periodTo" optional="true" after="AND 1=1"><![CDATA[ AND FACT_ACCT.DATEACCT < TO_DATE(?)]]></Parameter>
carlos@423
    59
    <Parameter name="accountId" optional="true" after="AND 1=1"><![CDATA[ AND FACT_ACCT_CFS.ACCOUNT_ID = TO_NUMBER(?)]]></Parameter>
eduardo@445
    60
    <Parameter name="adAccountingElementId"/>    
eduardo@445
    61
    <Parameter name="acctschema"/>
carlos@0
    62
  </SqlMethod>
carlos@0
    63
carlos@0
    64
  <SqlMethod name="selectMissingEntries" type="preparedStatement" return="multiple">
carlos@0
    65
    <SqlMethodComment></SqlMethodComment>
carlos@0
    66
    <Sql>
carlos@0
    67
      <![CDATA[
carlos@0
    68
        SELECT 1 as ID
carlos@0
    69
        FROM FACT_ACCT
carlos@0
    70
        WHERE FACT_ACCT.AD_CLIENT_ID IN ('1')      
carlos@0
    71
        AND FACT_ACCT.AD_ORG_ID IN ('1')
carlos@0
    72
        AND FACT_ACCT.AD_TABLE_ID IN (392,407)
carlos@0
    73
        AND LINE_ID IS NOT NULL
carlos@0
    74
        AND 1=1
carlos@423
    75
        AND AD_CLIENT_ID = TO_NUMBER(?)
carlos@0
    76
        AND NOT EXISTS (SELECT 1 FROM FACT_ACCT_CFS
carlos@0
    77
                WHERE FACT_ACCT.FACT_ACCT_ID = FACT_ACCT_CFS.FACT_ACCT_ID)
carlos@0
    78
      ]]>
carlos@0
    79
    </Sql>
carlos@0
    80
    <Parameter name="adClientId" optional="true" type="replace" after="FACT_ACCT.AD_CLIENT_ID IN (" text="'1'"/>
carlos@0
    81
    <Parameter name="adOrgId" optional="true" type="replace" after="AND FACT_ACCT.AD_ORG_ID IN (" text="'1'"/>
eduardo@445
    82
    <Parameter name="acctschema" optional="true" after="AND 1=1"><![CDATA[ AND FACT_ACCT.C_ACCTSCHEMA_ID = TO_NUMBER(?)]]></Parameter>
carlos@423
    83
    <Parameter name="periodFrom" optional="true" after="AND 1=1"><![CDATA[ AND FACT_ACCT.DATEACCT >= TO_DATE(?)]]></Parameter>
carlos@423
    84
    <Parameter name="periodTo" optional="true" after="AND 1=1"><![CDATA[ AND FACT_ACCT.DATEACCT < TO_DATE(?)]]></Parameter>
carlos@0
    85
    <Parameter name="currentClient"/>
carlos@0
    86
  </SqlMethod>
carlos@0
    87
carlos@0
    88
  <SqlMethod name="set" type="constant" return="multiple">
carlos@0
    89
      <SqlMethodComment></SqlMethodComment>
carlos@0
    90
      <Sql></Sql>
carlos@0
    91
  </SqlMethod>
carlos@0
    92
carlos@0
    93
  <SqlMethod name="selectChild" type="preparedStatement" return="multiple">
carlos@0
    94
    <SqlMethodComment></SqlMethodComment>
carlos@0
    95
    <Sql>
carlos@0
    96
      <![CDATA[
carlos@0
    97
      SELECT AR.AD_ACCOUNTINGRPT_ELEMENT_ID AS ID, AR.NAME, AR.DESCRIPTION, AR.ISSUMMARY, AR.ISSHOWN, AD_TREENODE.NODE_ID, 
carlos@0
    98
      AR.FILTEREDBYORGANIZATION, AR.TEMPORARYFILTERTYPE
carlos@0
    99
      FROM AD_TREE, AD_TREENODE, AD_ACCOUNTINGRPT_ELEMENT AR
carlos@0
   100
      WHERE AD_TREE.AD_TREE_ID = AD_TREENODE.AD_TREE_ID
carlos@0
   101
      AND AD_TREENODE.NODE_ID = AR.AD_ACCOUNTINGRPT_ELEMENT_ID
carlos@0
   102
      AND AR.AD_CLIENT_ID IN ('1')
carlos@0
   103
      AND AR.AD_ORG_ID IN ('1')
carlos@423
   104
      AND AD_TREENODE.PARENT_ID = TO_NUMBER(?)
carlos@423
   105
      AND AD_TREE.AD_TREE_ID = TO_NUMBER(?)
carlos@0
   106
      GROUP BY AR.AD_ACCOUNTINGRPT_ELEMENT_ID, AR.NAME, AR.DESCRIPTION, AR.ISSUMMARY, AR.ISSHOWN, AD_TREENODE.NODE_ID, 
carlos@0
   107
      AR.FILTEREDBYORGANIZATION, AR.TEMPORARYFILTERTYPE, AD_TREENODE.SEQNO
carlos@0
   108
      ORDER BY AD_TREENODE.SEQNO
carlos@0
   109
      ]]>
carlos@0
   110
    </Sql>
carlos@0
   111
    <Parameter name="adClientId" optional="true" type="replace" after="AR.AD_CLIENT_ID IN (" text="'1'"/>
carlos@0
   112
    <Parameter name="adOrgId" optional="true" type="replace" after="AND AR.AD_ORG_ID IN (" text="'1'"/>
carlos@0
   113
    <Parameter name="adAccountingElementId"/>
carlos@0
   114
    <Parameter name="tree"/>
carlos@0
   115
  </SqlMethod>
carlos@0
   116
carlos@0
   117
  <SqlMethod name="selectTree" type="preparedStatement" return="string">
carlos@0
   118
    <SqlMethodComment></SqlMethodComment>
carlos@0
   119
    <Sql>
carlos@0
   120
      <![CDATA[
carlos@0
   121
        SELECT AD_TREE_ID AS ID FROM AD_TREE
carlos@0
   122
        WHERE TREETYPE = 'AR'
carlos@423
   123
        AND AD_CLIENT_ID = TO_NUMBER(?)
carlos@0
   124
      ]]>
carlos@0
   125
    </Sql>
carlos@0
   126
    <Parameter name="client"/>
carlos@0
   127
  </SqlMethod>
carlos@0
   128
carlos@0
   129
  <SqlMethod name="selectOrg" type="preparedStatement" return="multiple">
carlos@0
   130
    <SqlMethodComment></SqlMethodComment>
carlos@0
   131
    <Sql>
carlos@0
   132
      <![CDATA[
carlos@0
   133
      SELECT AD_ORG.AD_ORG_ID AS ID, AD_ORG.NAME, AD_ORG.ISSUMMARY, AD_TREENODE.NODE_ID
carlos@0
   134
      FROM AD_CLIENTINFO, AD_TREENODE, AD_ORG
carlos@0
   135
      WHERE AD_CLIENTINFO.AD_TREE_ORG_ID = AD_TREENODE.AD_TREE_ID
carlos@0
   136
      AND AD_TREENODE.NODE_ID = AD_ORG.AD_ORG_ID
carlos@423
   137
      AND AD_TREENODE.PARENT_ID = TO_NUMBER(?)
carlos@423
   138
      AND AD_CLIENTINFO.AD_CLIENT_ID = TO_NUMBER(?)
carlos@0
   139
      ORDER BY ISSUMMARY DESC
carlos@0
   140
      ]]>
carlos@0
   141
    </Sql>
carlos@0
   142
    <Parameter name="adOrgId"/>
carlos@0
   143
    <Parameter name="adClientId"/>
carlos@0
   144
  </SqlMethod>
carlos@0
   145
carlos@0
   146
  <SqlMethod name="processId" type="preparedStatement" return="String">
carlos@0
   147
    <SqlMethodComment></SqlMethodComment>
carlos@0
   148
    <Sql>
carlos@0
   149
      <![CDATA[
carlos@0
   150
      SELECT AD_PROCESS.AD_PROCESS_ID AS ID
carlos@0
   151
      FROM AD_PROCESS
carlos@0
   152
      WHERE VALUE = ?
carlos@0
   153
      ]]>
carlos@0
   154
    </Sql>
carlos@0
   155
    <Parameter name="processId"/>
carlos@0
   156
  </SqlMethod>
carlos@0
   157
carlos@0
   158
  <SqlMethod name="selectMin" type="preparedStatement" return="String">
carlos@0
   159
    <SqlMethodComment></SqlMethodComment>
carlos@0
   160
    <Sql>
carlos@0
   161
      <![CDATA[
carlos@0
   162
      SELECT MIN(VALUE) AS VALUE
carlos@0
   163
      FROM AD_MONTH
carlos@0
   164
      WHERE QUARTER = ?
carlos@0
   165
      ]]>
carlos@0
   166
    </Sql>
carlos@0
   167
    <Parameter name="quarter"/>
carlos@0
   168
  </SqlMethod>
carlos@0
   169
carlos@0
   170
  <SqlMethod name="selectMax" type="preparedStatement" return="String">
carlos@0
   171
    <SqlMethodComment></SqlMethodComment>
carlos@0
   172
    <Sql>
carlos@0
   173
      <![CDATA[
carlos@0
   174
      SELECT MAX(VALUE) AS VALUE
carlos@0
   175
      FROM AD_MONTH
carlos@0
   176
      WHERE QUARTER = ?
carlos@0
   177
      ]]>
carlos@0
   178
    </Sql>
carlos@0
   179
    <Parameter name="quarter"/>
carlos@0
   180
  </SqlMethod>
carlos@0
   181
carlos@0
   182
  <SqlMethod name="lastDay" type="preparedStatement" return="String">
carlos@0
   183
    <SqlMethodComment></SqlMethodComment>
carlos@0
   184
    <Sql>
carlos@0
   185
      <![CDATA[
carlos@0
   186
      select TO_CHAR(last_day(TO_DATE(?)), to_char(?)) from dual
carlos@0
   187
      ]]>
carlos@0
   188
    </Sql>
carlos@0
   189
    <Parameter name="quarter"/>
carlos@0
   190
    <Parameter name="dateFormat"/>
carlos@0
   191
  </SqlMethod>
carlos@0
   192
carlos@0
   193
  <SqlMethod name="selectFormat" type="preparedStatement" return="String">
carlos@0
   194
    <SqlMethodComment></SqlMethodComment>
carlos@0
   195
    <Sql>
carlos@0
   196
      <![CDATA[
carlos@0
   197
      select TO_CHAR(TO_DATE(?), TO_CHAR(?)) from dual
carlos@0
   198
      ]]>
carlos@0
   199
    </Sql>
carlos@0
   200
    <Parameter name="quarter"/>
carlos@0
   201
    <Parameter name="dateFormat"/>
carlos@0
   202
  </SqlMethod>
carlos@0
   203
carlos@0
   204
  <SqlMethod name="selectAccounting" type="preparedStatement" return="String">
carlos@0
   205
    <SqlMethodComment></SqlMethodComment>
carlos@0
   206
    <Sql>
carlos@0
   207
      <![CDATA[
carlos@0
   208
        SELECT ACCOUNT_ID AS ID
carlos@0
   209
        FROM AD_ACCOUNTINGRPT_ELEMENT
carlos@423
   210
        WHERE AD_ACCOUNTINGRPT_ELEMENT_ID = TO_NUMBER(?)
carlos@0
   211
      ]]>
carlos@0
   212
    </Sql>
carlos@0
   213
    <Parameter name="adAccountingrptElementId"/>
carlos@0
   214
  </SqlMethod>
carlos@0
   215
carlos@0
   216
  <SqlMethod name="selectAD_Accountingrpt_Element_ID" type="preparedStatement" return="multiple">
carlos@0
   217
    <SqlMethodComment></SqlMethodComment>
carlos@0
   218
    <Sql>
carlos@0
   219
      <![CDATA[
carlos@0
   220
      SELECT AD_ACCOUNTINGRPT_ELEMENT_ID AS ID, NAME, FILTEREDBYORGANIZATION, TEMPORARYFILTERTYPE
carlos@0
   221
      FROM AD_ACCOUNTINGRPT_ELEMENT
carlos@0
   222
      WHERE AD_ORG_ID IN ('1')
carlos@0
   223
      AND AD_CLIENT_ID IN ('1')
carlos@0
   224
      AND ISREPORT='Y'
carlos@423
   225
      AND (isActive = 'Y' OR AD_ACCOUNTINGRPT_ELEMENT_ID = TO_NUMBER(?) )
eduardo@445
   226
      AND 1=1
carlos@0
   227
      ]]>
carlos@0
   228
    </Sql>
carlos@0
   229
    <Parameter name="adOrgClient" type="replace" optional="true" after="WHERE AD_ORG_ID IN (" text="'1'"/>
carlos@0
   230
    <Parameter name="adUserClient" type="replace" optional="true" after="AND AD_CLIENT_ID IN (" text="'1'"/>
carlos@0
   231
    <Parameter name="adAccountingrptElementId"/>
eduardo@445
   232
    <Parameter name="acctschema" optional="true" after="AND 1=1"><![CDATA[ AND C_ACCTSCHEMA_ID = TO_NUMBER(?)]]></Parameter>
carlos@0
   233
  </SqlMethod>
carlos@522
   234
  
carlos@522
   235
  <SqlMethod name="selectAD_Accountingrpt_Element_ID_Double" type="preparedStatement" return="multiple">
carlos@522
   236
    <SqlMethodComment></SqlMethodComment>
carlos@522
   237
    <Sql>
carlos@522
   238
      <![CDATA[
carlos@522
   239
      SELECT C_ACCTSCHEMA_ID AS PADRE, AD_ACCOUNTINGRPT_ELEMENT_ID AS ID, NAME, FILTEREDBYORGANIZATION, TEMPORARYFILTERTYPE
carlos@522
   240
      FROM AD_ACCOUNTINGRPT_ELEMENT
carlos@522
   241
      WHERE AD_ORG_ID IN ('1')
carlos@522
   242
      AND AD_CLIENT_ID IN ('1')
carlos@522
   243
      AND ISREPORT='Y'
carlos@522
   244
      AND (isActive = 'Y' OR AD_ACCOUNTINGRPT_ELEMENT_ID = TO_NUMBER(?) )
carlos@522
   245
      AND 1=1
carlos@522
   246
      ]]>
carlos@522
   247
    </Sql>
carlos@522
   248
    <Parameter name="adOrgClient" type="replace" optional="true" after="WHERE AD_ORG_ID IN (" text="'1'"/>
carlos@522
   249
    <Parameter name="adUserClient" type="replace" optional="true" after="AND AD_CLIENT_ID IN (" text="'1'"/>
carlos@522
   250
    <Parameter name="adAccountingrptElementId"/>
carlos@522
   251
  </SqlMethod>
carlos@0
   252
carlos@0
   253
  <SqlMethod name="selectType" type="preparedStatement" return="string">
carlos@0
   254
    <SqlMethodComment></SqlMethodComment>
carlos@0
   255
    <Sql>
carlos@0
   256
      <![CDATA[
carlos@0
   257
      SELECT TEMPORARYFILTERTYPE
carlos@0
   258
      FROM AD_ACCOUNTINGRPT_ELEMENT
carlos@423
   259
      WHERE AD_ACCOUNTINGRPT_ELEMENT_ID = TO_NUMBER(?)
carlos@0
   260
      ]]>
carlos@0
   261
    </Sql>
carlos@0
   262
    <Parameter name="adAccountingrptElementId"/>
carlos@0
   263
  </SqlMethod>
carlos@0
   264
carlos@0
   265
  <SqlMethod name="selectPeriod" type="preparedStatement" return="multiple">
carlos@0
   266
    <SqlMethodComment></SqlMethodComment>
carlos@0
   267
    <Sql>
carlos@0
   268
      <![CDATA[
carlos@0
   269
      SELECT AD_REF_LIST.AD_REF_LIST_ID AS ID, CASE ? WHEN 'en_US' THEN AD_REF_LIST.NAME ELSE AD_REF_LIST_TRL.NAME END AS NAME
carlos@0
   270
	   FROM AD_REF_LIST, AD_REF_LIST_TRL
carlos@0
   271
	   WHERE AD_REF_LIST.AD_REF_LIST_ID = AD_REF_LIST_TRL.AD_REF_LIST_ID
carlos@0
   272
	   AND AD_REF_LIST.AD_CLIENT_ID IN ('1')
carlos@0
   273
	   AND AD_REF_LIST.AD_ORG_ID IN ('1')
carlos@423
   274
	   AND AD_REF_LIST.AD_REFERENCE_ID = TO_NUMBER(?)
carlos@0
   275
      ]]>
carlos@0
   276
    </Sql>
carlos@0
   277
    <Parameter name="adLanguage"/>
carlos@0
   278
    <Parameter name="adOrgClient" type="replace" optional="true" after="AND AD_REF_LIST.AD_CLIENT_ID IN (" text="'1'"/>
carlos@0
   279
    <Parameter name="adUserClient" type="replace" optional="true" after="AND AD_REF_LIST.AD_ORG_ID IN (" text="'1'"/>
carlos@0
   280
    <Parameter name="adAccountingrptElementId"/>
carlos@0
   281
  </SqlMethod>
carlos@0
   282
carlos@0
   283
  <SqlMethod name="selectCombo" type="preparedStatement" return="multiple">
carlos@0
   284
    <SqlMethodComment></SqlMethodComment>
carlos@0
   285
    <Sql>
carlos@0
   286
      <![CDATA[
carlos@0
   287
      SELECT 'M' AS VALUE, TO_CHAR(VALUE) AS ID, TO_CHAR(NAME) AS NAME
carlos@0
   288
      FROM AD_MONTH
carlos@0
   289
      WHERE AD_CLIENT_ID IN ('1')
carlos@0
   290
      AND AD_ORG_ID IN ('1')
carlos@0
   291
      UNION SELECT 'Q' AS VALUE, TO_CHAR(A.VALUE) AS ID, TO_CHAR(A.NAME) AS NAME
carlos@0
   292
      FROM AD_MONTH, AD_REF_LIST_V A
carlos@0
   293
      WHERE AD_CLIENT_ID  IN ('2')
carlos@0
   294
      AND AD_ORG_ID  IN ('2')
carlos@0
   295
      AND AD_MONTH.QUARTER = A.VALUE
carlos@0
   296
      AND AD_REFERENCE_ID = 800027
carlos@0
   297
      AND AD_LANGUAGE = ?
carlos@0
   298
      UNION SELECT 'A' AS VALUE, TO_CHAR(YEAR) AS ID, TO_CHAR(YEAR) AS NAME
carlos@0
   299
      FROM C_YEAR
carlos@0
   300
      ]]>
carlos@0
   301
    </Sql>
carlos@0
   302
    <Parameter name="adOrgClient" type="replace" optional="true" after="WHERE AD_CLIENT_ID IN (" text="'1'"/>
carlos@0
   303
    <Parameter name="adUserClient" type="replace" optional="true" after="AND AD_ORG_ID IN (" text="'1'"/>
carlos@0
   304
    <Parameter name="adOrgClient" type="replace" optional="true" after="WHERE AD_CLIENT_ID  IN (" text="'2'"/>
carlos@0
   305
    <Parameter name="adUserClient" type="replace" optional="true" after="AND AD_ORG_ID  IN (" text="'2'"/>
carlos@0
   306
    <Parameter name="adLanguage"/>
carlos@0
   307
  </SqlMethod>
carlos@0
   308
carlos@0
   309
carlos@0
   310
</SqlClass>