[Home] [Help]
View: HR_FR_PENSION_GROUPS_V
View Text
SELECT OU1.ORGANIZATION_ID
, OU1.BUSINESS_GROUP_ID
, OUT1.NAME
, OU1.DATE_FROM
, OU1.DATE_TO
, OU1.INTERNAL_ADDRESS_LINE
, OU1.LOCATION_ID
, OL.LOCATION_CODE
, OU1.COMMENTS
, OI2.ORG_INFORMATION2
FROM HR_LOCATIONS OL
, HR_ORGANIZATION_INFORMATION OI2
, HR_ALL_ORGANIZATION_UNITS OU1
, HR_ALL_ORGANIZATION_UNITS_TL OUT1
WHERE OU1.ORGANIZATION_ID = OI2.ORGANIZATION_ID
AND OI2.ORG_INFORMATION_CONTEXT || '' = 'CLASS'
AND OI2.ORG_INFORMATION1 = 'FR_PENSION_GROUP'
AND OI2.ORG_INFORMATION2 = 'Y'
AND OL.LOCATION_ID (+) = OU1.LOCATION_ID
AND OU1.ORGANIZATION_ID = OUT1.ORGANIZATION_ID
AND USERENV('LANG') = OUT1.LANGUAGE
Columns
Name |
ORGANIZATION_ID |
BUSINESS_GROUP_ID |
NAME |
DATE_FROM |
DATE_TO |
INTERNAL_ADDRESS_LINE |
LOCATION_ID |
LOCATION_CODE |
COMMENTS |
ENABLED |