View: PJI_DIS_SUP_ROHRCHY_V

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

View Text

SELECT MGR.SUP_ABSOLUTE_LEVEL
, MGR.SUB_ABSOLUTE_LEVEL
, MGR.SUB_RELATIVE_LEVEL
, MGR.SUBRO_ABSOLUTE_LEVEL
, MGR.SUBRO_SUP_RELATIVE_LEVEL
, MGR.SUBRO_SUB_RELATIVE_LEVEL
, MGR.SUP_PERSON_ID
, MGR.SUB_PERSON_ID
, MGR.SUBRO_PERSON_ID
, MGR.SUP_ASSIGNMENT_ID
, MGR.SUB_ASSIGNMENT_ID
, MGR.SUBRO_ASSIGNMENT_ID
, SUP.FULL_NAME
, SUB.FULL_NAME
, SUBRO.FULL_NAME
, MGR.EFFECTIVE_START_DATE
, MGR.EFFECTIVE_END_DATE
FROM HRI_CS_SUPHRO_V MGR
, PER_ALL_PEOPLE_F SUP
, PER_ALL_PEOPLE_F SUB
, PER_ALL_PEOPLE_F SUBRO
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.SUBRO_PERSON_ID = SUBRO.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
AND MGR.EFFECTIVE_START_DATE BETWEEN SUBRO.EFFECTIVE_START_DATE
AND SUBRO.EFFECTIVE_END_DATE

Columns