DBA Data[Home] [Help]

VIEW: APPS.HR_OPERATING_UNITS

Source

View Text - Preformatted

SELECT O.BUSINESS_GROUP_ID , O.ORGANIZATION_ID , OTL.NAME , O.DATE_FROM , O.DATE_TO , O3.ORG_INFORMATION5 , O3.ORG_INFORMATION3 , O3.ORG_INFORMATION2 , O3.ORG_INFORMATION6 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 = 'Operating Unit Information' AND O2.ORG_INFORMATION1 = 'OPERATING_UNIT' 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_INFORMATION5
, O3.ORG_INFORMATION3
, O3.ORG_INFORMATION2
, O3.ORG_INFORMATION6
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 = 'OPERATING UNIT INFORMATION'
AND O2.ORG_INFORMATION1 = 'OPERATING_UNIT'
AND O2.ORG_INFORMATION2 = 'Y'
AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')