[Home] [Help]
View: PA_XLA_EXP_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 HROU.ORGANIZATION_ID = HROI.ORGANIZATION_ID(+)
AND HROI.ORG_INFORMATION_CONTEXT (+) = 'COMPANY COST CENTER'
Columns
Name |
EXPENDITURE_ORGANIZATION_ID |
EXP_ORG_COMPANY |
EXP_ORG_COST_CENTER |