[Home] [Help]
View: BIC_CITIES_V
Product: | BIC - Customer Intelligence (obsolete) |
Description: | This view fetches city names from bic_dimv_geography. |
Implementation/DBA Data: |
APPS.BIC_CITIES_V
|
View Text
SELECT CITY ID
, CITY_NAME VALUE
, CITY CITY_ID
, CITY_NAME CITY_NAME
, GEOGRAPHY_ID
FROM BIC_DIMV_GEOGRAPHY
Columns
Name |
ID |
VALUE |
CITY_ID |
CITY_NAME |
GEOGRAPHY_ID |