DBA Data[Home] [Help]

VIEW: APPS.PA_XLA_EVENT_ORG_REF_V

Source

View Text - Preformatted

SELECT hrou.organization_id, hroi.org_information3, hroi.org_information5 from hr_all_organization_units hrou, hr_organization_information hroi WHERE hroi.organization_id (+) = hrou.organization_id and hroi.org_information_context(+) = 'Company Cost Center'
View Text - HTML Formatted

SELECT HROU.ORGANIZATION_ID
, HROI.ORG_INFORMATION3
, HROI.ORG_INFORMATION5
FROM HR_ALL_ORGANIZATION_UNITS HROU
, HR_ORGANIZATION_INFORMATION HROI
WHERE HROI.ORGANIZATION_ID (+) = HROU.ORGANIZATION_ID
AND HROI.ORG_INFORMATION_CONTEXT(+) = 'COMPANY COST CENTER'