VIEW: APPS.HRFV_ORG_CLASSIFICATIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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