View: PJI_DIS_SUP_HRCHY_V

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

View Text

SELECT MGR.SUP_ABSOLUTE_LEVEL
, MGR.SUB_ABSOLUTE_LEVEL
, MGR.SUB_RELATIVE_LEVEL
, MGR.SUP_PERSON_ID
, MGR.SUB_PERSON_ID
, MGR.SUP_ASSIGNMENT_ID
, MGR.SUB_ASSIGNMENT_ID
, SUP.FULL_NAME
, SUB.FULL_NAME
, MGR.EFFECTIVE_START_DATE
, MGR.EFFECTIVE_END_DATE
FROM HRI_CS_SUPH_V MGR
, PER_ALL_PEOPLE_F SUP
, PER_ALL_PEOPLE_F SUB
WHERE MGR.PRIMARY_HIERARCHY_FLAG_CODE = 'Y'
AND MGR.SUP_PERSON_ID = SUP.PERSON_ID
AND MGR.SUB_PERSON_ID = SUB.PERSON_ID
AND MGR.EFFECTIVE_START_DATE BETWEEN SUP.EFFECTIVE_START_DATE
AND SUP.EFFECTIVE_END_DATE
AND MGR.EFFECTIVE_START_DATE BETWEEN SUB.EFFECTIVE_START_DATE
AND SUB.EFFECTIVE_END_DATE

Columns