VIEW: APPS.HRI_CL_LOC_HR_N_V

Source

View Text - Preformatted

SELECT loc.location_id ID , locT.location_code VALUE , hr_general.start_of_time start_date , NVL( loc.inactive_date , hr_general.end_of_time) end_date , locT.location_code order_by , loc.business_group_id business_group_id , DECODE( loc.business_group_id , NULL,'Y' ,'N' ) global_flag_code , CASE WHEN( loc.business_group_id IS NULL OR loc.business_group_id = NVL( hr_bis.get_sec_profile_bg_id , loc.business_group_id) ) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM hr_locations_all loc , hr_locations_all_tl locT WHERE loc.location_id = locT.location_id AND locT.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT LOC.LOCATION_ID ID
, LOCT.LOCATION_CODE VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, NVL( LOC.INACTIVE_DATE
, HR_GENERAL.END_OF_TIME) END_DATE
, LOCT.LOCATION_CODE ORDER_BY
, LOC.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DECODE( LOC.BUSINESS_GROUP_ID
, NULL
, 'Y'
, 'N' ) GLOBAL_FLAG_CODE
, CASE WHEN( LOC.BUSINESS_GROUP_ID IS NULL OR LOC.BUSINESS_GROUP_ID = NVL( HR_BIS.GET_SEC_PROFILE_BG_ID
, LOC.BUSINESS_GROUP_ID) ) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM HR_LOCATIONS_ALL LOC
, HR_LOCATIONS_ALL_TL LOCT
WHERE LOC.LOCATION_ID = LOCT.LOCATION_ID
AND LOCT.LANGUAGE = USERENV('LANG') WITH READ ONLY