[Home] [Help]
View: HR_HK_LEGAL_EMPLOYER_V
View Text
SELECT OU.ORGANIZATION_ID
, OU.BUSINESS_GROUP_ID + 0
, OU.NAME
, OU.DATE_FROM
, OU.DATE_TO
, OU.TYPE
, OU.INTERNAL_ADDRESS_LINE
, OU.COMMENTS
, OU.LOCATION_ID
, OI1.ORG_INFORMATION1
, OI1.ORG_INFORMATION2
, L.ADDRESS_LINE_1
, L.ADDRESS_LINE_2
, L.ADDRESS_LINE_3
, L.TOWN_OR_CITY
, 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 = 'HK_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
Name |
GRE_ID |
BUSINESS_GROUP_ID |
NAME |
DATE_FROM |
DATE_TO |
TYPE |
INTERNAL_ADDRESS_LINE |
COMMENTS |
LOCATION_ID |
GRE_IDENTIFIER |
DESIGNATION |
ADDRESS_LINE1 |
ADDRESS_LINE2 |
ADDRESS_LINE3 |
TOWN_OR_CITY |
COUNTRY |