View: PJI_DIS_ORG_ROHRCHY_V

Product:	PJI - Project Intelligence
Description:	Discoverer view of organization hierarchy data with subordinate rollup data.
Implementation/DBA Data:	APPS.PJI_DIS_ORG_ROHRCHY_V

View Text

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

Columns