View: HRIBV_ORG_HRCHY

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.HRIBV_ORG_HRCHY

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ OST.NAME HIERARCHY_NAME
, BGRT.NAME HRCHY_BUSINESS_GROUP_NAME
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, OST.PRIMARY_STRUCTURE_FLAG) HRCHY_PRIMARY_FLAG
, OST.PRIMARY_STRUCTURE_FLAG HRCHY_PRIMARY_FLAG_CODE
, OSV.VERSION_NUMBER HIERARCHY_VERSION
, OSV.DATE_FROM HIERARCHY_VERSION_DATE_FROM
, OSV.DATE_TO HIERARCHY_VERSION_DATE_TO
, ORGT.NAME ORGANIZATION_NAME
, OSH.ORGANIZATION_LEVEL ORGANIZATION_LEVEL
, SORGT.NAME SUB_ORGANIZATION_NAME
, OSH.SUB_ORGANIZATION_LEVEL SUB_ORGANIZATION_LEVEL /*NOT NULL */
, NVL(OSV.DATE_TO
, HR_GENERAL.END_OF_TIME) HRCHY_VERSION_DATE_TO_NN /*IDS*/
, OST.ORGANIZATION_STRUCTURE_ID ORG_HIERARCHY_ID
, OST.BUSINESS_GROUP_ID ORG_HRCHY_BUSINESS_GROUP_ID
, OSV.ORG_STRUCTURE_VERSION_ID ORG_HRCHY_VERSION_ID
, OSH.ORG_BUSINESS_GROUP_ID ORG_BUSINESS_GROUP_ID
, OSH.ORGANIZATION_ID ORGANIZATION_ID
, OSH.SUB_ORG_BUSINESS_GROUP_ID SUB_ORG_BUSINESS_GROUP_ID
, OSH.SUB_ORGANIZATION_ID SUB_ORGANIZATION_ID
FROM PER_ORGANIZATION_STRUCTURES OST
, PER_ORG_STRUCTURE_VERSIONS OSV
, HRI.HRI_ORG_HRCHY_SUMMARY OSH
, HR_ALL_ORGANIZATION_UNITS_TL BGRT /*HRCHY BG NAME*/
, HR_ALL_ORGANIZATION_UNITS_TL ORGT /*ORG NAME*/
, HR_ALL_ORGANIZATION_UNITS_TL SORGT /*SUB ORG NAME*/
WHERE OST.ORGANIZATION_STRUCTURE_ID = OSV.ORGANIZATION_STRUCTURE_ID
AND OSV.ORG_STRUCTURE_VERSION_ID = OSH.ORG_STRUCTURE_VERSION_ID /*ORG + BG NAME JOINS */
AND OST.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND OSH.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND OSH.SUB_ORGANIZATION_ID = SORGT.ORGANIZATION_ID
AND SORGT.LANGUAGE = USERENV('LANG') WITH READ ONLY

Columns