View: HRFV_OPERATING_UNITS

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, ORGT.NAME OPERATING_UNIT_NAME
, ORG.DATE_FROM DATE_FROM
, ORG.DATE_TO DATE_TO
, HR_BIS.BIS_DECODE_LOOKUP('ORG_TYPE'
, ORG.TYPE) ORGANIZATION_TYPE
, ORG.INTERNAL_ADDRESS_LINE INTERNAL_ADDRESS
, ORG.COMMENTS COMMENTS
, LEGT.NAME LEGAL_ENTITY_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, '_DF:PER:PER_ORGANIZATION_UNITS:ORG'
, ORG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OI2.ORG_INFORMATION2 LEGAL_ENTITY_ID
, ORG.LOCATION_ID LOCATION_ID
, ORG.ORGANIZATION_ID OPERATING_UNITS_ID
FROM HR_LOCATIONS_ALL_TL LOCT
, HR_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ORGANIZATION_INFORMATION OI2
, HR_ORGANIZATION_INFORMATION OI3
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL LEGT
WHERE ORG.ORGANIZATION_ID = OI2.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = OI3.ORGANIZATION_ID
AND OI2.ORG_INFORMATION_CONTEXT = 'OPERATING UNIT INFORMATION'
AND OI3.ORG_INFORMATION_CONTEXT = 'CLASS'
AND OI3.ORG_INFORMATION1 = 'OPERATING_UNIT'
AND OI3.ORG_INFORMATION2 = 'Y'
AND ORG.LOCATION_ID = LOCT.LOCATION_ID (+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND ORG.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ORG.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND ORG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ORG.BUSINESS_GROUP_ID)
AND OI2.ORG_INFORMATION2 = LEGT.ORGANIZATION_ID
AND LEGT.LANGUAGE = USERENV('LANG') WITH READ ONLY

Columns