eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HRI_CL_GEO_CITY_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 , DECODE(glh.city_cid, 'NA_EDW', NULL, glh.city_src_town_or_city_txt) value_null , 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.meaning area_name , ctr.territory_short_name country_name , rgn.meaning region_name , glh.area_code area_code , glh.country_code country_code , glh.region_code region_code FROM hri_cs_geo_lochr_ct glh , fnd_lookups area , fnd_territories_tl ctr , fnd_lookups rgn WHERE (glh.city_src_town_or_city_txt <> 'NA_EDW' OR glh.location_id = -1) AND area.lookup_type (+) = 'AREA' AND area.lookup_code (+) = glh.area_code AND ctr.territory_code (+) = glh.country_code AND ctr.language (+) = userenv('LANG') AND rgn.lookup_type (+) = 'REGION' AND rgn.lookup_code (+) = glh.region_code GROUP BY glh.city_cid , glh.city_src_town_or_city_txt , area.meaning , ctr.territory_short_name , rgn.meaning , glh.area_code , glh.country_code , glh.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
, DECODE(GLH.CITY_CID
, 'NA_EDW'
, NULL
, GLH.CITY_SRC_TOWN_OR_CITY_TXT) VALUE_NULL
, 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.MEANING AREA_NAME
, CTR.TERRITORY_SHORT_NAME COUNTRY_NAME
, RGN.MEANING REGION_NAME
, GLH.AREA_CODE AREA_CODE
, GLH.COUNTRY_CODE COUNTRY_CODE
, GLH.REGION_CODE REGION_CODE
FROM HRI_CS_GEO_LOCHR_CT GLH
, FND_LOOKUPS AREA
, FND_TERRITORIES_TL CTR
, FND_LOOKUPS RGN
WHERE (GLH.CITY_SRC_TOWN_OR_CITY_TXT <> 'NA_EDW' OR GLH.LOCATION_ID = -1)
AND AREA.LOOKUP_TYPE (+) = 'AREA'
AND AREA.LOOKUP_CODE (+) = GLH.AREA_CODE
AND CTR.TERRITORY_CODE (+) = GLH.COUNTRY_CODE
AND CTR.LANGUAGE (+) = USERENV('LANG')
AND RGN.LOOKUP_TYPE (+) = 'REGION'
AND RGN.LOOKUP_CODE (+) = GLH.REGION_CODE GROUP BY GLH.CITY_CID
, GLH.CITY_SRC_TOWN_OR_CITY_TXT
, AREA.MEANING
, CTR.TERRITORY_SHORT_NAME
, RGN.MEANING
, GLH.AREA_CODE
, GLH.COUNTRY_CODE
, GLH.REGION_CODE WITH READ ONLY