VIEW: APPS.HRI_OBI_CL_GEO_LOCATION_V

Source

View Text - Preformatted

SELECT csl.location_id AS loc_location_pk, decode(csl.location_id, -1, hri_oltp_view_message.get_unassigned_msg, loct.location_code) AS loc_location_name, decode(csl.location_id, -1, hri_oltp_view_message.get_unassigned_msg, loct.location_code) || ' (' || csl.location_id || ')' AS loc_location_name_unq, decode(csl.location_id, -1, NULL, loct.location_code) AS loc_order_by, csl.area_code AS loc_area_fk, csl.country_code AS loc_country_fk, cgr.geo_region_sk_pk AS loc_region_fk, (csl.area_code || '+' || csl.country_code || '+' || csl.region_code || '+' || csl.city_src_town_or_city_txt) AS loc_city_fk FROM hri_cs_geo_lochr_ct csl, hr_locations_all_tl loct, hri_cs_geo_region_ct cgr WHERE cgr.geo_area_code = csl.area_code AND cgr.geo_country_code = csl.country_code AND cgr.geo_region_code = csl.region_code AND csl.location_id = loct.location_id(+) AND loct.LANGUAGE(+) = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT CSL.LOCATION_ID AS LOC_LOCATION_PK
, DECODE(CSL.LOCATION_ID
, -1
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, LOCT.LOCATION_CODE) AS LOC_LOCATION_NAME
, DECODE(CSL.LOCATION_ID
, -1
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, LOCT.LOCATION_CODE) || ' (' || CSL.LOCATION_ID || ')' AS LOC_LOCATION_NAME_UNQ
, DECODE(CSL.LOCATION_ID
, -1
, NULL
, LOCT.LOCATION_CODE) AS LOC_ORDER_BY
, CSL.AREA_CODE AS LOC_AREA_FK
, CSL.COUNTRY_CODE AS LOC_COUNTRY_FK
, CGR.GEO_REGION_SK_PK AS LOC_REGION_FK
, (CSL.AREA_CODE || '+' || CSL.COUNTRY_CODE || '+' || CSL.REGION_CODE || '+' || CSL.CITY_SRC_TOWN_OR_CITY_TXT) AS LOC_CITY_FK
FROM HRI_CS_GEO_LOCHR_CT CSL
, HR_LOCATIONS_ALL_TL LOCT
, HRI_CS_GEO_REGION_CT CGR
WHERE CGR.GEO_AREA_CODE = CSL.AREA_CODE
AND CGR.GEO_COUNTRY_CODE = CSL.COUNTRY_CODE
AND CGR.GEO_REGION_CODE = CSL.REGION_CODE
AND CSL.LOCATION_ID = LOCT.LOCATION_ID(+)
AND LOCT.LANGUAGE(+) = USERENV('LANG') WITH READ ONLY