View: HRFV_ORGANIZATION_HIERARCHIES

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, RPAD('-'
, (HEIR.ORG_LEVEL)
, '-') || ' ' || ORG1T.NAME CHILD_ORGANIZATION_NAME
, ORG2T.NAME PARENT_ORGANIZATION_NAME
, STRU.NAME ORGANIZATION_HIERARCHY_NAME
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, STRU.PRIMARY_STRUCTURE_FLAG) PRIMARY_HIERARCHY_FLAG
, HEIR.ORG_LEVEL ORGANIZATION_HIERARCHY_LEVEL
, PER_VIEWS_PKG.PER_GET_ORGANIZATION_EMPLOYEES(HEIR.ORGANIZATION_ID) NUMBER_OF_EMPLOYEES
, VER.DATE_FROM HIERARCHY_VERSION_START_DATE
, VER.DATE_TO HIERARCHY_VERSION_END_DATE
, VER.VERSION_NUMBER ORGANIZATION_HIERARCHY_VERSION
, HEIR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HEIR.ORGANIZATION_ID CHILD_ORGANIZATION_ID
, STRU.ORGANIZATION_STRUCTURE_ID ORGANIZATION_HIERARCHY_ID
, VER.ORG_STRUCTURE_VERSION_ID ORG_HIERARCHY_VERSION_ID
, HEIR.PARENT_ORGANIZATION_ID PARENT_ORGANIZATION_ID
FROM HRBV_ORGANIZATION_DESCENDENTS HEIR
, HR_ALL_ORGANIZATION_UNITS_TL ORG1T
, HR_ALL_ORGANIZATION_UNITS_TL ORG2T
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_ORG_STRUCTURE_VERSIONS VER
, PER_ORGANIZATION_STRUCTURES STRU
WHERE HEIR.ORG_STRUCTURE_VERSION_ID = VER.ORG_STRUCTURE_VERSION_ID
AND VER.ORGANIZATION_STRUCTURE_ID = STRU.ORGANIZATION_STRUCTURE_ID
AND HEIR.ORGANIZATION_ID = ORG1T.ORGANIZATION_ID
AND ORG1T.LANGUAGE = USERENV('LANG')
AND HEIR.PARENT_ORGANIZATION_ID = ORG2T.ORGANIZATION_ID
AND ORG2T.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

Columns