VIEW: APPS.HRI_OBI_CL_GEO_COUNTRY_V

Source

View Text - Preformatted

SELECT csc.geo_country_code AS ctry_country_pk, decode(csc.geo_country_code, 'NA_EDW', hri_oltp_view_message.get_unassigned_msg, nvl(trtt.territory_short_name,hri_oltp_view_message.get_unassigned_msg)) || ' (' || csc.geo_country_code || ')' AS ctry_country_name_unq, decode(csc.geo_country_code, 'NA_EDW', hri_oltp_view_message.get_unassigned_msg, nvl(trtt.territory_short_name,hri_oltp_view_message.get_unassigned_msg)) AS ctry_country_name, decode(csc.geo_country_code, 'NA_EDW', NULL, trtt.territory_short_name) AS ctry_order_by, csc.geo_area_code AS ctry_area_fk, 'Y' AS ctry_lochr_exists_flag FROM hri_cs_geo_country_ct csc, fnd_territories_tl trtt WHERE csc.geo_country_code = trtt.territory_code(+) AND trtt.LANGUAGE(+) = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT CSC.GEO_COUNTRY_CODE AS CTRY_COUNTRY_PK
, DECODE(CSC.GEO_COUNTRY_CODE
, 'NA_EDW'
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, NVL(TRTT.TERRITORY_SHORT_NAME
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG)) || ' (' || CSC.GEO_COUNTRY_CODE || ')' AS CTRY_COUNTRY_NAME_UNQ
, DECODE(CSC.GEO_COUNTRY_CODE
, 'NA_EDW'
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, NVL(TRTT.TERRITORY_SHORT_NAME
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG)) AS CTRY_COUNTRY_NAME
, DECODE(CSC.GEO_COUNTRY_CODE
, 'NA_EDW'
, NULL
, TRTT.TERRITORY_SHORT_NAME) AS CTRY_ORDER_BY
, CSC.GEO_AREA_CODE AS CTRY_AREA_FK
, 'Y' AS CTRY_LOCHR_EXISTS_FLAG
FROM HRI_CS_GEO_COUNTRY_CT CSC
, FND_TERRITORIES_TL TRTT
WHERE CSC.GEO_COUNTRY_CODE = TRTT.TERRITORY_CODE(+)
AND TRTT.LANGUAGE(+) = USERENV('LANG') WITH READ ONLY