DBA Data[Home] [Help]

VIEW: APPS.PA_REP_UTIL_RES_ORGS_V

Source

View Text - Preformatted

SELECT manager_id, organization_id, organization_name FROM pa_rep_res_orgs_v UNION SELECT 0,0, meaning FROM pa_lookups WHERE lookup_type = 'PA_REP_ALL'
View Text - HTML Formatted

SELECT MANAGER_ID
, ORGANIZATION_ID
, ORGANIZATION_NAME
FROM PA_REP_RES_ORGS_V UNION SELECT 0
, 0
, MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'PA_REP_ALL'