[Home] [Help]
View: BIC_STATES_V
Product: | BIC - Customer Intelligence (obsolete) |
Description: | This view fetches state names from bic_dimv_geography. |
Implementation/DBA Data: |
APPS.BIC_STATES_V
|
View Text
SELECT STATE ID
, STATE_NAME VALUE
, STATE STATE_ID
, STATE_NAME STATE_NAME
, GEOGRAPHY_ID
FROM BIC_DIMV_GEOGRAPHY
Columns
Name |
ID |
VALUE |
STATE_ID |
STATE_NAME |
GEOGRAPHY_ID |