VIEW: APPS.HRI_DBI_CL_GEO_LOCHR_V

Source

View Text - Preformatted

SELECT csl.location_id ID , DECODE(csl.location_id ,-1,hri_oltp_view_message.get_unassigned_msg ,locT.location_code) VALUE , locT.location_code VALUE_NULL , locT.description VALUE_LONG , DECODE(csl.location_id ,-1,NULL ,locT.location_code) ORDER_BY , csl.effective_start_date START_DATE , csl.effective_end_date END_DATE , csl.area_code geo_area_code , csl.country_code geo_country_code , csl.region_code geo_region_code , csl.location_id geo_lochr_id FROM hri_cs_geo_lochr_ct csl , hr_locations_all_tl locT WHERE 1=1 AND csl.location_id = locT.location_id(+) AND locT.LANGUAGE(+) = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT CSL.LOCATION_ID ID
, DECODE(CSL.LOCATION_ID
, -1
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, LOCT.LOCATION_CODE) VALUE
, LOCT.LOCATION_CODE VALUE_NULL
, LOCT.DESCRIPTION VALUE_LONG
, DECODE(CSL.LOCATION_ID
, -1
, NULL
, LOCT.LOCATION_CODE) ORDER_BY
, CSL.EFFECTIVE_START_DATE START_DATE
, CSL.EFFECTIVE_END_DATE END_DATE
, CSL.AREA_CODE GEO_AREA_CODE
, CSL.COUNTRY_CODE GEO_COUNTRY_CODE
, CSL.REGION_CODE GEO_REGION_CODE
, CSL.LOCATION_ID GEO_LOCHR_ID
FROM HRI_CS_GEO_LOCHR_CT CSL
, HR_LOCATIONS_ALL_TL LOCT
WHERE 1=1
AND CSL.LOCATION_ID = LOCT.LOCATION_ID(+)
AND LOCT.LANGUAGE(+) = USERENV('LANG') WITH READ ONLY