Related to Issue 25483 : Changed validation for oracle compatibility
authorPandeeswari Ramakrishnan <pandeeswari.ramakrishnan@openbravo.com>
Mon, 07 Apr 2014 18:39:39 +0530
changeset 22881 f0e068c5bbca
parent 22880 d80df926f9ba
child 22882 9083ef3e1844
Related to Issue 25483 : Changed validation for oracle compatibility
src-db/database/sourcedata/AD_VAL_RULE.xml
--- a/src-db/database/sourcedata/AD_VAL_RULE.xml	Mon Apr 07 14:03:23 2014 +0200
+++ b/src-db/database/sourcedata/AD_VAL_RULE.xml	Mon Apr 07 18:39:39 2014 +0530
@@ -1628,7 +1628,7 @@
 <!--6910516E0A54432CA2E6A0C058346F92-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--6910516E0A54432CA2E6A0C058346F92-->  <NAME><![CDATA[Fin_FinancialAccountofPaymentMethod]]></NAME>
 <!--6910516E0A54432CA2E6A0C058346F92-->  <TYPE><![CDATA[S]]></TYPE>
-<!--6910516E0A54432CA2E6A0C058346F92-->  <CODE><![CDATA[Fin_Financial_Account_ID IN (SELECT Fin_Financial_Account_ID FROM Fin_Finacc_Paymentmethod WHERE Fin_Paymentmethod_ID=@Fin_Paymentmethod_ID@ AND CASE WHEN @IsReceipt@='Y' THEN Payin_Allow='Y' ELSE Payout_Allow='Y' END)]]></CODE>
+<!--6910516E0A54432CA2E6A0C058346F92-->  <CODE><![CDATA[Fin_Financial_Account_ID IN (SELECT Fin_Financial_Account_ID FROM Fin_Finacc_Paymentmethod WHERE Fin_Paymentmethod_ID=@Fin_Paymentmethod_ID@ AND (CASE WHEN @IsReceipt@='Y' THEN Payin_Allow  ELSE Payout_Allow END)='Y')]]></CODE>
 <!--6910516E0A54432CA2E6A0C058346F92-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--6910516E0A54432CA2E6A0C058346F92--></AD_VAL_RULE>