View: HRFV_ORGANIZATION_ROLLUP

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, STR.NAME ORGANIZATION_HIERARCHY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, STR.PRIMARY_STRUCTURE_FLAG) PRIMARY_FLAG
, ORGTOPT.NAME TOP_ORGANIZATION
, ORGGROUPT.NAME GROUP_ORGANIZATION
, ORGSUBT.NAME ORGANIZATION
, DECODE(OPA.ORGANIZATION_PROCESS
, 'ISNR'
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, 'Y')
, 'ISRO'
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, 'Y')
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, 'N')) INCLUDE_SUBORDINATES
, DECODE(OPA.ORGANIZATION_PROCESS
, 'ISNR'
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, 'N')
, 'SINR'
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, 'N')
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, 'Y')) ROLLUP
, STR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OPA.ORGANIZATION_ID TOP_ORG_ID
, OPL.ORGANIZATION_ID_GROUP ROLLUP_ORG_ID
, OPL.ORGANIZATION_ID_CHILD ORG_ID
FROM PER_ORGANIZATION_STRUCTURES STR
, HRI_ORG_PARAM_LIST OPL
, HRI_ORG_PARAMS OPA
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL ORGTOPT
, HR_ALL_ORGANIZATION_UNITS_TL ORGGROUPT
, HR_ALL_ORGANIZATION_UNITS_TL ORGSUBT
WHERE STR.ORGANIZATION_STRUCTURE_ID = OPA.ORGANIZATION_STRUCTURE_ID
AND OPL.ORG_PARAM_ID = OPA.ORG_PARAM_ID
AND ORGTOPT.ORGANIZATION_ID = OPA.ORGANIZATION_ID
AND ORGTOPT.LANGUAGE = USERENV('LANG')
AND ORGGROUPT.ORGANIZATION_ID = OPL.ORGANIZATION_ID_GROUP
AND ORGGROUPT.LANGUAGE = USERENV('LANG')
AND ORGSUBT.ORGANIZATION_ID = OPL.ORGANIZATION_ID_CHILD
AND ORGSUBT.LANGUAGE = USERENV('LANG')
AND STR.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND STR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, STR.BUSINESS_GROUP_ID) WITH READ ONLY

Columns