View: HRFV_POSITION_HIERARCHIES

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_POSITION_HIERARCHIES

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, STRU.NAME POSITION_HIERARCHY_NAME
, RPAD('-'
, (HEIR.POS_LEVEL)
, '-') || ' ' || POS1.NAME CHILD_POSITION_NAME
, HEIR.POS_LEVEL POSITION_HIERARCHY_LEVEL
, POS2.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
, PER_ALL_POSITIONS POS1
, PER_ALL_POSITIONS POS2
, 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 = POS1.POSITION_ID
AND HEIR.PARENT_POSITION_ID = POS2.POSITION_ID
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

Columns