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'
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'
|
|
|