View: BIC_DIMV_GEOGRAPHY

Product:	BIC - Customer Intelligence (obsolete)
Description:
Implementation/DBA Data:	APPS.BIC_DIMV_GEOGRAPHY

View Text

SELECT DISTINCT 1 GEOGRAPHY_ID
, COUNTRY
, COUNTRY COUNTRY_NAME
, STATE
, STATE STATE_NAME
, CITY
, CITY CITY_NAME
FROM BIM_GEOGRAPHY UNION ALL SELECT DISTINCT -999 GEOGRAPHY_ID
, MEANING COUNTRY
, MEANING COUNTRY_NAME
, MEANING STATE
, MEANING STATE_NAME
, MEANING CITY
, MEANING CITY_NAME
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIC_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' WITH READ ONLY

Columns