BIM Views (178)

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

ViewDescription
BIM_DIMV_CAMPAIGNS Shows all campaigns.
BIM_DIMV_CHANNELS Shows all marketing channels which includes media channels, events and event offerings.
BIM_DIMV_EVENT_HEADERS Shows all events.
BIM_DIMV_EVENT_HIER Shows relationship between events and event offerings.
BIM_DIMV_EVENT_OFFERS Shows all event offers.
BIM_DIMV_EVENT_TYPES Shows all event types.
BIM_DIMV_GEOGRAPHY Shows locations at the postal code level.
BIM_DIMV_INTEREST_CODES not used.
BIM_DIMV_INTEREST_TYPES not used.
BIM_DIMV_MARKET_SGMTS Shows all market segments.
BIM_DIMV_MEDIA Shows all marketing media.
BIM_DIMV_MEDIA_CHANNELS Shows the relationship between media and the channels..
BIM_DIMV_OFFERS Shows all marketing offers
BIM_DIMV_PERIODS Shows all the periods defined in gl_period for a user-selected accounting calendar
BIM_DIMV_PROD_HIER Shows the relationship between inventory items, interest types, primary interest codes and secondary interest codes.
BIM_DIMV_PROD_LOV Shows the relationship between interest types, primary interest codes and secondary interest codes.
BIM_DIMV_SALES_CHANNELS Shows all sales channels.
BIM_DIMV_SOURCE_CODES_V Shows details for all marketing source codes.
BIM_DIMV_SOURCE_LISTS Shows all source lists.
BIM_DIMV_TARGET_SGMTS Shows all target segments.
BIM_DIMV_TOTAL_CAMPAIGNS Used by performance management framework.
BIM_DIMV_TOTAL_CHANNELS Used by performance management framework.
BIM_DIMV_TOTAL_EVENTS Used by performance management framework.
BIM_DIMV_TOTAL_MEDIA Used by performance management framework.
BIM_DIMV_TOTAL_OFFERS Used by performance management framework.
BIM_DIMV_TOT_EVENT_OFRS Used by performance management framework.
BIM_DIMV_TOT_TGT_SGMTS Used by performance management framework.
BIM_DIMV_USER_STATUSES Shows all user-defined statuses.
BIM_EDW_CMPFRCST_FCV
BIM_EDW_CMPFRCST_F_IV Instead of Views
BIM_EDW_EVENT_COST_V
BIM_EDW_EVENT_REVENUE_V
BIM_EDW_EVTFRCST_FCV
BIM_EDW_EVTFRCST_F_IV Instead of Views
BIM_EDW_INTRCTNS_FCV
BIM_EDW_INTRCTNS_F_IV Instead of Views
BIM_EDW_LEADS_FCV
BIM_EDW_LEADS_F_IV Instead of Views
BIM_EDW_OPRNTIES_FCV
BIM_EDW_OPRNTIES_F_IV Instead of Views
BIM_EDW_RVCT_DLY_F_IV Instead of Views
BIM_EDW_RVCT_MTH_F_IV Instead of Views
BIM_FCTV_CAMPAIGNS Used by the concurrent programs to load the summary tables.
BIM_FCTV_EVENTS Used by the concurrent programs to load the summary tables.
BIM_FCTV_LEADLINES Used by the concurrent programs to load the summary tables.
BIM_FCTV_LEADS Used by the concurrent programs to load the summary tables.
BIM_FCTV_NEW_CUST_ACCTS Used by the concurrent programs to load the summary tables.
BIM_FCTV_OPPLINES Used by the concurrent programs to load the summary tables.
BIM_FCTV_OPPORTUNITIES Used by the concurrent programs to load the summary tables.
BIM_FCTV_OPPR_CYCLE Used by the concurrent programs to load the summary tables.
BIM_FCTV_ORDERS Used by the concurrent programs to load the summary tables.
BIM_FCTV_ORDER_LINES Used by the concurrent programs to load the summary tables.
BIM_FCTV_ORDER_OFFERS Used by the concurrent programs to load the summary tables.
BIM_FCTV_RESPONSES Used by the concurrent programs to load the summary tables.
BIM_FCTV_REV_COGS Used by the concurrent programs to load the summary tables.
BIM_FCTV_SALES_CYCLE Used by the concurrent programs to load the summary tables.
BIM_FCTV_TARGETS Used by the concurrent programs to load the summary tables.
BIM_SUMV_CAMP_COST Joins the summary table to the dimension views.
BIM_SUMV_CAMP_MARGIN Joins the summary table to the dimension views.
BIM_SUMV_CAMP_PERF Joins the summary table to the dimension views.
BIM_SUMV_CAMP_RESP Joins the summary table to the dimension views.
BIM_SUMV_EVENT_PERF Joins the summary table to the dimension views.
BIM_SUMV_EVENT_REV Joins the summary table to the dimension views.
BIM_SUMV_EVENT_RSLTS Joins the summary table to the dimension views.
BIM_SUMV_LEAD_CONV Joins the summary table to the dimension views.
BIM_SUMV_SALES_CYCLE Joins the summary table to the dimension views.
BIM_SUMV_SLIST_PERF Joins the summary table to the dimension views.
BIM_SUMV_SLIST_PROFIT Joins the summary table to the dimension views.
EDW_BIM_CAMP_CMPGNS_L1_LCV
EDW_BIM_CAMP_CMPGNS_L1_LTC_IV
EDW_BIM_CAMP_CMPGNS_L2_LCV
EDW_BIM_CAMP_CMPGNS_L2_LTC_IV
EDW_BIM_CAMP_CMPGNS_L3_LCV
EDW_BIM_CAMP_CMPGNS_L3_LTC_IV
EDW_BIM_CAMP_CMPGNS_L4_LCV
EDW_BIM_CAMP_CMPGNS_L4_LTC_IV
EDW_BIM_CAMP_CMPGNS_L5_LCV
EDW_BIM_CAMP_CMPGNS_L5_LTC_IV
EDW_BIM_CAMP_CMPGNS_L6_LCV
EDW_BIM_CAMP_CMPGNS_L6_LTC_IV
EDW_BIM_CAMP_CMPGNS_L7_LCV
EDW_BIM_CAMP_CMPGNS_L7_LTC_IV
EDW_BIM_CAMP_CMPGNS_L8_LCV
EDW_BIM_CAMP_CMPGNS_L8_LTC_IV
EDW_BIM_CAMP_CMPGNS_LCV
EDW_BIM_CAMP_CMPGNS_LTC_IV
EDW_BIM_CAMP_SCHEDULES_LCV
EDW_BIM_CAMP_SCHEDULES_LTC_IV
EDW_BIM_CMPGNS_A_LTC_IV
EDW_BIM_CMPGNS_M_IV
EDW_BIM_CMPSTATS_A_LTC_IV
EDW_BIM_CMPSTATS_M_IV
EDW_BIM_CSTA_CMPSTATS_LCV
EDW_BIM_CSTA_CMPSTATS_LTC_IV
EDW_BIM_EVENTS_A_LTC_IV
EDW_BIM_EVENTS_M_IV
EDW_BIM_EVNT_EVENTS_LCV
EDW_BIM_EVNT_EVENTS_LTC_IV
EDW_BIM_EVNT_EVTOFFERS_LCV
EDW_BIM_EVNT_EVTOFFERS_LTC_IV
EDW_BIM_IHMD_IH_MEDIA_LCV
EDW_BIM_IHMD_IH_MEDIA_LTC_IV
EDW_BIM_IHOT_IH_OUTCOME_LCV
EDW_BIM_IHOT_IH_OUTCOME_LTC_IV
EDW_BIM_IHRN_IH_REASON_LCV
EDW_BIM_IHRN_IH_REASON_LTC_IV
EDW_BIM_IHRS_IH_RESULT_LCV
EDW_BIM_IHRS_IH_RESULT_LTC_IV
EDW_BIM_IH_MEDIA_A_LTC_IV
EDW_BIM_IH_MEDIA_M_IV
EDW_BIM_IH_OUTCM_A_LTC_IV
EDW_BIM_IH_OUTCM_M_IV
EDW_BIM_IH_REASN_A_LTC_IV
EDW_BIM_IH_REASN_M_IV
EDW_BIM_IH_RESLT_A_LTC_IV
EDW_BIM_IH_RESLT_M_IV
EDW_BIM_LEADS_A_LTC_IV
EDW_BIM_LEADS_M_IV
EDW_BIM_LEAD_LEADLINES_LCV
EDW_BIM_LEAD_LEADLINES_LTC_IV
EDW_BIM_LEAD_LEADS_LCV
EDW_BIM_LEAD_LEADS_LTC_IV
EDW_BIM_LEAD_STATUS_A_LTC_IV
EDW_BIM_LEAD_STATUS_M_IV
EDW_BIM_LIST_SRCLSTS_LCV
EDW_BIM_LIST_SRCLSTS_LTC_IV
EDW_BIM_LSTA_LEADSTATUS_LCV
EDW_BIM_LSTA_LEADSTATUS_LTC_IV
EDW_BIM_MDCHN_A_LTC_IV
EDW_BIM_MDCHN_M_IV
EDW_BIM_MDCH_CHANNELS_LCV
EDW_BIM_MDCH_CHANNELS_LTC_IV
EDW_BIM_MDCH_MDCHN_LCV
EDW_BIM_MDCH_MDCHN_LTC_IV
EDW_BIM_MDCH_MDTYPES_LCV
EDW_BIM_MDCH_MDTYPES_LTC_IV
EDW_BIM_MDCH_MEDIA_LCV
EDW_BIM_MDCH_MEDIA_LTC_IV
EDW_BIM_MKSG_MKTSGMTS_LCV
EDW_BIM_MKSG_MKTSGMTS_LTC_IV
EDW_BIM_MKTSGMTS_A_LTC_IV
EDW_BIM_MKTSGMTS_M_IV
EDW_BIM_OFFERS_A_LTC_IV
EDW_BIM_OFFERS_M_IV
EDW_BIM_OFFR_OFFERS_LCV
EDW_BIM_OFFR_OFFERS_LTC_IV
EDW_BIM_OPPORTUNITIES_A_LTC_IV
EDW_BIM_OPPORTUNITIES_M_IV
EDW_BIM_OPPR_OPPLINES_LCV
EDW_BIM_OPPR_OPPLINES_LTC_IV
EDW_BIM_OPPR_OPRNTIES_LCV
EDW_BIM_OPPR_OPRNTIES_LTC_IV
EDW_BIM_OPP_STATUS_A_LTC_IV
EDW_BIM_OPP_STATUS_M_IV
EDW_BIM_OSTA_OPPSTATUS_LCV
EDW_BIM_OSTA_OPPSTATUS_LTC_IV
EDW_BIM_SRCLSTS_A_LTC_IV
EDW_BIM_SRCLSTS_M_IV
EDW_BIM_TGSMT_A_LTC_IV
EDW_BIM_TGSMT_M_IV
EDW_BIM_TGST_TGSMT_L1_LCV
EDW_BIM_TGST_TGSMT_L1_LTC_IV
EDW_BIM_TGST_TGSMT_L2_LCV
EDW_BIM_TGST_TGSMT_L2_LTC_IV
EDW_BIM_TGST_TGSMT_L3_LCV
EDW_BIM_TGST_TGSMT_L3_LTC_IV
EDW_BIM_TGST_TGSMT_L4_LCV
EDW_BIM_TGST_TGSMT_L4_LTC_IV
EDW_BIM_TGST_TGSMT_L5_LCV
EDW_BIM_TGST_TGSMT_L5_LTC_IV
EDW_BIM_TGST_TGSMT_L6_LCV
EDW_BIM_TGST_TGSMT_L6_LTC_IV
EDW_BIM_TGST_TGSMT_L7_LCV
EDW_BIM_TGST_TGSMT_L7_LTC_IV
EDW_BIM_TGST_TGSMT_L8_LCV
EDW_BIM_TGST_TGSMT_L8_LTC_IV
EDW_BIM_TGST_TGSMT_LCV
EDW_BIM_TGST_TGSMT_LTC_IV