VIEW: APPS.HR_AAP_ORGANIZATIONS_V

Source

View Text - Preformatted

SELECT HOU.ORGANIZATION_ID , HOU.BUSINESS_GROUP_ID + 0 , HOU.NAME , O3.ORG_INFORMATION1 , HOU.DATE_FROM , HOU.DATE_TO FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION O3, HR_ORGANIZATION_INFORMATION O2 WHERE HOU.ORGANIZATION_ID = O3.ORGANIZATION_ID (+) AND HOU.ORGANIZATION_ID = O2.ORGANIZATION_ID AND O3.ORG_INFORMATION_CONTEXT (+) = 'AAP Organization' AND O2.ORG_INFORMATION_CONTEXT||'' = 'CLASS' AND O2.ORG_INFORMATION1 = 'HR_AAP' AND O2.ORG_INFORMATION2 = 'Y'

View Text - HTML Formatted

SELECT HOU.ORGANIZATION_ID
, HOU.BUSINESS_GROUP_ID + 0
, HOU.NAME
, O3.ORG_INFORMATION1
, HOU.DATE_FROM
, HOU.DATE_TO
FROM HR_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_INFORMATION O3
, HR_ORGANIZATION_INFORMATION O2
WHERE HOU.ORGANIZATION_ID = O3.ORGANIZATION_ID (+)
AND HOU.ORGANIZATION_ID = O2.ORGANIZATION_ID
AND O3.ORG_INFORMATION_CONTEXT (+) = 'AAP ORGANIZATION'
AND O2.ORG_INFORMATION_CONTEXT||'' = 'CLASS'
AND O2.ORG_INFORMATION1 = 'HR_AAP'
AND O2.ORG_INFORMATION2 = 'Y'