View: BIM_DIMV_GEOGRAPHY

Product:	BIM - Marketing Intelligence(Obsolete)
Description:	Shows locations at the postal code level.
Implementation/DBA Data:	APPS.BIM_DIMV_GEOGRAPHY

View Text

SELECT GEO.LOCATION_HIERARCHY_CODE LOCATION_HIERARCHY_CODE
, GEO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GEO.COUNTRY COUNTRY
, NVL(GEO.COUNTRY
, '-999') COUNTRY_CODE
, GEO.STATE STATE
, NVL(GEO.STATE
, '-999') STATE_CODE
, GEO.CITY CITY
, NVL(GEO.CITY
, '-999') CITY_CODE
, GEO.POSTAL_CODE POSTAL_CODE
, NVL(GEO.POSTAL_CODE
, '-999') POSTAL_CODE_VALUE
FROM BIM_GEOGRAPHY GEO UNION ALL SELECT '-999'
, TO_DATE(NULL)
, MEANING
, '-999'
, MEANING
, '-999'
, MEANING
, '-999'
, MEANING
, '-999'
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999'

Columns