Views in Oracle Demand Planning Module



List of views in Oracle Demand Planning Module

MSD_ACTUAL_PRODUCTION_CS_V
MSD_ACTUAL_PRODUCTION_DS_V
MSD_ASCP_PLANS_HEADER_V
MSD_AUDIT_SQL_STATEMENTS_V
MSD_AUTHORIZATION_CS_V
MSD_AUTHORIZATION_DS_V
MSD_AVAIL_RESOURCE_CAP_DS_V
MSD_AVAIL_RESOURCE_CAPACITY_V
MSD_AVAIL_SUPPLIER_CAP_DS_V
MSD_AVAIL_SUPPLIER_CAPACITY_V
MSD_BACKLOG_CS_V
MSD_BACKLOG_DS_V
MSD_BOM_COMPONENTS_DS_V
MSD_BOM_COMPONENTS_V
MSD_BOOKING_DATA_CS_V
MSD_BOOKING_DATA_DS_V
MSD_BOOKING_DATA_ORIG_CS_V
MSD_BOOKING_DATA_ORIG_DS_V
MSD_BOOKING_DATA_V
MSD_CATEGORY_SETS_V
MSD_CMRO_FCST_MTLREQ_CS_V
MSD_CMRO_FCST_MTLREQ_DS_V
MSD_CMRO_FIRM_MTLREQ_CS_V
MSD_CMRO_FIRM_MTLREQ_DS_V
MSD_CMRO_PLAN_HIST_CS_V
MSD_CMRO_PLAN_HIST_DS_V
MSD_CMRO_UNPLAN_HIST_CS_V
MSD_CMRO_UNPLAN_HIST_DS_V
MSD_CONSTRAINED_FORECAST_DS_V
MSD_CONSTRAINED_FORECAST_V
MSD_CS_CLMN_DIM_DTLS_V
MSD_CS_CLMN_IDENTIFIERS_VL
MSD_CS_DATA_DS_V
MSD_CS_DATA_HEADERS_V
MSD_CS_DATA_HEADERS_V1
MSD_CS_DATA_V
MSD_CS_DATA_V1
MSD_CS_DEFINITIONS_V1
MSD_CS_DEFINITIONS_VL
MSD_CS_DEFN_COLUMN_DTLS_V
MSD_CS_DEFN_DIM_DTLS_V
MSD_CS_PLANNING_BOOKING_V
MSD_CURR_ONHAND_INVENTORY_V
MSD_CURRENCY_CONVERSIONS_V
MSD_CUST_HIST_SALES_CS_V
MSD_CUST_HIST_SALES_DS_V
MSD_CUST_ORDER_FCST_CS_V
MSD_CUST_ORDER_FCST_DS_V
MSD_CUST_SALES_FCST_CS_V
MSD_CUST_SALES_FCST_DS_V
MSD_DELETED_LEVEL_VALUES_LB_V
MSD_DELETED_LEVEL_VALUES_V
MSD_DEM_AVAIL_RESOURCE_CAP_V
MSD_DEM_AVAIL_SUPPLIER_CAP_V
MSD_DEM_BEGINING_ONHAND_V
MSD_DEM_CONSTRAINED_FORECAST_V
MSD_DEM_DEPENDENT_DEMAND_V
MSD_DEM_ITEM_COST_V
MSD_DEM_MODEL_BOM_COMPONENTS_V
MSD_DEM_NEW_ITEMS_V1
MSD_DEM_ORG_GROUPS_V
MSD_DEM_PLANNED_PRODUCTION_V
MSD_DEM_PLANNED_SHIPMENTS_V
MSD_DEM_PRICE_LISTS_V1
MSD_DEM_REQR_RESOURCE_CAP_V
MSD_DEM_REQR_SUPPLIER_CAP_V
MSD_DEM_SAFETY_STOCKS_V
MSD_DEM_SCN_ENTRIES_V
MSD_DEM_SR_CATEGORY_SETS_V
MSD_DEMAND_PLANS_V
MSD_DEMAND_PLANS_VL
MSD_DP_ASCP_SCENARIOS_V
MSD_DP_ASCP_SCN_ENTRIES_V
MSD_DP_CALENDARS_V
MSD_DP_DEFAULT_SCENARIO_V
MSD_DP_DIMENSIONS_V
MSD_DP_EVENTS_V
MSD_DP_FORMULAS_V
MSD_DP_HIERARCHIES_V
MSD_DP_ISO_ORGANIZATIONS_V
MSD_DP_PARAMETERS_CS_V
MSD_DP_PLANNING_PERCENTAGES_V
MSD_DP_PRICE_LISTS_V
MSD_DP_SCE_DEMANDPLAN_V
MSD_DP_SCE_SCENARIOS_V
MSD_DP_SCE_SCN_ENTRIES_V
MSD_DP_SCENARIO_ALL_EVENTS_V
MSD_DP_SCENARIO_EVENTS_V
MSD_DP_SCENARIOS_CS_V
MSD_DP_SCENARIOS_V
MSD_DP_SCENARIOS_VL
MSD_DP_SCN_LOV_V
MSD_DP_SCN_OUTPUT_LEVELS_V
MSD_DP_SCN_REVISIONS_LB_V
MSD_DP_SCN_REVISIONS_V
MSD_DP_SEEDED_DOC_DIMENSIONS_V
MSD_DP_SEEDED_DOCUMENTS_V
MSD_DP_USERS_V
MSD_DPT_RPR_USG_HISTORY_V
MSD_EOL_BOM_COMP_DS_V
MSD_EOL_BOM_COMP_V
MSD_EVENT_PRODUCTS_V
MSD_EVENT_PRODUCTS_V1
MSD_EVENTS_V
MSD_EVT_PRODUCT_DETAILS_V
MSD_EVT_PRODUCT_DETAILS_V1
MSD_FLD_SER_USG_HISTORY_V
MSD_FORECAST_BASIS_LIAB_CS_V
MSD_FORECAST_BASIS_LIAB_DS_V
MSD_GROSS_REQ_EXCESS_HRZN_CS_V
MSD_GROSS_REQ_EXCESS_HRZN_DS_V
MSD_GROSS_REQ_OBS_DATE_CS_V
MSD_GROSS_REQ_OBS_DATE_DS_V
MSD_HIERARCHIES_LB_V
MSD_HIERARCHIES_V
MSD_HIERARCHY_LEVELS_LB_V
MSD_HIERARCHY_LEVELS_V
MSD_INCLUDE_EOL_ITEMS_CS_V
MSD_INCLUDE_EOL_ITEMS_DS_V
MSD_INCLUDE_EOL_ITEMS_LOV_V
MSD_INPUT_SCENARIO_DS_V
MSD_INSTALL_BASE_HISTORY_V
MSD_INTRANSIT_CS_V
MSD_INTRANSIT_DS_V
MSD_ITEM_MASTER_LB_V
MSD_ITEM_MASTER_V
MSD_LB_FCST_BASIS_CS_V
MSD_LB_FCST_DEMAND_CS_V
MSD_LB_FCST_LIAB_CS_V
MSD_LB_OPEN_PO_CS_V
MSD_LB_PREV_LIAB_CS_V
MSD_LB_RECEIPT_SINCE_CS_V
MSD_LEGAL_ENTITIES_V
MSD_LEVEL_ASSOCIATIONS_V1
MSD_LEVEL_VALUES_DS_V
MSD_LEVEL_VALUES_EOL_DS_V
MSD_LEVEL_VALUES_EOL_V
MSD_LEVEL_VALUES_LB_V
MSD_LEVEL_VALUES_SOP_DS_V
MSD_LEVEL_VALUES_SOP_V
MSD_LEVEL_VALUES_V
MSD_LEVEL_VALUES_V1
MSD_LEVELS_LB_V
MSD_LEVELS_V
MSD_MFG_FCST_CS_V
MSD_MFG_FCST_DS_V
MSD_MFG_FCST_V
MSD_NO_CUTOFF_BURNOFF_CAL_CS_V
MSD_NO_CUTOFF_BURNOFF_CAL_DS_V
MSD_NPI_CANNED_PRODUCTS_V
MSD_NPI_RELATED_PROD_DETAILS_V
MSD_NPI_RELATED_PROD_DTLS_V1
MSD_NPI_RELATED_PRODUCTS_V
MSD_NPI_RELATED_PRODUCTS_V1
MSD_OBJECTS_V
MSD_ON_HAND_CS_V
MSD_ON_HAND_DS_V
MSD_ONHAND_INVENTORY_CS_V
MSD_ONHAND_INVENTORY_DS_V
MSD_ONORDER_CS_V
MSD_ONORDER_DS_V
MSD_OPEN_PO_CS_V
MSD_OPEN_PO_DS_V
MSD_OPPORTUNITY_DATA_CS_V
MSD_OPPORTUNITY_DATA_DS_V
MSD_OPPORTUNITY_DATA_V
MSD_ORDER_FORECAST_CS_V
MSD_ORDER_FORECAST_DS_V
MSD_ORG_CALENDAR_CS_V
MSD_ORG_CALENDAR_DS_V
MSD_ORGANIZATION_DEFINITIONS
MSD_PDUE_BACKLOG_CS_V
MSD_PDUE_BACKLOG_DS_V
MSD_PLAN_TYPE_VIEWS_V
MSD_PREVIOUS_LIAB_CS_V
MSD_PREVIOUS_LIAB_DS_V
MSD_PRICE_LIST_DS_V
MSD_PRICE_LIST_LB_V
MSD_PRICE_LIST_V
MSD_PRODUCT_RETURN_CS_V
MSD_PRODUCT_RETURN_DS_V
MSD_PRODUCT_RETURN_HISTORY_V
MSD_PRODUCTION_PLAN_CS_V
MSD_PRODUCTION_PLAN_DS_V
MSD_PROMOTIONAL_DATA_CS_V
MSD_PROMOTIONAL_DATA_DS_V
MSD_RECEIPT_SINCE_LIAB_CS_V
MSD_RECEIPT_SINCE_LIAB_DS_V
MSD_RECEIPTS_CS_V
MSD_RECEIPTS_DS_V
MSD_SAFETY_STOCKS_DS_V
MSD_SAFETY_STOCKS_V
MSD_SALES_FCST_BESTCASE_CS_V
MSD_SALES_FCST_BESTCASE_DS_V
MSD_SALES_FCST_PIPELINE_CS_V
MSD_SALES_FCST_PIPELINE_DS_V
MSD_SALES_FCST_REALISTIC_CS_V
MSD_SALES_FCST_REALISTIC_DS_V
MSD_SALES_FCST_WGTPLINE_CS_V
MSD_SALES_FCST_WGTPLINE_DS_V
MSD_SALES_FCST_WORSTCASE_CS_V
MSD_SALES_FCST_WORSTCASE_DS_V
MSD_SCN_ENTRY_COMMENTS_V
MSD_SERVICE_PART_RETURN_CS_V
MSD_SERVICE_PART_RETURN_DS_V
MSD_SERVICE_PART_USAGE_CS_V
MSD_SERVICE_PART_USAGE_DS_V
MSD_SHIPMENT_DATA_CS_V
MSD_SHIPMENT_DATA_DS_V
MSD_SHIPMENT_DATA_ORIG_CS_V
MSD_SHIPMENT_DATA_ORIG_DS_V
MSD_SHIPMENT_DATA_V
MSD_SHIPMENT_HISTORY_V
MSD_SIM_END_ITEM_DEMAND_CS_V
MSD_SIM_END_ITEM_DEMAND_DS_V
MSD_SOP_BOM_COMP_DS_V
MSD_SOP_BOM_COMP_V
MSD_SR_ACTUAL_PRODUCTION_V
MSD_SR_AREA_ALL_V
MSD_SR_AUTH_ALL_LB_V
MSD_SR_BACKLOG_V
MSD_SR_BG_ALL_V
MSD_SR_BOOKING_DATA_V
MSD_SR_CAT_ALL_LB_V
MSD_SR_CAT_ALL_V
MSD_SR_CLASS_ALL_V
MSD_SR_CMRO_FCST_MTLREQ_V
MSD_SR_CMRO_FIRM_MTLREQ_V
MSD_SR_CMRO_PLAN_HIST_V
MSD_SR_CMRO_UNPLAN_HIST_V
MSD_SR_COUNTRY_AREA_V
MSD_SR_CURRENCY_CONVERSIONS_V
MSD_SR_CUS_CLASS_V
MSD_SR_CUS_GROUP_V
MSD_SR_CUSTZONE_ZONE_V
MSD_SR_DC_ALL_V
MSD_SR_FISCAL_TIME_V
MSD_SR_GROUP_ALL_V
MSD_SR_GRP1_GRP2_V
MSD_SR_GRP2_GRP3_V
MSD_SR_GRP3_GRP4_V
MSD_SR_GRP4_ALL_V
MSD_SR_IT_ALL_V
MSD_SR_ITEM_LIST_PRICE_V
MSD_SR_ITEM_SUPERSESSION_V
MSD_SR_LE_ALL_V
MSD_SR_LE_BG_V
MSD_SR_LOC_CUS_V
MSD_SR_LOC_CUSTZONE_V
MSD_SR_LOC_ORG_V
MSD_SR_LOC_REG_V
MSD_SR_LOC_SUP_V
MSD_SR_MFG_FCST_V
MSD_SR_MFG_TIME_V
MSD_SR_MGR1_MGR2_V
MSD_SR_MGR2_MGR3_V
MSD_SR_MGR3_MGR4_V
MSD_SR_MGR4_ALL_V
MSD_SR_ONHAND_INVENTORY_V
MSD_SR_ORG_ALL_LB_V
MSD_SR_ORG_LE_V
MSD_SR_ORG_OU_V
MSD_SR_OU_BG_V
MSD_SR_OU_LE_V
MSD_SR_PDUE_BACKLOG_V
MSD_SR_PF_ALL_V
MSD_SR_PRD_CAT_LB_V
MSD_SR_PRD_CAT_V
MSD_SR_PRD_IT_V
MSD_SR_PRD_ORG_V
MSD_SR_PRD_PF_V
MSD_SR_PRICE_LIST_V
MSD_SR_PRODUCT_RETURN_V
MSD_SR_PRODUCTION_PLAN_V
MSD_SR_PROMOTIONAL_DATA_V
MSD_SR_REG_COUNTRY_V
MSD_SR_REP_GRP1_V
MSD_SR_REP_MGR1_V
MSD_SR_RMA_TYPE_V
MSD_SR_SALES_FCST_V
MSD_SR_SC_ALL_V
MSD_SR_SERVICE_PART_RETURN_V
MSD_SR_SERVICE_PART_USAGE_V
MSD_SR_SHIPMENT_DATA_V
MSD_SR_SUP_ALL_LB_V
MSD_SR_SUP_ALL_V
MSD_SR_TIME_LB_V
MSD_SR_TOTAL_BACKLOG_V
MSD_SR_UOM_CONVERSIONS_V
MSD_SR_ZONE_ALL_V
MSD_SRP_RETURN_HISTORY_V
MSD_ST_CS_DATA_V
MSD_SUPPLY_COMMIT_CS_V
MSD_SUPPLY_COMMIT_DS_V
MSD_SUPPLY_PLANS_DS_V
MSD_SUPPLY_PLANS_V
MSD_TIME_LB_V
MSD_TIME_V
MSD_TOTAL_BACKLOG_CS_V
MSD_TOTAL_BACKLOG_DS_V
MSD_TOTAL_SUPPLY_CS_V
MSD_TOTAL_SUPPLY_DS_V
MSD_UOM_CONVERSIONS_LB_V
MSD_UOM_CONVERSIONS_V
MSD_WORK_IN_PROCESS_DS_V
MSD_WORK_IN_PROCESS_V

1 response to Views in Oracle Demand Planning Module

  1. Hello,

    Can I use these views to fetch data directly.

    Per example can I use MSD_SR_PRODUCT_RETURN_V to fetch returns data and load directly in Demantra staging using ETL?

    Thanks
    Lakshmi

Leave a reply

Your email address will not be published. Required fields are marked *