FND Design Data [Home] [Help]

View: BIC_STATES_V

Product: BIC - Customer Intelligence (obsolete)
Description: This view fetches state names from bic_dimv_geography.
Implementation/DBA Data: ViewAPPS.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