VIEW: APPS.HRI_DBI_CL_GEO_AREA_V

Source

View Text - Preformatted

SELECT csa.geo_area_code ID , DECODE(csa.geo_area_code ,'NA_EDW',hri_oltp_view_message.get_unassigned_msg ,areT.meaning) VALUE , areT.meaning VALUE_NULL , areT.description VALUE_LONG , areT.meaning ORDER_BY , csa.START_DATE START_DATE , csa.end_date END_DATE , csa.geo_area_code geo_area_code FROM (SELECT geo_area_code geo_area_code , MIN(START_DATE) start_date , MAX(end_date) end_date FROM hri_cs_geo_country_ct GROUP BY geo_area_code) csa , fnd_lookups areT WHERE 1=1 AND areT.lookup_type(+) = 'AREA' AND csa.geo_area_code = areT.lookup_code(+) WITH READ ONLY

View Text - HTML Formatted

SELECT CSA.GEO_AREA_CODE ID
, DECODE(CSA.GEO_AREA_CODE
, 'NA_EDW'
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, ARET.MEANING) VALUE
, ARET.MEANING VALUE_NULL
, ARET.DESCRIPTION VALUE_LONG
, ARET.MEANING ORDER_BY
, CSA.START_DATE START_DATE
, CSA.END_DATE END_DATE
, CSA.GEO_AREA_CODE GEO_AREA_CODE
FROM (SELECT GEO_AREA_CODE GEO_AREA_CODE
, MIN(START_DATE) START_DATE
, MAX(END_DATE) END_DATE
FROM HRI_CS_GEO_COUNTRY_CT GROUP BY GEO_AREA_CODE) CSA
, FND_LOOKUPS ARET
WHERE 1=1
AND ARET.LOOKUP_TYPE(+) = 'AREA'
AND CSA.GEO_AREA_CODE = ARET.LOOKUP_CODE(+) WITH READ ONLY