details: /erp/devel/pi/rev/fc82f636ea78 changeset: 10539:fc82f636ea78 user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Thu Feb 10 19:56:03 2011 +0100 summary: Fixes issue 15834: @AD_Org_Id@ not working properly
diffstat: src-db/database/sourcedata/AD_COLUMN.xml | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diffs (21 lines): diff -r 3fb281c57568 -r fc82f636ea78 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Thu Feb 10 19:18:19 2011 +0100 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Thu Feb 10 19:56:03 2011 +0100 @@ -263248,7 +263248,7 @@ <!--0445FEDA79A747C48A7B3EF852D176DC--> <AD_TABLE_ID><![CDATA[318]]></AD_TABLE_ID> <!--0445FEDA79A747C48A7B3EF852D176DC--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> <!--0445FEDA79A747C48A7B3EF852D176DC--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> -<!--0445FEDA79A747C48A7B3EF852D176DC--> <DEFAULTVALUE><![CDATA[@SQL=SELECT FIN_Payment_Priority_ID FROM FIN_Payment_Priority WHERE AD_ISORGINCLUDED(@AD_Org_ID@, AD_Org_ID, @#AD_Client_ID@) <> -1 AND Isdefault = 'Y' ORDER BY Priority]]></DEFAULTVALUE> +<!--0445FEDA79A747C48A7B3EF852D176DC--> <DEFAULTVALUE><![CDATA[@SQL=SELECT FIN_Payment_Priority_ID FROM FIN_Payment_Priority WHERE AD_ISORGINCLUDED( (CASE WHEN @#AD_Org_ID@='0' THEN (SELECT ad_org_id FROM ad_org WHERE name = ( SELECT min(o.name) FROM ad_org o join ad_orgtype ot on (o.ad_orgtype_id=ot.ad_orgtype_id) join ad_role_orgaccess ra on (o.ad_org_id=ra.ad_org_id) join ad_role r on (ra.ad_role_id = r.ad_role_id) WHERE ot.istransactionsallowed = 'Y' and r.ad_role_id=@AD_Role_ID@)) ELSE @#AD_Org_ID@ END), AD_Org_ID, @#AD_Client_ID@) <> -1 AND Isdefault = 'Y' ORDER BY Priority]]></DEFAULTVALUE> <!--0445FEDA79A747C48A7B3EF852D176DC--> <ISKEY><![CDATA[N]]></ISKEY> <!--0445FEDA79A747C48A7B3EF852D176DC--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--0445FEDA79A747C48A7B3EF852D176DC--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> @@ -302572,7 +302572,7 @@ <!--831B272EE4364C208EFA70098EDF29B4--> <AD_TABLE_ID><![CDATA[259]]></AD_TABLE_ID> <!--831B272EE4364C208EFA70098EDF29B4--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> <!--831B272EE4364C208EFA70098EDF29B4--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> -<!--831B272EE4364C208EFA70098EDF29B4--> <DEFAULTVALUE><![CDATA[@SQL=SELECT FIN_Payment_Priority_ID FROM FIN_Payment_Priority WHERE AD_ISORGINCLUDED(@AD_Org_ID@, AD_Org_ID, @#AD_Client_ID@) <> -1 AND Isdefault = 'Y' ORDER BY Priority]]></DEFAULTVALUE> +<!--831B272EE4364C208EFA70098EDF29B4--> <DEFAULTVALUE><![CDATA[@SQL=SELECT FIN_Payment_Priority_ID FROM FIN_Payment_Priority WHERE AD_ISORGINCLUDED( (CASE WHEN @#AD_Org_ID@='0' THEN (SELECT ad_org_id FROM ad_org WHERE name = ( SELECT min(o.name) FROM ad_org o join ad_orgtype ot on (o.ad_orgtype_id=ot.ad_orgtype_id) join ad_role_orgaccess ra on (o.ad_org_id=ra.ad_org_id) join ad_role r on (ra.ad_role_id = r.ad_role_id) WHERE ot.istransactionsallowed = 'Y' and r.ad_role_id=@AD_Role_ID@)) ELSE @#AD_Org_ID@ END), AD_Org_ID, @#AD_Client_ID@) <> -1 AND Isdefault = 'Y' ORDER BY Priority]]></DEFAULTVALUE> <!--831B272EE4364C208EFA70098EDF29B4--> <ISKEY><![CDATA[N]]></ISKEY> <!--831B272EE4364C208EFA70098EDF29B4--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--831B272EE4364C208EFA70098EDF29B4--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
