View: PER_ORG_NAME_LOV

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_ORG_NAME_LOV

View Text

SELECT ORG.ORGANIZATION_ID
, ORGTL.NAME
, PL.MEANING
, ORG.INTERNAL_EXTERNAL_FLAG
, ORG.BUSINESS_GROUP_ID + 0
FROM HR_LOOKUPS PL
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
WHERE ORG.TYPE = PL.LOOKUP_CODE(+)
AND PL.LOOKUP_TYPE(+) = 'ORG_TYPE'
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID
AND ORGTL.LANGUAGE = USERENV('LANG')

Columns