View: HRFV_ORG_CLASSIFICATIONS

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, OT.NAME ORGANIZATION_NAME
, O.DATE_FROM DATE_FROM
, O.DATE_TO DATE_TO
, HR_BIS.BIS_DECODE_LOOKUP('ORG_CLASS'
, O3.ORG_INFORMATION1) CLASSIFICATION
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, O3.ORG_INFORMATION2) ENABLED
, '_DF:PER:PER_ORGANIZATION_UNITS:O'
, O.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, O.ORGANIZATION_ID ORGANIZATION_ID
FROM HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OT
, HR_ORGANIZATION_INFORMATION O3
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O.ORGANIZATION_ID = OT.ORGANIZATION_ID
AND OT.LANGUAGE = USERENV('LANG')
AND O3.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND O.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, O.BUSINESS_GROUP_ID) WITH READ ONLY

Columns