View: HRIBV_TRNCNTR_HRCHY

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.HRIBV_TRNCNTR_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
, OSV.VERSION_NUMBER HIERARCHY_VERSION
, OSV.DATE_FROM HIERARCHY_VERSION_DATE_FROM
, OSV.DATE_TO HIERARCHY_VERSION_DATE_TO
, ORGT.NAME TRAINING_CENTER_NAME
, OSH.ORGANIZATION_LEVEL TRAINING_CENTER_LEVEL
, SORGT.NAME SUB_TRAINING_CENTER_NAME
, OSH.SUB_ORGANIZATION_LEVEL SUB_TRAINING_CENTER_LEVEL /* NOT NULL */
, NVL( OSV.DATE_TO
, HR_GENERAL.END_OF_TIME) HRCHY_VERSION_DATE_TO_NN /* CODES */
, OST.PRIMARY_STRUCTURE_FLAG HRCHY_PRIMARY_FLAG_CODE /* IDS */
, OST.ORGANIZATION_STRUCTURE_ID TC_HIERARCHY_ID
, OST.BUSINESS_GROUP_ID TC_HRCHY_BUSINESS_GROUP_ID
, OSV.ORG_STRUCTURE_VERSION_ID TC_HRCHY_VERSION_ID
, OSH.ORG_BUSINESS_GROUP_ID TC_BUSINESS_GROUP_ID
, OSH.ORGANIZATION_ID TRAINING_CENTE_ID
, OSH.SUB_ORG_BUSINESS_GROUP_ID SUB_TC_BUSINESS_GROUP_ID
, OSH.SUB_ORGANIZATION_ID SUB_TRAINING_CENTER_ID
FROM PER_ORGANIZATION_STRUCTURES OST
, PER_ORG_STRUCTURE_VERSIONS OSV
, HRI_ORG_HRCHY_SUMMARY OSH
, HR_ORGANIZATION_INFORMATION INF
, HR_ORGANIZATION_INFORMATION SINF
, 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 /*TRAINING CENTER ORGANIZATION TYPE RESTRICTION*/
AND OSH.ORGANIZATION_ID = INF.ORGANIZATION_ID
AND INF.ORG_INFORMATION_CONTEXT = 'CLASS'
AND INF.ORG_INFORMATION1 = 'OTA_TC'
AND OSH.SUB_ORGANIZATION_ID = SINF.ORGANIZATION_ID
AND SINF.ORG_INFORMATION_CONTEXT = 'CLASS'
AND SINF.ORG_INFORMATION1 = 'OTA_TC' /*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') /*RESTRICT TO RESPONSIBILITY'S BUSINESS GROUP */
AND OST.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, OST.BUSINESS_GROUP_ID) WITH READ ONLY

Columns