details: /erp/stable/2.50/rev/6c7a48f22414 changeset: 9200:6c7a48f22414 user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Thu Feb 10 20:01:58 2011 +0100 summary: Fixes issue 15947: @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 594b44d3c391 -r 6c7a48f22414 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Thu Feb 10 19:47:31 2011 +0100 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Thu Feb 10 20:01:58 2011 +0100 @@ -263219,7 +263219,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> @@ -302511,7 +302511,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
