View: HR_HEADQUARTERS_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.HR_HEADQUARTERS_V

View Text

SELECT O.ORGANIZATION_ID
, O.BUSINESS_GROUP_ID + 0
, O.NAME
, O.DATE_FROM
, O.DATE_TO
, O.INTERNAL_ADDRESS_LINE
, O.COMMENTS
, O.LOCATION_ID
, O2.ORG_INFORMATION1
, O4.ORG_INFORMATION1
, O5.ORG_INFORMATION1
, O4.ORG_INFORMATION2
, O4.ORG_INFORMATION3
, O5.ORG_INFORMATION2
, O4.ORG_INFORMATION4
, O4.ORG_INFORMATION5
FROM HR_ORGANIZATION_UNITS O
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O4
, HR_ORGANIZATION_INFORMATION O5
, HR_ORGANIZATION_INFORMATION O6
, HR_ORGANIZATION_INFORMATION O3
WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O4.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O5.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O6.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O2.ORG_INFORMATION_CONTEXT (+) || '' = 'EMPLOYER IDENTIFICATION'
AND O4.ORG_INFORMATION_CONTEXT (+) || '' = 'EEO-1 FILING'
AND O5.ORG_INFORMATION_CONTEXT (+) || '' = 'VETS-100 FILING'
AND O3.ORG_INFORMATION_CONTEXT || '' = 'CLASS'
AND O3.ORG_INFORMATION1 = 'HR_LEGAL'
AND O3.ORG_INFORMATION2 = 'Y'
AND O6.ORG_INFORMATION_CONTEXT || '' = 'CLASS'
AND O6.ORG_INFORMATION1 = 'US_CRP'
AND O6.ORG_INFORMATION2 = 'Y'

Columns