VIEW: APPS.HRFV_POSITION_HIERARCHIES

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,stru.name position_hierarchy_name ,RPAD('-',(heir.pos_level),'-') || ' ' || pft1.name child_position_name ,heir.pos_level position_hierarchy_level ,pft2.name parent_position_name ,ver.date_from hierarchy_version_start_date ,ver.date_to hierarchy_version_end_date ,ver.version_number position_hierarchy_version ,heir.business_group_id business_group_id ,heir.parent_position_id parent_position_id ,heir.position_id child_position_id ,stru.position_structure_id position_hierarchy_id ,ver.pos_structure_version_id pos_hierarchy_version_id FROM hr_all_organization_units_tl bgrT ,per_pos_structure_versions ver ,per_position_structures stru ,hr_all_positions_f_tl pft1 ,hr_all_positions_f_tl pft2 ,hrbv_position_descendents heir WHERE heir.pos_structure_version_id = ver.pos_structure_version_id AND ver.position_structure_id = stru.position_structure_id AND heir.position_id = pft1.position_id AND pft1.language = userenv('LANG') AND heir.parent_position_id = pft2.position_id AND pft2.language = userenv('LANG') AND heir.business_group_id = ver.business_group_id AND ver.business_group_id = stru.business_group_id AND heir.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND heir.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,heir.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, STRU.NAME POSITION_HIERARCHY_NAME
, RPAD('-'
, (HEIR.POS_LEVEL)
, '-') || ' ' || PFT1.NAME CHILD_POSITION_NAME
, HEIR.POS_LEVEL POSITION_HIERARCHY_LEVEL
, PFT2.NAME PARENT_POSITION_NAME
, VER.DATE_FROM HIERARCHY_VERSION_START_DATE
, VER.DATE_TO HIERARCHY_VERSION_END_DATE
, VER.VERSION_NUMBER POSITION_HIERARCHY_VERSION
, HEIR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HEIR.PARENT_POSITION_ID PARENT_POSITION_ID
, HEIR.POSITION_ID CHILD_POSITION_ID
, STRU.POSITION_STRUCTURE_ID POSITION_HIERARCHY_ID
, VER.POS_STRUCTURE_VERSION_ID POS_HIERARCHY_VERSION_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_POS_STRUCTURE_VERSIONS VER
, PER_POSITION_STRUCTURES STRU
, HR_ALL_POSITIONS_F_TL PFT1
, HR_ALL_POSITIONS_F_TL PFT2
, HRBV_POSITION_DESCENDENTS HEIR
WHERE HEIR.POS_STRUCTURE_VERSION_ID = VER.POS_STRUCTURE_VERSION_ID
AND VER.POSITION_STRUCTURE_ID = STRU.POSITION_STRUCTURE_ID
AND HEIR.POSITION_ID = PFT1.POSITION_ID
AND PFT1.LANGUAGE = USERENV('LANG')
AND HEIR.PARENT_POSITION_ID = PFT2.POSITION_ID
AND PFT2.LANGUAGE = USERENV('LANG')
AND HEIR.BUSINESS_GROUP_ID = VER.BUSINESS_GROUP_ID
AND VER.BUSINESS_GROUP_ID = STRU.BUSINESS_GROUP_ID
AND HEIR.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND HEIR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, HEIR.BUSINESS_GROUP_ID) WITH READ ONLY