VIEW: APPS.PJI_DIS_SUP_HRCHY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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