View: HR_AU_LEG_EMP_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.HR_AU_LEG_EMP_V

View Text

SELECT OU.ORGANIZATION_ID
, OU.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, OU.NAME
, OU.DATE_FROM
, OU.DATE_TO
, OU.TYPE
, OU.INTERNAL_ADDRESS_LINE
, OU.COMMENTS
, OU.LOCATION_ID
, OI1.ORG_INFORMATION1
, L.ADDRESS_LINE_1
, L.ADDRESS_LINE_2
, L.ADDRESS_LINE_3
, L.TOWN_OR_CITY
, L.POSTAL_CODE
, L.COUNTRY
FROM HR_ALL_ORGANIZATION_UNITS OU
, HR_ORGANIZATION_INFORMATION OI1
, HR_ORGANIZATION_INFORMATION OI2
, HR_LOCATIONS L
WHERE OU.ORGANIZATION_ID = OI1.ORGANIZATION_ID (+)
AND OU.ORGANIZATION_ID = OI2.ORGANIZATION_ID
AND OI1.ORG_INFORMATION_CONTEXT || '' = 'AU_LEGAL_EMPLOYER'
AND OI2.ORG_INFORMATION_CONTEXT || '' = 'CLASS'
AND OI2.ORG_INFORMATION1 = 'HR_LEGAL'
AND OI2.ORG_INFORMATION2 = 'Y'
AND L.LOCATION_ID (+) = OU.LOCATION_ID

Columns