VIEW: APPS.HRI_DBI_CL_GEO_CITY_HRCHY_V

Source

View Text - Preformatted

SELECT 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 , MIN(glh.effective_start_date) start_date , MAX(glh.effective_end_date) end_date , DECODE(glh.city_src_town_or_city_txt, 'NA_EDW', '1', '2' || glh.city_src_town_or_city_txt) order_by ,area_code area_code ,country_code country_code ,region_code region_code FROM hri_cs_geo_lochr_ct glh WHERE (glh.city_src_town_or_city_txt <> 'NA_EDW' OR glh.location_id = -1) GROUP BY glh.city_cid , glh.city_src_town_or_city_txt ,area_code ,country_code ,region_code WITH READ ONLY

View Text - HTML Formatted

SELECT 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
, MIN(GLH.EFFECTIVE_START_DATE) START_DATE
, MAX(GLH.EFFECTIVE_END_DATE) END_DATE
, DECODE(GLH.CITY_SRC_TOWN_OR_CITY_TXT
, 'NA_EDW'
, '1'
, '2' || GLH.CITY_SRC_TOWN_OR_CITY_TXT) ORDER_BY
, AREA_CODE AREA_CODE
, COUNTRY_CODE COUNTRY_CODE
, REGION_CODE REGION_CODE
FROM HRI_CS_GEO_LOCHR_CT GLH
WHERE (GLH.CITY_SRC_TOWN_OR_CITY_TXT <> 'NA_EDW' OR GLH.LOCATION_ID = -1) GROUP BY GLH.CITY_CID
, GLH.CITY_SRC_TOWN_OR_CITY_TXT
, AREA_CODE
, COUNTRY_CODE
, REGION_CODE WITH READ ONLY