VIEW: APPS.HR_ESTABLISHMENTS_V

Source

View Text - Preformatted

SELECT HOU.ORGANIZATION_ID , HOU.BUSINESS_GROUP_ID + 0 , HOU.NAME , HOU.DATE_FROM , HOU.DATE_TO , HOU.TYPE , HOU.INTERNAL_ADDRESS_LINE , HOU.COMMENTS , HOU.LOCATION_ID , O3.ORG_INFORMATION2 , O4.ORG_INFORMATION1 , O3.ORG_INFORMATION3 , O4.ORG_INFORMATION2 , O3.ORG_INFORMATION4 , O3.ORG_INFORMATION5 , O3.ORG_INFORMATION6 , O3.ORG_INFORMATION7 , O3.ORG_INFORMATION8 , O3.ORG_INFORMATION10 , O3.ORG_INFORMATION11 FROM HR_ALL_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION O4, HR_ORGANIZATION_INFORMATION O3, HR_ORGANIZATION_INFORMATION O2 WHERE HOU.ORGANIZATION_ID = O3.ORGANIZATION_ID (+) AND HOU.ORGANIZATION_ID = O2.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = O4.ORGANIZATION_ID (+) AND O3.ORG_INFORMATION_CONTEXT (+) = 'Establishment EEO-1 Filing' AND O4.ORG_INFORMATION_CONTEXT (+) = 'Establishment VETS-100 Filing' AND O2.ORG_INFORMATION_CONTEXT||'' = 'CLASS' AND O2.ORG_INFORMATION1 = 'HR_ESTAB' AND O2.ORG_INFORMATION2 = 'Y'

View Text - HTML Formatted

SELECT HOU.ORGANIZATION_ID
, HOU.BUSINESS_GROUP_ID + 0
, HOU.NAME
, HOU.DATE_FROM
, HOU.DATE_TO
, HOU.TYPE
, HOU.INTERNAL_ADDRESS_LINE
, HOU.COMMENTS
, HOU.LOCATION_ID
, O3.ORG_INFORMATION2
, O4.ORG_INFORMATION1
, O3.ORG_INFORMATION3
, O4.ORG_INFORMATION2
, O3.ORG_INFORMATION4
, O3.ORG_INFORMATION5
, O3.ORG_INFORMATION6
, O3.ORG_INFORMATION7
, O3.ORG_INFORMATION8
, O3.ORG_INFORMATION10
, O3.ORG_INFORMATION11
FROM HR_ALL_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_INFORMATION O4
, HR_ORGANIZATION_INFORMATION O3
, HR_ORGANIZATION_INFORMATION O2
WHERE HOU.ORGANIZATION_ID = O3.ORGANIZATION_ID (+)
AND HOU.ORGANIZATION_ID = O2.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = O4.ORGANIZATION_ID (+)
AND O3.ORG_INFORMATION_CONTEXT (+) = 'ESTABLISHMENT EEO-1 FILING'
AND O4.ORG_INFORMATION_CONTEXT (+) = 'ESTABLISHMENT VETS-100 FILING'
AND O2.ORG_INFORMATION_CONTEXT||'' = 'CLASS'
AND O2.ORG_INFORMATION1 = 'HR_ESTAB'
AND O2.ORG_INFORMATION2 = 'Y'