VIEW: APPS.HRI_OBI_CL_GEO_CITY_V

Source

View Text - Preformatted

SELECT DISTINCT(glh.area_code||'+'||glh.country_code||'+'||glh.region_code||'+'|| glh.CITY_SRC_TOWN_OR_CITY_TXT) AS CITY_CITY_PK, DECODE(glh.city_cid, 'NA_EDW', hri_oltp_view_message.get_unassigned_msg, glh.CITY_SRC_TOWN_OR_CITY_TXT) AS CITY_CITY_NAME, DECODE(glh.city_cid, 'NA_EDW', hri_oltp_view_message.get_unassigned_msg, glh.CITY_SRC_TOWN_OR_CITY_TXT) ||' ('||glh.area_code||'+'||glh.country_code||'+'||glh.region_code||'+'|| glh.CITY_SRC_TOWN_OR_CITY_TXT||')' AS CITY_CITY_NAME_UNQ, DECODE(glh.city_src_town_or_city_txt, 'NA_EDW', NULL ,glh.city_src_town_or_city_txt) AS CITY_ORDER_BY, glh.area_code AS CITY_AREA_FK, glh.country_code AS CITY_COUNTRY_FK, cgr.GEO_REGION_SK_PK AS CITY_REGION_FK, 'Y' AS CITY_LOCHR_EXIST_FLAG FROM hri_cs_geo_lochr_ct glh ,hri_cs_geo_region_ct cgr WHERE cgr.GEO_AREA_CODE = glh.AREA_CODE AND cgr.GEO_COUNTRY_CODE = glh.COUNTRY_CODE AND cgr.GEO_REGION_CODE = glh.REGION_CODE WITH READ ONLY

View Text - HTML Formatted

SELECT DISTINCT(GLH.AREA_CODE||'+'||GLH.COUNTRY_CODE||'+'||GLH.REGION_CODE||'+'|| GLH.CITY_SRC_TOWN_OR_CITY_TXT) AS CITY_CITY_PK
, DECODE(GLH.CITY_CID
, 'NA_EDW'
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, GLH.CITY_SRC_TOWN_OR_CITY_TXT) AS CITY_CITY_NAME
, DECODE(GLH.CITY_CID
, 'NA_EDW'
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, GLH.CITY_SRC_TOWN_OR_CITY_TXT) ||' ('||GLH.AREA_CODE||'+'||GLH.COUNTRY_CODE||'+'||GLH.REGION_CODE||'+'|| GLH.CITY_SRC_TOWN_OR_CITY_TXT||')' AS CITY_CITY_NAME_UNQ
, DECODE(GLH.CITY_SRC_TOWN_OR_CITY_TXT
, 'NA_EDW'
, NULL
, GLH.CITY_SRC_TOWN_OR_CITY_TXT) AS CITY_ORDER_BY
, GLH.AREA_CODE AS CITY_AREA_FK
, GLH.COUNTRY_CODE AS CITY_COUNTRY_FK
, CGR.GEO_REGION_SK_PK AS CITY_REGION_FK
, 'Y' AS CITY_LOCHR_EXIST_FLAG
FROM HRI_CS_GEO_LOCHR_CT GLH
, HRI_CS_GEO_REGION_CT CGR
WHERE CGR.GEO_AREA_CODE = GLH.AREA_CODE
AND CGR.GEO_COUNTRY_CODE = GLH.COUNTRY_CODE
AND CGR.GEO_REGION_CODE = GLH.REGION_CODE WITH READ ONLY