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_DBI_CS_GEO_REGION_V

Source

View Text - Preformatted


SELECT cs_glh.area_code geo_area_code , cs_glh.country_code geo_country_code , cs_glh.region_code geo_region_code , cs_glh.area_code|| '+'||cs_glh.country_code|| '+'||cs_glh.region_code geo_region_sk_pk , MIN(cs_glh.effective_start_date) start_date , MAX(cs_glh.effective_end_date) end_date , COUNT(distinct cs_glh.city_cid) city_count_in_region , COUNT(distinct cs_glh.location_id) location_count_in_region , MAX(cs_glh.last_change_date) last_change_date , MIN(cs_glh.last_change_date) earliest_change_date FROM hri_cs_geo_lochr_ct cs_glh GROUP BY cs_glh.area_code , cs_glh.country_code , cs_glh.region_code WITH READ ONLY

View Text - HTML Formatted

SELECT CS_GLH.AREA_CODE GEO_AREA_CODE
, CS_GLH.COUNTRY_CODE GEO_COUNTRY_CODE
, CS_GLH.REGION_CODE GEO_REGION_CODE
, CS_GLH.AREA_CODE|| '+'||CS_GLH.COUNTRY_CODE|| '+'||CS_GLH.REGION_CODE GEO_REGION_SK_PK
, MIN(CS_GLH.EFFECTIVE_START_DATE) START_DATE
, MAX(CS_GLH.EFFECTIVE_END_DATE) END_DATE
, COUNT(DISTINCT CS_GLH.CITY_CID) CITY_COUNT_IN_REGION
, COUNT(DISTINCT CS_GLH.LOCATION_ID) LOCATION_COUNT_IN_REGION
, MAX(CS_GLH.LAST_CHANGE_DATE) LAST_CHANGE_DATE
, MIN(CS_GLH.LAST_CHANGE_DATE) EARLIEST_CHANGE_DATE
FROM HRI_CS_GEO_LOCHR_CT CS_GLH GROUP BY CS_GLH.AREA_CODE
, CS_GLH.COUNTRY_CODE
, CS_GLH.REGION_CODE WITH READ ONLY