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 |
Lakshmi said on April 2, 2014
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