VIEW: APPS.PJI_DIS_SUP_ROHRCHY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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