[Home] [Help]
View: PA_XLA_EVENT_ORG_REF_V
View Text
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'
Columns
Name |
REV_EVENT_ORG_ID |
REV_EVENT_ORG_COMPANY |
REV_EVENT_ORG_COST_CENTER |