View: HR_ORGANIZATION_LOV_V

Product:	PER - Human Resources
Description:	HR Web Offers list of values view.
Implementation/DBA Data:	APPS.HR_ORGANIZATION_LOV_V

View Text

SELECT O.ORGANIZATION_ID
, O.BUSINESS_GROUP_ID
, OTL.NAME
, O.DATE_FROM
, O.DATE_TO
FROM HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OTL
WHERE O.INTERNAL_EXTERNAL_FLAG = 'INT'
AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')

Columns