Set an optional list of values in the requested parameters for all OUs accessible to the current responsibility

Method One:

One of the prerequisites for implementing this requirement is to turn on the multi-service entity access for the request, open the method

System administrator-"System Management-" concurrent-"program, enter the OAF page, query your concurrency, then click Update, select the request, in the business entity mode to select multiple.

Then define the set of values, and the SQL in the value set has three different ways

1.SELECT hou.organization_id, hou.name from hr_all_organization_units Hou WHERE mo_global.check_access ( hou.organization_id) = ' Y ';

2.

SELECT hr.organization_id org_id,
Hr.name Operating_unit,
Po_moac_utils_pvt.get_ou_shortcode (organization_id) Ou_short_code
From Hr_operating_units HR
WHERE po_moac_utils_pvt.check_access (hr.organization_id) = ' Y ';

3.

SELECT organization_id,
Organization_name
From Per_security_organizations_v Psov
WHERE psov.security_profile_id = fnd_profile.value (' Xla_mo_security_profile_level ');

Method Two:

Take advantage of the inventory organization that your current responsibilities can access

There is a standard set of values: Inv_srs_org_access

Set an optional list of values in the requested parameters for all OUs accessible to the current responsibility