VIEW: APPS.HR_COMPANY_COST_CENTERS

Source

View Text - Preformatted

SELECT o.business_group_id, o.organization_id, otl.name, o.date_from, o.date_to, o3.org_information2, o3.org_information3, o3.org_information4, o3.org_information5, o3.org_information1 from hr_all_organization_units o, hr_all_organization_units_tl otl, hr_organization_information o2, hr_organization_information o3 where o.organization_id = o2.organization_id and o.organization_id = o3.organization_id (+) and o2.org_information_context = 'CLASS' and o3.org_information_context(+) = 'Company Cost Center' and o2.org_information1 = 'CC' and o2.org_information2 = 'Y' and o.organization_id = otl.organization_id and otl.language = userenv('LANG')

View Text - HTML Formatted

SELECT O.BUSINESS_GROUP_ID
, O.ORGANIZATION_ID
, OTL.NAME
, O.DATE_FROM
, O.DATE_TO
, O3.ORG_INFORMATION2
, O3.ORG_INFORMATION3
, O3.ORG_INFORMATION4
, O3.ORG_INFORMATION5
, O3.ORG_INFORMATION1
FROM HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OTL
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O3
WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID (+)
AND O2.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O3.ORG_INFORMATION_CONTEXT(+) = 'COMPANY COST CENTER'
AND O2.ORG_INFORMATION1 = 'CC'
AND O2.ORG_INFORMATION2 = 'Y'
AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')