details: http://code.openbravo.com/erp/devel/pi/rev/95db755fa2f6 changeset: 3528:95db755fa2f6 user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> date: Mon Apr 06 19:07:04 2009 +0200 summary: Missing validation for accounting templates
diffstat: src-db/database/sourcedata/AD_VAL_RULE.xml | 35 +++++++++++++++++++++++------------ 1 files changed, 23 insertions(+), 12 deletions(-) diffs (75 lines): diff -r 842f7e3f0833 -r 95db755fa2f6 src-db/database/sourcedata/AD_VAL_RULE.xml --- a/src-db/database/sourcedata/AD_VAL_RULE.xml Mon Apr 06 18:52:06 2009 +0200 +++ b/src-db/database/sourcedata/AD_VAL_RULE.xml Mon Apr 06 19:07:04 2009 +0200 @@ -1026,9 +1026,9 @@ <!--800021--> <DESCRIPTION><![CDATA[Filter User's Role]]></DESCRIPTION> <!--800021--> <TYPE><![CDATA[S]]></TYPE> <!--800021--> <CODE><![CDATA[EXISTS ( SELECT 1 - FROM AD_USER_ROLES A_U_R + FROM AD_USER_ROLES A_U_R WHERE A_U_R.AD_ROLE_ID = AD_Role.AD_Role_ID - AND A_U_R.ISACTIVE = 'Y' + AND A_U_R.ISACTIVE = 'Y' AND A_U_R.AD_USER_ID = @AD_User_ID@)]]></CODE> <!--800021--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--800021--></AD_VAL_RULE> @@ -1054,12 +1054,12 @@ <!--800023--> <DESCRIPTION><![CDATA[Filter Organization by Role]]></DESCRIPTION> <!--800023--> <TYPE><![CDATA[S]]></TYPE> <!--800023--> <CODE><![CDATA[EXISTS (SELECT 1 FROM AD_ROLE_ORGACCESS A_R_O, ad_role r - WHERE A_R_O.AD_ORG_ID = AD_ORG.AD_Org_ID - AND A_R_O.ISACTIVE = 'Y' - AND A_R_O.AD_ROLE_ID = R.AD_ROLE_ID - and r.ad_role_id = @Default_AD_Role_ID@ - AND R.ISACTIVE = 'Y' - AND (LPAD(TO_CHAR(R.USERLEVEL), 1, '1')='S' OR AD_ORG.AD_ORG_ID <> '0') + WHERE A_R_O.AD_ORG_ID = AD_ORG.AD_Org_ID + AND A_R_O.ISACTIVE = 'Y' + AND A_R_O.AD_ROLE_ID = R.AD_ROLE_ID + and r.ad_role_id = @Default_AD_Role_ID@ + AND R.ISACTIVE = 'Y' + AND (LPAD(TO_CHAR(R.USERLEVEL), 1, '1')='S' OR AD_ORG.AD_ORG_ID <> '0') AND A_R_O.AD_ROLE_ID = @Default_AD_Role_ID@)]]></CODE> <!--800023--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--800023--></AD_VAL_RULE> @@ -1246,10 +1246,10 @@ <!--324A9767D9B94A8A8154DEB3ACA6E063--> <NAME><![CDATA[Business Partner Withholding]]></NAME> <!--324A9767D9B94A8A8154DEB3ACA6E063--> <DESCRIPTION><![CDATA[Show the Withholdings which belong to the Business Partner]]></DESCRIPTION> <!--324A9767D9B94A8A8154DEB3ACA6E063--> <TYPE><![CDATA[S]]></TYPE> -<!--324A9767D9B94A8A8154DEB3ACA6E063--> <CODE><![CDATA[EXISTS (SELECT 1 - FROM C_BP_Withholding w , C_BPartner b +<!--324A9767D9B94A8A8154DEB3ACA6E063--> <CODE><![CDATA[EXISTS (SELECT 1 + FROM C_BP_Withholding w , C_BPartner b WHERE w.C_BPartner_ID=b.C_BPartner_ID - AND w.C_Withholding_ID=C_Withholding.C_Withholding_ID + AND w.C_Withholding_ID=C_Withholding.C_Withholding_ID AND w.c_bpartner_...@c_bpartner_id@)]]></CODE> <!--324A9767D9B94A8A8154DEB3ACA6E063--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--324A9767D9B94A8A8154DEB3ACA6E063--></AD_VAL_RULE> @@ -1325,6 +1325,17 @@ <!--80418A74E20E4D2590CF848E90D7CD6D--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--80418A74E20E4D2590CF848E90D7CD6D--></AD_VAL_RULE> +<!--8195248D186A4DEC89938C45837A1BCB--><AD_VAL_RULE> +<!--8195248D186A4DEC89938C45837A1BCB--> <AD_VAL_RULE_ID><![CDATA[8195248D186A4DEC89938C45837A1BCB]]></AD_VAL_RULE_ID> +<!--8195248D186A4DEC89938C45837A1BCB--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--8195248D186A4DEC89938C45837A1BCB--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--8195248D186A4DEC89938C45837A1BCB--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--8195248D186A4DEC89938C45837A1BCB--> <NAME><![CDATA[AD_Table Acctschema table]]></NAME> +<!--8195248D186A4DEC89938C45837A1BCB--> <TYPE><![CDATA[S]]></TYPE> +<!--8195248D186A4DEC89938C45837A1BCB--> <CODE><![cdata[ad_createfact_template.ad_table_...@ad_table_id@]]></CODE> +<!--8195248D186A4DEC89938C45837A1BCB--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--8195248D186A4DEC89938C45837A1BCB--></AD_VAL_RULE> + <!--8286A51A2C2C494798EABA6D27CA534D--><AD_VAL_RULE> <!--8286A51A2C2C494798EABA6D27CA534D--> <AD_VAL_RULE_ID><![CDATA[8286A51A2C2C494798EABA6D27CA534D]]></AD_VAL_RULE_ID> <!--8286A51A2C2C494798EABA6D27CA534D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1343,7 +1354,7 @@ and ad_dataset.accesslevel = '6')) OR (ad_table.accesslevel in ('3','7') and exists(select 1 from ad_dataset where ad_dataset_id = @AD_DATASET_ID@ - and ad_dataset.accesslevel = '3')) + and ad_dataset.accesslevel = '3')) )]]></CODE> <!--8286A51A2C2C494798EABA6D27CA534D--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--8286A51A2C2C494798EABA6D27CA534D--></AD_VAL_RULE> ------------------------------------------------------------------------------ This SF.net email is sponsored by: High Quality Requirements in a Collaborative Environment. Download a free trial of Rational Requirements Composer Now! http://p.sf.net/sfu/www-ibm-com _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits