View: PJI_DIS_ORG_HRCHY_V

Product:	PJI - Project Intelligence
Description:	Discoverer view of organization hierarchy data.
Implementation/DBA Data:	APPS.PJI_DIS_ORG_HRCHY_V

View Text

SELECT ORG.ORGANIZATION_ID
, HOU1.NAME
, ORG.SUB_ORGANIZATION_ID
, HOU2.NAME
, ORG.ORGANIZATION_LEVEL
, ORG.SUB_ORGANIZATION_LEVEL
, ORG.SUB_ORGANIZATION_LEVEL - ORG.ORGANIZATION_LEVEL
FROM PJI_ORG_DENORM ORG
, HR_ALL_ORGANIZATION_UNITS_TL HOU1
, HR_ALL_ORGANIZATION_UNITS_TL HOU2
WHERE ORG.ORGANIZATION_ID = HOU1.ORGANIZATION_ID
AND ORG.SUB_ORGANIZATION_ID = HOU2.ORGANIZATION_ID
AND HOU1.LANGUAGE = USERENV('LANG')
AND HOU2.LANGUAGE = USERENV('LANG')

Columns