View: HRFV_HR_ORGANIZATIONS

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, OT.NAME ORGANIZATION_NAME
, O.DATE_FROM DATE_FROM
, O.DATE_TO DATE_TO
, O.INTERNAL_ADDRESS_LINE INTERNAL_ADDRESS
, O.COMMENTS COMMENTS
, O2.ORG_INFORMATION1 DEFAULT_START_TIME
, O2.ORG_INFORMATION2 DEFAULT_END_TIME
, TO_NUMBER(O2.ORG_INFORMATION3) WORKING_HOURS_AMOUNT
, O2.ORG_INFORMATION4 WORKING_HOURS_FREQUENCY
, HR_BIS.BIS_DECODE_LOOKUP('INTL_EXTL'
, O.INTERNAL_EXTERNAL_FLAG) INTERNAL_EXTERNAL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('ORG_TYPE'
, O.TYPE) ORGANIZATION_TYPE
, LT.LOCATION_CODE LOCATION_NAME
, '_DF:PER:PER_ORGANIZATION_UNITS:O'
, O.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, O.COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID
, O.LOCATION_ID LOCATION_ID
, O.ORGANIZATION_ID ORGANIZATION_ID
, O.SOFT_CODING_KEYFLEX_ID SOFT_CODING_KEYFLEX_ID
FROM HR_LOCATIONS_ALL_TL LT
, HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OT
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O3
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE O.ORGANIZATION_ID = OT.ORGANIZATION_ID
AND OT.LANGUAGE = USERENV('LANG')
AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O2.ORG_INFORMATION_CONTEXT (+) = 'WORK DAY INFORMATION'
AND O3.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O3.ORG_INFORMATION1 = 'HR_ORG'
AND O3.ORG_INFORMATION2 = 'Y'
AND O.LOCATION_ID = LT.LOCATION_ID(+)
AND LT.LANGUAGE (+) = USERENV('LANG')
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