VIEW: APPS.HRI_CS_SUPH_V

Source

View Text - Preformatted

SELECT shs.sup_level sup_absolute_level , shs.sub_level sub_absolute_level , shs.sub_relative_level sub_relative_level , shs.effective_start_date effective_start_date , shs.effective_end_date effective_end_date , 'Y' primary_hierarchy_flag_code , shs.sup_person_id sup_person_id , shs.sup_assignment_id sup_assignment_id , shs.sub_person_id sub_person_id , shs.sub_assignment_id sub_assignment_id , shs.sup_business_group_id sup_business_group_id , shs.sub_business_group_id sub_business_group_id , shs.sup_assignment_status_type_id sup_assignment_status_type_id , shs.sub_assignment_status_type_id sub_assignment_status_type_id , shs.sup_invalid_flag_code sup_invalid_flag_code , shs.sub_invalid_flag_code sub_invalid_flag_code , shs.sub_leaf_flag_code sub_leaf_flag_code , shs.last_update_date last_change_date FROM hri_cs_suph shs WITH READ ONLY

View Text - HTML Formatted

SELECT SHS.SUP_LEVEL SUP_ABSOLUTE_LEVEL
, SHS.SUB_LEVEL SUB_ABSOLUTE_LEVEL
, SHS.SUB_RELATIVE_LEVEL SUB_RELATIVE_LEVEL
, SHS.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, SHS.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, 'Y' PRIMARY_HIERARCHY_FLAG_CODE
, SHS.SUP_PERSON_ID SUP_PERSON_ID
, SHS.SUP_ASSIGNMENT_ID SUP_ASSIGNMENT_ID
, SHS.SUB_PERSON_ID SUB_PERSON_ID
, SHS.SUB_ASSIGNMENT_ID SUB_ASSIGNMENT_ID
, SHS.SUP_BUSINESS_GROUP_ID SUP_BUSINESS_GROUP_ID
, SHS.SUB_BUSINESS_GROUP_ID SUB_BUSINESS_GROUP_ID
, SHS.SUP_ASSIGNMENT_STATUS_TYPE_ID SUP_ASSIGNMENT_STATUS_TYPE_ID
, SHS.SUB_ASSIGNMENT_STATUS_TYPE_ID SUB_ASSIGNMENT_STATUS_TYPE_ID
, SHS.SUP_INVALID_FLAG_CODE SUP_INVALID_FLAG_CODE
, SHS.SUB_INVALID_FLAG_CODE SUB_INVALID_FLAG_CODE
, SHS.SUB_LEAF_FLAG_CODE SUB_LEAF_FLAG_CODE
, SHS.LAST_UPDATE_DATE LAST_CHANGE_DATE
FROM HRI_CS_SUPH SHS WITH READ ONLY