You are browsing the archive for EDW.

Oracle Marketing Intelligence Tables

Oracle Marketing Intelligence module database table information:

  • BIM_CAMPAIGNS_DENORM
  • BIM_CMPGN_PERF_SUMM
  • BIM_CMPGN_RESP_SUMM
  • BIM_CMPGN_REVCOST_SUMM
  • BIM_CUSTOMER_REV_SUMM
  • BIM_EDW_CMPFRCST_F
  • BIM_EDW_CMPFRCST_FSTG
  • BIM_EDW_CMPFRCST_F_DLOG
  • BIM_EDW_CMPFRCST_INC
  • BIM_EDW_EVTFRCST_F
  • BIM_EDW_EVTFRCST_FSTG
  • BIM_EDW_EVTFRCST_F_DLOG
  • BIM_EDW_EVTFRCST_INC
  • BIM_EDW_INTRCTNS_F
  • BIM_EDW_INTRCTNS_FSTG
  • BIM_EDW_INTRCTNS_F_DLOG
  • BIM_EDW_INTRCTNS_F_ILOG
  • BIM_EDW_INTRCTNS_INC
  • BIM_EDW_LEADS_F
  • BIM_EDW_LEADS_FSTG
  • BIM_EDW_LEADS_F_DLOG
  • BIM_EDW_LEADS_INC
  • BIM_EDW_OPRNTIES_F
  • BIM_EDW_OPRNTIES_FSTG
  • BIM_EDW_OPRNTIES_F_DLOG
  • BIM_EDW_OPRNTIES_INC
  • BIM_EDW_RVCT_DLY_F
  • BIM_EDW_RVCT_MTH_F
  • BIM_EVENT_PERF_SUMM
  • BIM_EVENT_RESP_SUMM
  • BIM_EVENT_REVCOST_SUMM
  • BIM_GEOGRAPHY
  • BIM_LEAD_CONV_SUMM
  • BIM_OPPR_CYCLE_SUMM
  • BIM_SALES_CATEGORY_HIER
  • BIM_SALES_CYCLE_SUMM
  • BIM_SLIST_PROFIT_SUMM
  • BIM_SOURCE_CODE_DETAILS
  • BIM_TARGET_SEGMENTS_DENORM
  • BIM_TRGT_SGMT_PERF_SUMM
  • EDW_BIM_CAMP_CMPGNS_L1_LSTG
  • EDW_BIM_CAMP_CMPGNS_L1_LTC
  • EDW_BIM_CAMP_CMPGNS_L2_LSTG
  • EDW_BIM_CAMP_CMPGNS_L2_LTC
  • EDW_BIM_CAMP_CMPGNS_L3_LSTG
  • EDW_BIM_CAMP_CMPGNS_L3_LTC
  • EDW_BIM_CAMP_CMPGNS_L4_LSTG
  • EDW_BIM_CAMP_CMPGNS_L4_LTC
  • EDW_BIM_CAMP_CMPGNS_L5_LSTG
  • EDW_BIM_CAMP_CMPGNS_L5_LTC
  • EDW_BIM_CAMP_CMPGNS_L6_LSTG
  • EDW_BIM_CAMP_CMPGNS_L6_LTC
  • EDW_BIM_CAMP_CMPGNS_L7_LSTG
  • EDW_BIM_CAMP_CMPGNS_L7_LTC
  • EDW_BIM_CAMP_CMPGNS_L8_LSTG
  • EDW_BIM_CAMP_CMPGNS_L8_LTC
  • EDW_BIM_CAMP_CMPGNS_LSTG
  • EDW_BIM_CAMP_CMPGNS_LTC
  • EDW_BIM_CAMP_SCHEDULES_LSTG
  • EDW_BIM_CAMP_SCHEDULES_LTC
  • EDW_BIM_CMPGNS_A_LTC
  • EDW_BIM_CMPGNS_DENORM
  • EDW_BIM_CMPGNS_M
  • EDW_BIM_CMPSTATS_A_LTC
  • EDW_BIM_CMPSTATS_M
  • EDW_BIM_CSTA_CMPSTATS_LSTG
  • EDW_BIM_CSTA_CMPSTATS_LTC
  • EDW_BIM_EVENTS_A_LTC
  • EDW_BIM_EVENTS_M
  • EDW_BIM_EVNT_EVENTS_LSTG
  • EDW_BIM_EVNT_EVENTS_LTC
  • EDW_BIM_EVNT_EVTOFFERS_LSTG
  • EDW_BIM_EVNT_EVTOFFERS_LTC
  • EDW_BIM_IHMD_IH_MEDIA_LSTG
  • EDW_BIM_IHMD_IH_MEDIA_LTC
  • EDW_BIM_IHOT_IH_OUTCOME_LSTG
  • EDW_BIM_IHOT_IH_OUTCOME_LTC
  • EDW_BIM_IHRN_IH_REASON_LSTG
  • EDW_BIM_IHRN_IH_REASON_LTC
  • EDW_BIM_IHRS_IH_RESULT_LSTG
  • EDW_BIM_IHRS_IH_RESULT_LTC
  • EDW_BIM_IH_MEDIA_A_LTC
  • EDW_BIM_IH_MEDIA_M
  • EDW_BIM_IH_OUTCM_A_LTC
  • EDW_BIM_IH_OUTCM_M
  • EDW_BIM_IH_REASN_A_LTC
  • EDW_BIM_IH_REASN_M
  • EDW_BIM_IH_RESLT_A_LTC
  • EDW_BIM_IH_RESLT_M
  • EDW_BIM_LEADS_A_LTC
  • EDW_BIM_LEADS_M
  • EDW_BIM_LEAD_LEADLINES_LSTG
  • EDW_BIM_LEAD_LEADLINES_LTC
  • EDW_BIM_LEAD_LEADS_LSTG
  • EDW_BIM_LEAD_LEADS_LTC
  • EDW_BIM_LEAD_STATUS_A_LTC
  • EDW_BIM_LEAD_STATUS_M
  • EDW_BIM_LIST_SRCLSTS_LSTG
  • EDW_BIM_LIST_SRCLSTS_LTC
  • EDW_BIM_LSTA_LEADSTATUS_LSTG
  • EDW_BIM_LSTA_LEADSTATUS_LTC
  • EDW_BIM_MDCHN_A_LTC
  • EDW_BIM_MDCHN_M
  • EDW_BIM_MDCH_CHANNELS_LSTG
  • EDW_BIM_MDCH_CHANNELS_LTC
  • EDW_BIM_MDCH_MDCHN_LSTG
  • EDW_BIM_MDCH_MDCHN_LTC
  • EDW_BIM_MDCH_MDTYPES_LSTG
  • EDW_BIM_MDCH_MDTYPES_LTC
  • EDW_BIM_MDCH_MEDIA_LSTG
  • EDW_BIM_MDCH_MEDIA_LTC
  • EDW_BIM_MKSG_MKTSGMTS_LSTG
  • EDW_BIM_MKSG_MKTSGMTS_LTC
  • EDW_BIM_MKTSGMTS_A_LTC
  • EDW_BIM_MKTSGMTS_M
  • EDW_BIM_OFFERS_A_LTC
  • EDW_BIM_OFFERS_M
  • EDW_BIM_OFFR_OFFERS_LSTG
  • EDW_BIM_OFFR_OFFERS_LTC
  • EDW_BIM_OPPORTUNITIES_A_LTC
  • EDW_BIM_OPPORTUNITIES_M
  • EDW_BIM_OPPR_OPPLINES_LSTG
  • EDW_BIM_OPPR_OPPLINES_LTC
  • EDW_BIM_OPPR_OPRNTIES_LSTG
  • EDW_BIM_OPPR_OPRNTIES_LTC
  • EDW_BIM_OPP_STATUS_A_LTC
  • EDW_BIM_OPP_STATUS_M
  • EDW_BIM_OSTA_OPPSTATUS_LSTG
  • EDW_BIM_OSTA_OPPSTATUS_LTC
  • EDW_BIM_SOURCE_CODE_DETAILS
  • EDW_BIM_SRCLSTS_A_LTC
  • EDW_BIM_SRCLSTS_M
  • EDW_BIM_TGSMT_A_LTC
  • EDW_BIM_TGSMT_DENORM
  • EDW_BIM_TGSMT_M
  • EDW_BIM_TGST_TGSMT_L1_LSTG
  • EDW_BIM_TGST_TGSMT_L1_LTC
  • EDW_BIM_TGST_TGSMT_L2_LSTG
  • EDW_BIM_TGST_TGSMT_L2_LTC
  • EDW_BIM_TGST_TGSMT_L3_LSTG
  • EDW_BIM_TGST_TGSMT_L3_LTC
  • EDW_BIM_TGST_TGSMT_L4_LSTG
  • EDW_BIM_TGST_TGSMT_L4_LTC
  • EDW_BIM_TGST_TGSMT_L5_LSTG
  • EDW_BIM_TGST_TGSMT_L5_LTC
  • EDW_BIM_TGST_TGSMT_L6_LSTG
  • EDW_BIM_TGST_TGSMT_L6_LTC
  • EDW_BIM_TGST_TGSMT_L7_LSTG
  • EDW_BIM_TGST_TGSMT_L7_LTC
  • EDW_BIM_TGST_TGSMT_L8_LSTG
  • EDW_BIM_TGST_TGSMT_L8_LTC
  • EDW_BIM_TGST_TGSMT_LSTG
  • EDW_BIM_TGST_TGSMT_LTC

Operations Intelligence Tables

Oracle Operations Intelligence Tables:

  • EDW_MTL_ILDM_LOCATOR_LSTG
  • EDW_MTL_ILDM_LOCATOR_LTC
  • EDW_MTL_ILDM_OU_LSTG
  • EDW_MTL_ILDM_OU_LTC
  • EDW_MTL_ILDM_PCMP_LSTG
  • EDW_MTL_ILDM_PCMP_LTC
  • EDW_MTL_ILDM_PLANT_LSTG
  • EDW_MTL_ILDM_PLANT_LTC
  • EDW_MTL_ILDM_PORG_LSTG
  • EDW_MTL_ILDM_PORG_LTC
  • EDW_MTL_ILDM_SUB_INV_LSTG
  • EDW_MTL_ILDM_SUB_INV_LTC
  • EDW_MTL_INVENTORY_LOC_A_LTC
  • EDW_MTL_INVENTORY_LOC_M
  • EDW_MTL_LOCAL_UOM_M
  • EDW_MTL_UOMD_UOM_LSTG
  • EDW_MTL_UOMD_UOM_LTC
  • EDW_MTL_UOM_A_LTC
  • EDW_MTL_UOM_M
  • EDW_OPI_ACTV_ACTV_LSTG
  • EDW_OPI_ACTV_ACTV_LTC
  • EDW_OPI_ACTV_A_LTC
  • EDW_OPI_ACTV_M
  • EDW_OPI_LOTD_LOT_LSTG
  • EDW_OPI_LOTD_LOT_LTC
  • EDW_OPI_LOT_A_LTC
  • EDW_OPI_LOT_M
  • EDW_OPI_OPRN_A_LTC
  • EDW_OPI_OPRN_M
  • EDW_OPI_OPRN_OPRC_LSTG
  • EDW_OPI_OPRN_OPRC_LTC
  • EDW_OPI_OPRN_OPRN_LSTG
  • EDW_OPI_OPRN_OPRN_LTC
  • EDW_OPI_PRDL_A_LTC
  • EDW_OPI_PRDL_M
  • EDW_OPI_PRDL_PRDL_LSTG
  • EDW_OPI_PRDL_PRDL_LTC
  • OPI_DBI_PTP_PLAN_STG
  • OPI_DBI_WMS_TASKS_STG
  • OPI_EDW_COGS_F
  • OPI_EDW_COGS_FSTG
  • OPI_EDW_COGS_F_DLOG
  • OPI_EDW_COGS_INC
  • OPI_EDW_COGS_LOG
  • OPI_EDW_IDS_NET_CHG
  • OPI_EDW_IDS_OPICOLLB_LOG
  • OPI_EDW_INV_DAILY_STAT_F
  • OPI_EDW_INV_DAILY_STAT_FSTG
  • OPI_EDW_INV_DAILY_STAT_F_DLOG
  • OPI_EDW_INV_PERD_STAT_F
  • OPI_EDW_IPS_NET_CHG
  • OPI_EDW_JOB_DETAIL_F
  • OPI_EDW_JOB_DETAIL_FSTG
  • OPI_EDW_JOB_RSRC_F
  • OPI_EDW_JOB_RSRC_FSTG
  • OPI_EDW_LOCAL_UOM_CONV_F
  • OPI_EDW_MARGIN_COGS_ILOG
  • OPI_EDW_MARGIN_F
  • OPI_EDW_MARGIN_PERD_FD
  • OPI_EDW_MARGIN_PERD_FDLG
  • OPI_EDW_MARGIN_PERD_FIR
  • OPI_EDW_MARGIN_PERD_ILOG
  • OPI_EDW_MRG_KEYS
  • OPI_EDW_MRG_MAX_VALUES
  • OPI_EDW_OPI_JOB_DETAIL_INC
  • OPI_EDW_OPI_JOB_RSRC_INC
  • OPI_EDW_OPI_JOB_RSRC_MR_TMP
  • OPI_EDW_OPMCOGS_INC
  • OPI_EDW_OPM_JOB_DETAIL_INC
  • OPI_EDW_OPM_JOB_RSRC_INC
  • OPI_EDW_PERD_MARGIN_F
  • OPI_EDW_PERD_MARGIN_FT
  • OPI_EDW_PERD_MARGIN_FUR
  • OPI_EDW_RES_UTIL_F
  • OPI_EDW_RES_UTIL_FSTG
  • OPI_EDW_RES_UTIL_PUSH_LOG
  • OPI_EDW_REV_LOG
  • OPI_EDW_UOM_CONV_F
  • OPI_EDW_UOM_CONV_FSTG
  • OPI_IDS_PUSH_DATE_LOG
  • OPI_IDS_PUSH_LOG
  • OPI_PMI_DAY_SUM_TEMP
  • OPI_PMI_IDS_IDNT
  • OPI_PMI_IDS_SUM_LOG
  • OPI_PMI_IDS_TEMP
  • OPI_PMI_INV_DAILY_STAT_SUM
  • OPI_PMI_INV_DAILY_STAT_TEMP
  • OPI_PMI_TRANS_INC

Process Manufacturing Intelligence Tables

Oracle Process Manufacturing Intelligence Tables:

  • EDW_PMI_FORMULA_A_LTC
  • EDW_PMI_FORMULA_M
  • EDW_PMI_GRADE_A_LTC
  • EDW_PMI_GRADE_M
  • EDW_PMI_INVLOC_A_LTC
  • EDW_PMI_INVLOC_M
  • EDW_PMI_PASY_PASY_LSTG
  • EDW_PMI_PASY_PASY_LTC
  • EDW_PMI_PFRM_PFRM_LSTG
  • EDW_PMI_PFRM_PFRM_LTC
  • EDW_PMI_PGRD_PGRD_LSTG
  • EDW_PMI_PGRD_PGRD_LTC
  • EDW_PMI_PMIL_PCMP_LSTG
  • EDW_PMI_PMIL_PCMP_LTC
  • EDW_PMI_PMIL_PLOC_LSTG
  • EDW_PMI_PMIL_PLOC_LTC
  • EDW_PMI_PMIL_PORG_LSTG
  • EDW_PMI_PMIL_PORG_LTC
  • EDW_PMI_PMIL_PWHS_LSTG
  • EDW_PMI_PMIL_PWHS_LTC
  • EDW_PMI_PRTG_PRTG_LSTG
  • EDW_PMI_PRTG_PRTG_LTC
  • EDW_PMI_QCASSAY_A_LTC
  • EDW_PMI_QCASSAY_M
  • EDW_PMI_ROUTING_A_LTC
  • EDW_PMI_ROUTING_M
  • PMI_BATCH_STATUS
  • PMI_EDW_BTCH_DTL_F
  • PMI_EDW_BTCH_DTL_FSTG
  • PMI_EDW_BTCH_GRADE_F
  • PMI_EDW_BTCH_GRADE_FSTG
  • PMI_EDW_BTCH_QC_F
  • PMI_EDW_BTCH_QC_FSTG
  • PMI_EDW_BTCH_RSRC_F
  • PMI_EDW_BTCH_RSRC_FSTG
  • PMI_EDW_MARGIN_F
  • PMI_EDW_MARGIN_FSTG
  • PMI_LOT_GENEALOGY
  • PMI_ONHAND_SALE_SUM
  • PMI_ONHAND_SALE_SUM_CUR_TEMP
  • PMI_ONHAND_SALE_SUM_TEMP
  • PMI_PERD_TRANS_SUM_TEMP
  • PMI_PROD_SUM
  • PMI_SUMMARY_LOG_TABLE