VIEW: APPS.HRI_CS_POSHRO_X_V

Source

View Text - Preformatted

SELECT psh_sup.sup_absolute_level sup_absolute_level ,psh_sup.sub_absolute_level sub_absolute_level ,psh_sup.sub_relative_level sub_relative_level ,psh_sub.sub_absolute_level subro_absolute_level ,psh_sub.sub_relative_level subro_sup_relative_level ,psh_sub.sub_absolute_level - psh_sup.sup_absolute_level subro_sub_relative_level ,psh_sup.effective_start_date effective_start_date ,psh_sup.effective_end_date effective_end_date ,psh_sup.primary_hierarchy_flag_code primary_hierarchy_flag_code ,psh_sup.sup_position_id sup_position_id ,psh_sup.sub_position_id sub_position_id ,psh_sub.sub_position_id subro_position_id ,psh_sup.business_group_id sup_business_group_iD ,psh_sub.business_group_id sub_business_group_id ,psh_sup.position_structure_id position_structure_id ,psh_sup.pos_structure_version_id pos_structure_version_id FROM hri_cs_posh_v psh_sup ,hri_cs_posh_v psh_sub WHERE psh_sub.sup_position_id = psh_sup.sub_position_id AND psh_sub.effective_start_date = psh_sup.effective_start_date AND TRUNC(sysdate) BETWEEN psh_sup.effective_start_date AND psh_sup.effective_end_date WITH READ ONLY

View Text - HTML Formatted

SELECT PSH_SUP.SUP_ABSOLUTE_LEVEL SUP_ABSOLUTE_LEVEL
, PSH_SUP.SUB_ABSOLUTE_LEVEL SUB_ABSOLUTE_LEVEL
, PSH_SUP.SUB_RELATIVE_LEVEL SUB_RELATIVE_LEVEL
, PSH_SUB.SUB_ABSOLUTE_LEVEL SUBRO_ABSOLUTE_LEVEL
, PSH_SUB.SUB_RELATIVE_LEVEL SUBRO_SUP_RELATIVE_LEVEL
, PSH_SUB.SUB_ABSOLUTE_LEVEL - PSH_SUP.SUP_ABSOLUTE_LEVEL SUBRO_SUB_RELATIVE_LEVEL
, PSH_SUP.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PSH_SUP.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PSH_SUP.PRIMARY_HIERARCHY_FLAG_CODE PRIMARY_HIERARCHY_FLAG_CODE
, PSH_SUP.SUP_POSITION_ID SUP_POSITION_ID
, PSH_SUP.SUB_POSITION_ID SUB_POSITION_ID
, PSH_SUB.SUB_POSITION_ID SUBRO_POSITION_ID
, PSH_SUP.BUSINESS_GROUP_ID SUP_BUSINESS_GROUP_ID
, PSH_SUB.BUSINESS_GROUP_ID SUB_BUSINESS_GROUP_ID
, PSH_SUP.POSITION_STRUCTURE_ID POSITION_STRUCTURE_ID
, PSH_SUP.POS_STRUCTURE_VERSION_ID POS_STRUCTURE_VERSION_ID
FROM HRI_CS_POSH_V PSH_SUP
, HRI_CS_POSH_V PSH_SUB
WHERE PSH_SUB.SUP_POSITION_ID = PSH_SUP.SUB_POSITION_ID
AND PSH_SUB.EFFECTIVE_START_DATE = PSH_SUP.EFFECTIVE_START_DATE
AND TRUNC(SYSDATE) BETWEEN PSH_SUP.EFFECTIVE_START_DATE
AND PSH_SUP.EFFECTIVE_END_DATE WITH READ ONLY