VIEW: APPS.HRI_OBI_CL_GEO_AREA_V

Source

View Text - Preformatted

SELECT csa.geo_area_code AS AREA_AREA_PK, DECODE(csa.geo_area_code ,'NA_EDW',hri_oltp_view_message.get_unassigned_msg ,areT.meaning)||' ('||csa.geo_area_code||')' AS AREA_AREA_NAME_UNQ, DECODE(csa.geo_area_code ,'NA_EDW',hri_oltp_view_message.get_unassigned_msg ,areT.meaning) AS AREA_AREA_NAME, DECODE(csa.geo_area_code ,'NA_EDW',NULL,areT.meaning) AS AREA_ORDER_BY , 'Y'AS AREA_LOCHR_EXISTS_FLAG 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 areT.lookup_type(+) = 'AREA' AND csa.geo_area_code = areT.lookup_code(+) WITH READ ONLY

View Text - HTML Formatted

SELECT CSA.GEO_AREA_CODE AS AREA_AREA_PK
, DECODE(CSA.GEO_AREA_CODE
, 'NA_EDW'
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, ARET.MEANING)||' ('||CSA.GEO_AREA_CODE||')' AS AREA_AREA_NAME_UNQ
, DECODE(CSA.GEO_AREA_CODE
, 'NA_EDW'
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG
, ARET.MEANING) AS AREA_AREA_NAME
, DECODE(CSA.GEO_AREA_CODE
, 'NA_EDW'
, NULL
, ARET.MEANING) AS AREA_ORDER_BY
, 'Y'AS AREA_LOCHR_EXISTS_FLAG
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 ARET.LOOKUP_TYPE(+) = 'AREA'
AND CSA.GEO_AREA_CODE = ARET.LOOKUP_CODE(+) WITH READ ONLY