VIEW: APPS.HRI_DBI_CL_GEO_CITY_V

Source

View Text - Preformatted

SELECT DISTINCT glh.city_cid id , DECODE(glh.city_cid, 'NA_EDW', hri_oltp_view_message.get_unassigned_msg, glh.city_src_town_or_city_txt) value , hr_general.start_of_time start_date , hr_general.end_of_time end_date , DECODE(glh.city_src_town_or_city_txt, 'NA_EDW', '1', '2' || glh.city_src_town_or_city_txt) order_by FROM hri_cs_geo_lochr_ct glh WHERE (glh.city_src_town_or_city_txt <> 'NA_EDW' OR glh.location_id = -1) WITH READ ONLY

View Text - HTML Formatted

SELECT DISTINCT GLH.CITY_CID ID
, DECODE(GLH.CITY_CID
, 'NA_EDW'
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, GLH.CITY_SRC_TOWN_OR_CITY_TXT) VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, DECODE(GLH.CITY_SRC_TOWN_OR_CITY_TXT
, 'NA_EDW'
, '1'
, '2' || GLH.CITY_SRC_TOWN_OR_CITY_TXT) ORDER_BY
FROM HRI_CS_GEO_LOCHR_CT GLH
WHERE (GLH.CITY_SRC_TOWN_OR_CITY_TXT <> 'NA_EDW' OR GLH.LOCATION_ID = -1) WITH READ ONLY