VIEW: APPS.HRI_CS_SUPHRO_X_V

Source

View Text - Preformatted

SELECT shs_sup.sup_level sup_absolute_level , shs_sup.sub_level sub_absolute_level , shs_sup.sub_relative_level sub_relative_level , shs_sub.sub_level subro_absolute_level , shs_sub.sub_level - shs_sup.sup_level subro_sup_relative_level , shs_sub.sub_level - shs_sub.sup_level subro_sub_relative_level /* Bridge Ids */ , 'Y' primary_hierarchy_flag_code , shs_sup.sup_person_id sup_person_id , shs_sup.sup_assignment_id sup_assignment_id , shs_sup.sub_person_id sub_person_id , shs_sup.sub_assignment_id sub_assignment_id , shs_sub.sub_person_id subro_person_id , shs_sub.sub_assignment_id subro_assignment_id /* Other ids*/ , shs_sup.sup_business_group_id sup_business_group_id , shs_sup.sub_business_group_id sub_business_group_id , shs_sub.sub_business_group_id subro_business_group_id /*Structure columns*/ , GREATEST(shs_sup.last_update_date ,shs_sub.last_update_date) last_change_date FROM hri_cs_suph shs_sup , hri_cs_suph shs_sub WHERE shs_sup.sub_assignment_id = shs_sub.sup_assignment_id AND trunc(sysdate) BETWEEN shs_sup.effective_start_date AND shs_sup.effective_end_date AND trunc(sysdate) BETWEEN shs_sub.effective_start_date AND shs_sub.effective_end_date WITH READ ONLY

View Text - HTML Formatted

SELECT SHS_SUP.SUP_LEVEL SUP_ABSOLUTE_LEVEL
, SHS_SUP.SUB_LEVEL SUB_ABSOLUTE_LEVEL
, SHS_SUP.SUB_RELATIVE_LEVEL SUB_RELATIVE_LEVEL
, SHS_SUB.SUB_LEVEL SUBRO_ABSOLUTE_LEVEL
, SHS_SUB.SUB_LEVEL - SHS_SUP.SUP_LEVEL SUBRO_SUP_RELATIVE_LEVEL
, SHS_SUB.SUB_LEVEL - SHS_SUB.SUP_LEVEL SUBRO_SUB_RELATIVE_LEVEL /* BRIDGE IDS */
, 'Y' PRIMARY_HIERARCHY_FLAG_CODE
, SHS_SUP.SUP_PERSON_ID SUP_PERSON_ID
, SHS_SUP.SUP_ASSIGNMENT_ID SUP_ASSIGNMENT_ID
, SHS_SUP.SUB_PERSON_ID SUB_PERSON_ID
, SHS_SUP.SUB_ASSIGNMENT_ID SUB_ASSIGNMENT_ID
, SHS_SUB.SUB_PERSON_ID SUBRO_PERSON_ID
, SHS_SUB.SUB_ASSIGNMENT_ID SUBRO_ASSIGNMENT_ID /* OTHER IDS*/
, SHS_SUP.SUP_BUSINESS_GROUP_ID SUP_BUSINESS_GROUP_ID
, SHS_SUP.SUB_BUSINESS_GROUP_ID SUB_BUSINESS_GROUP_ID
, SHS_SUB.SUB_BUSINESS_GROUP_ID SUBRO_BUSINESS_GROUP_ID /*STRUCTURE COLUMNS*/
, GREATEST(SHS_SUP.LAST_UPDATE_DATE
, SHS_SUB.LAST_UPDATE_DATE) LAST_CHANGE_DATE
FROM HRI_CS_SUPH SHS_SUP
, HRI_CS_SUPH SHS_SUB
WHERE SHS_SUP.SUB_ASSIGNMENT_ID = SHS_SUB.SUP_ASSIGNMENT_ID
AND TRUNC(SYSDATE) BETWEEN SHS_SUP.EFFECTIVE_START_DATE
AND SHS_SUP.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN SHS_SUB.EFFECTIVE_START_DATE
AND SHS_SUB.EFFECTIVE_END_DATE WITH READ ONLY