src/org/openbravo/erpCommon/info/DebtPayment_data.xsql
changeset 1605 8a0fe0193bef
parent 712 aa0c40278c5a
child 1796 edf33414f9ba
equal deleted inserted replaced
1604:a1c518e6ed93 1605:8a0fe0193bef
    41 	             AD_REF_LIST RL    left join AD_REF_LIST_TRL RLT on RL.AD_REF_LIST_ID = RLT.AD_REF_LIST_ID
    41 	             AD_REF_LIST RL    left join AD_REF_LIST_TRL RLT on RL.AD_REF_LIST_ID = RLT.AD_REF_LIST_ID
    42 	                                                            AND RLT.AD_LANGUAGE  = ?,
    42 	                                                            AND RLT.AD_LANGUAGE  = ?,
    43 	            C_CURRENCY C
    43 	            C_CURRENCY C
    44 	        WHERE DP.C_CURRENCY_ID = C.C_CURRENCY_ID 
    44 	        WHERE DP.C_CURRENCY_ID = C.C_CURRENCY_ID 
    45 	        AND DP.PAYMENTRULE = RL.VALUE
    45 	        AND DP.PAYMENTRULE = RL.VALUE
    46 	        AND RL.AD_REFERENCE_ID = 195       
    46 	        AND RL.AD_REFERENCE_ID = '195'       
    47 	        AND DP.AD_Client_ID IN ('1') 
    47 	        AND DP.AD_Client_ID IN ('1') 
    48 	        AND DP.AD_Org_ID IN ('1') 
    48 	        AND DP.AD_Org_ID IN ('1') 
    49 	        AND DP.IsActive='Y'
    49 	        AND DP.IsActive='Y'
    50 	        AND DP.IsValid='Y'
    50 	        AND DP.IsValid='Y'
    51 	        ORDER BY DP.C_DEBT_PAYMENT_ID
    51 	        ORDER BY DP.C_DEBT_PAYMENT_ID
    57         <Parameter name="rownum" type="replace" optional="true" after="FROM ( SELECT " text="'0'" />        
    57         <Parameter name="rownum" type="replace" optional="true" after="FROM ( SELECT " text="'0'" />        
    58         <Parameter name="language"/>
    58         <Parameter name="language"/>
    59         <Parameter name="language"/>
    59         <Parameter name="language"/>
    60         <Parameter name="adUserClient" type="replace" optional="true" after="DP.AD_Client_ID IN (" text="'1'"/>
    60         <Parameter name="adUserClient" type="replace" optional="true" after="DP.AD_Client_ID IN (" text="'1'"/>
    61         <Parameter name="adUserOrg" type="replace" optional="true" after="DP.AD_Org_ID IN (" text="'1'"/>
    61         <Parameter name="adUserOrg" type="replace" optional="true" after="DP.AD_Org_ID IN (" text="'1'"/>
    62         <Parameter name="businesPartner" optional="true" after="AND DP.IsValid='Y'"><![CDATA[ AND b.C_BPartner_ID = TO_NUMBER(?) ]]></Parameter>
    62         <Parameter name="businesPartner" optional="true" after="AND DP.IsValid='Y'"><![CDATA[ AND b.C_BPartner_ID=? ]]></Parameter>
    63         <Parameter name="dateFrom" optional="true" after="DP.IsValid='Y'"><![CDATA[ AND dp.Dateplanned >= TO_DATE(?) ]]></Parameter>
    63         <Parameter name="dateFrom" optional="true" after="DP.IsValid='Y'"><![CDATA[ AND dp.Dateplanned >= TO_DATE(?) ]]></Parameter>
    64         <Parameter name="dateTo" optional="true" after="DP.IsValid='Y'"><![CDATA[ AND dp.Dateplanned < TO_DATE(?) ]]></Parameter>
    64         <Parameter name="dateTo" optional="true" after="DP.IsValid='Y'"><![CDATA[ AND dp.Dateplanned < TO_DATE(?) ]]></Parameter>
    65         <Parameter name="AmountFrom" optional="true" after="DP.IsValid='Y'"><![CDATA[ AND dp.amount >= TO_NUMBER(?) ]]></Parameter>
    65         <Parameter name="AmountFrom" optional="true" after="DP.IsValid='Y'"><![CDATA[ AND dp.amount >= TO_NUMBER(?) ]]></Parameter>
    66         <Parameter name="AmountTo" optional="true" after="DP.IsValid='Y'"><![CDATA[ AND dp.amount <= TO_NUMBER(?) ]]></Parameter>
    66         <Parameter name="AmountTo" optional="true" after="DP.IsValid='Y'"><![CDATA[ AND dp.amount <= TO_NUMBER(?) ]]></Parameter>
    67         <Parameter name="paymentRule" optional="true" after="DP.IsValid='Y'"><![CDATA[ AND dp.paymentrule = ? ]]></Parameter>
    67         <Parameter name="paymentRule" optional="true" after="DP.IsValid='Y'"><![CDATA[ AND dp.paymentrule = ? ]]></Parameter>