VIEW: APPS.HRI_DBI_CL_GEO_REGION_V

Source

View Text - Preformatted

SELECT csr.geo_region_sk_pk ID , DECODE(csr.geo_region_code ,'NA_EDW',hri_oltp_view_message.get_unassigned_msg ,regT.meaning) VALUE , regT.meaning VALUE_NULL , regT.meaning VALUE_LONG , DECODE(csr.geo_region_code ,'NA_EDW',NULL ,regT.meaning) ORDER_BY , csr.start_date START_DATE , csr.end_date END_DATE , csr.geo_area_code geo_area_code , csr.geo_country_code geo_country_code , csr.geo_region_code geo_region_code , csr.geo_region_sk_pk geo_region_sk_pk FROM hri_cs_geo_region_ct csr , fnd_lookups regT WHERE 1=1 AND csr.geo_region_code = regT.lookup_code (+) AND regT.lookup_type(+) = 'REGION' AND regT.enabled_flag(+) = 'Y' WITH READ ONLY

View Text - HTML Formatted

SELECT CSR.GEO_REGION_SK_PK ID
, DECODE(CSR.GEO_REGION_CODE
, 'NA_EDW'
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, REGT.MEANING) VALUE
, REGT.MEANING VALUE_NULL
, REGT.MEANING VALUE_LONG
, DECODE(CSR.GEO_REGION_CODE
, 'NA_EDW'
, NULL
, REGT.MEANING) ORDER_BY
, CSR.START_DATE START_DATE
, CSR.END_DATE END_DATE
, CSR.GEO_AREA_CODE GEO_AREA_CODE
, CSR.GEO_COUNTRY_CODE GEO_COUNTRY_CODE
, CSR.GEO_REGION_CODE GEO_REGION_CODE
, CSR.GEO_REGION_SK_PK GEO_REGION_SK_PK
FROM HRI_CS_GEO_REGION_CT CSR
, FND_LOOKUPS REGT
WHERE 1=1
AND CSR.GEO_REGION_CODE = REGT.LOOKUP_CODE (+)
AND REGT.LOOKUP_TYPE(+) = 'REGION'
AND REGT.ENABLED_FLAG(+) = 'Y' WITH READ ONLY