BIC Views (73)

BIC - Customer Intelligence(Obsolete) — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

ViewDescription
BIC_ACTIVITIES_V
BIC_ADDRESS_V View on HZ_LOCATIONS which gives formatted address
BIC_CAMPAIGN_LIST_V
BIC_CAMPAIGN_MARKET_SEGMENTS_V
BIC_CITIES_V This view fetches city names from bic_dimv_geography.
BIC_CONTACTS_DETAIL_V
BIC_CONTACTS_V
BIC_CONTACT_POINTS_V This view is based on single table hz_contact_points.
BIC_CONTRACT_HEADERS_V
BIC_CP_CONTACTS_V
BIC_CUSLIST_SUMMARY_V
BIC_CUSLIST_V
BIC_CUSTOMER_SUMMARY
BIC_CUSTOMER_SUMMARY_V
BIC_CUST_CATEGORY_V This view is based on the denormalized table for the customer category hierarchy.
BIC_DIMV_CUSTOMERS
BIC_DIMV_CUST_CATEGORIES
BIC_DIMV_GEOGRAPHY
BIC_DIMV_MARKET_SEGMENTS
BIC_DIMV_OPERATING_UNITS This is dimension view for operating units.
BIC_DIMV_PERIOD_TYPES
BIC_FCTV_SR_CLOSE
BIC_FCTV_SR_ESCALATED
BIC_FCTV_SR_OPEN
BIC_FCTV_SR_RESPONSE
BIC_FCTV_SR_REWORKED
BIC_FCTV_SR_TOTAL
BIC_INSTALLED_BASE_DETAIL_V
BIC_INSTALLED_BASE_SUMMARY_V
BIC_INTERACTIONS_DETAIL_V
BIC_INTERACTIONS_SUMMARY_V
BIC_INTERACTIONS_V
BIC_INVLINE_DETAIL_V
BIC_INVLINE_V
BIC_INVLIST_V
BIC_LC_SETUP
BIC_MARKET_SEGMENT_V This view gets market segments from view ams_cells_vl.
BIC_MEASURES
BIC_NEW_PARTY_LIST_V
BIC_OPTY_DETAIL_V
BIC_OPTY_SUMMARY_V
BIC_ORDERS_DETAIL_V
BIC_ORDERS_SUMMARY_V
BIC_PARTIES_V
BIC_PARTYLIST_SUMMARY_V
BIC_PARTY_LIST_V
BIC_PARTY_LOYALTY_INDEX_V
BIC_PARTY_SAT_INDEX_V
BIC_PARTY_STATUS_SUMM_V
BIC_PARTY_SUMMARY_V
BIC_PARTY_SUMM_V
BIC_PMF_SUMMARY_V
BIC_PROFILE_VALUES
BIC_REVENUE_TRX_DETAIL_V
BIC_REVENUE_TRX_SUMMARY_V
BIC_SALES_QUOTES_DETAIL_V Sales Quotes Detail view - returns sales quotes detail lines, address, contacts
BIC_SALES_QUOTES_SUMMARY_V Sales quotes summary information
BIC_SERVICE_REQUEST_DETAIL_V
BIC_SERVICE_REQUEST_SUMMARY_V
BIC_SITE_ADDRESS_V
BIC_STANDARD_VALUES_V
BIC_STATES_V This view fetches state names from bic_dimv_geography.
BIC_SUMV_ACQUISITION
BIC_SUMV_ACTIVATION
BIC_SUMV_COGS
BIC_SUMV_LIFECYCLE
BIC_SUMV_LOYALTY
BIC_SUMV_PROFITABILITY
BIC_SUMV_RETENTION
BIC_SUMV_REVENUE
BIC_SUMV_SATISFACTION
BIC_TOTAL_CUST_CATEGORY_V This view gets the dimension level names for customer category from bisbv_dimension_levels.
BIC_TOTAL_MARKET_SEGMENT_V This view gets the dimension level names for market segment from bisbv_dimension_levels.