VIEW: APPS.HRI_DBI_CL_GEO_COUNTRY_V

Source

View Text - Preformatted

SELECT csc.geo_country_code ID , DECODE(csc.geo_country_code ,'NA_EDW',hri_oltp_view_message.get_unassigned_msg ,trtT.territory_short_name) VALUE , trtT.territory_short_name VALUE_NULL , trtT.description VALUE_LONG , DECODE(csc.geo_country_code ,'NA_EDW',NULL ,trtT.territory_short_name) ORDER_BY , csc.start_date START_DATE , csc.end_date END_DATE , csc.geo_area_code geo_area_code , csc.geo_country_code geo_country_code FROM hri_cs_geo_country_ct csc , fnd_territories_tl trtT WHERE 1=1 AND csc.geo_country_code = trtT.territory_code(+) AND trtT.LANGUAGE(+) = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT CSC.GEO_COUNTRY_CODE ID
, DECODE(CSC.GEO_COUNTRY_CODE
, 'NA_EDW'
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, TRTT.TERRITORY_SHORT_NAME) VALUE
, TRTT.TERRITORY_SHORT_NAME VALUE_NULL
, TRTT.DESCRIPTION VALUE_LONG
, DECODE(CSC.GEO_COUNTRY_CODE
, 'NA_EDW'
, NULL
, TRTT.TERRITORY_SHORT_NAME) ORDER_BY
, CSC.START_DATE START_DATE
, CSC.END_DATE END_DATE
, CSC.GEO_AREA_CODE GEO_AREA_CODE
, CSC.GEO_COUNTRY_CODE GEO_COUNTRY_CODE
FROM HRI_CS_GEO_COUNTRY_CT CSC
, FND_TERRITORIES_TL TRTT
WHERE 1=1
AND CSC.GEO_COUNTRY_CODE = TRTT.TERRITORY_CODE(+)
AND TRTT.LANGUAGE(+) = USERENV('LANG') WITH READ ONLY