FND Design Data [Home] [Help]

View: HR_ORGANIZATION_VAC_LOV_V

Product: PER - Human Resources
Description:
Implementation/DBA Data: ViewAPPS.HR_ORGANIZATION_VAC_LOV_V
View Text

SELECT XTL.NAME
, X.ORGANIZATION_ID
, X.LOCATION_ID
FROM HR_ALL_ORGANIZATION_UNITS X
, HR_ALL_ORGANIZATION_UNITS_TL XTL
WHERE XTL.ORGANIZATION_ID = X.ORGANIZATION_ID
AND XTL.LANGUAGE = USERENV('LANG')

Columns

Name
NAME
ORGANIZATION_ID
LOCATION_ID