DBA Data[Home] [Help]

VIEW: APPS.PA_REP_UTIL_MGR_ORG_V

Source

View Text - Preformatted

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

SELECT MANAGER_ID
, ORGANIZATION_ID
, MANAGER_NAME
FROM PA_REP_MGR_ORG_V UNION SELECT 0
, 0
, MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'PA_REP_ALL'