This content has been marked as final. Show 2 replies
EGO_CHANGE_ORGANIZATION is a jsp function. I took the easy route and checked the forms function (MRPCHORG), which I would assume is basically the same code/functionality for the forms environment. A quick trace found the query below. Also, you can configure the organizations available to a responsibility on the Organization Access form.
From the Inventory responsibility: navigate to Setup > Organizations > Organization Access
If I remember correctly, when no records are entered, then all responsibilities have access to all orgs. Once you limit any responsbility, then you have to enter orgs available for all responsibilities.
-- Original query from the change organization form
WHERE responsibility_id = :p_responsibility_id
AND resp_application_id = :p_application_id
ORDER BY organization_code
-- Query to get the parameters for your responsibility
SELECT responsibility_id, application_id
WHERE responsibility_name = :p_responsibility_name
-- combined query
FROM org_access_view oav,
WHERE oav.responsibility_id = fr.responsibility_id
AND oav.resp_application_id = fr.application_id
AND fr.responsibility_name = :p_responsibility_name
ORDER BY oav.organization_code
Hope this helps.