MSC Views (182)

MSC - Advanced Supply Chain Planning — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

ViewDescription
MSC_ACTIONS_TREE_V This view shows all the exceptions in the tree
MSC_ACTION_ORDERS_TREE_V Ths view shows the recommendations in the tree
MSC_ACTION_SUMMARY_V This view show the exception group counts in the tree
MSC_ALLOCATION_ASSIGNMENTS_V This view shows the allocation assignments
MSC_ALTERNATE_RESOURCES_V
MSC_ANSWERS_V
MSC_APPS_INSTANCES_V
MSC_AVAILABLE_ORGS_V
MSC_AVAIL_RESOURCE_DETAIL_V
MSC_AVAIL_RESOURCE_SUMMARY_V
MSC_BILL_OF_RESOURCES_V
MSC_BOD_SOURCING_RULES_V
MSC_BOD_TASK_SR_LEVELS_V
MSC_CATEGORIES_TREE_V This view shows all the categories in the tree
MSC_COMPONENTS_SC_V This view shows all the components in the tree
MSC_COMPONENTS_TREE_V
MSC_CONSTRAINED_FORECAST_V
MSC_CO_PRODUCTS_V Thus view shows all the co-products
MSC_CRITICAL_PATHS_V
MSC_CUST_BUCKET_V
MSC_CUST_SUP_ORG_V
MSC_DEMANDS_MV_V
MSC_DEMAND_CLASSES_V This view picks up all the demand classes
MSC_DEMAND_PEGGING_V Demand pegging
MSC_EXCEPTION_DETAILS_V this view picks up all the valid exception details
MSC_EXCEPTION_LOOKUP_V
MSC_EXCEPTION_SUMMARY_V
MSC_EXCEPTION_THRESHOLDS_V
MSC_EXC_DETAIL_ALL_V
MSC_EXC_DETAIL_ITEM_V
MSC_EXC_DETAIL_RESOURCE_V
MSC_FLP_DEMAND_SUPPLY_ATP_V
MSC_FLP_DEMAND_SUPPLY_V
MSC_FLP_DEMAND_SUPPLY_V2
MSC_FLP_END_DEMAND2_V
MSC_FLP_END_DEMAND_V
MSC_FLP_ONHAND_V
MSC_FLP_OP_ATP_V
MSC_FLP_OP_V
MSC_FLP_RES_ATP_V
MSC_FLP_RES_V
MSC_FLP_SUPPLY_ATP_V View of supply information
MSC_FLP_SUPPLY_DEMAND_ATP_V
MSC_FLP_SUPPLY_DEMAND_V
MSC_FLP_SUPPLY_DEMAND_V2
MSC_FLP_SUPPLY_V View of supply information
MSC_FORECAST_UPDATES_V this view picks up all the forecast updates
MSC_INSTANCE_ORGS_V
MSC_ITEMS_TREE_V
MSC_ITEM_CROSS_REFS_V
MSC_ITEM_EXCEPTION_V This view picks up all the item exceptions
MSC_ITEM_EXCEPTION_V1 This view picks all the item exceptions at the plan level
MSC_ITEM_EXCEPTION_V2 this view picks the item exceptions at the plan level
MSC_ITEM_LOWEST_SR_LEVEL_V Lowest sourcing level of an inventory org item
MSC_ITEM_SOURCING_LEVELS_V this view picks up all the sources at various levels for an item
MSC_ITEM_SOURCING_V
MSC_ITEM_SR_LEVELS_V Inventory items sources view
MSC_ITEM_SUPPLIER_V
MSC_ITEM_TASK_SR_LEVELS_V
MSC_ITEM_UOMS_VIEW
MSC_LATE_ORDERS_MV_V
MSC_LINE_ITEMS_LOV_V
MSC_LOCATIONS_V
MSC_MONTHLY_SUPDEM_SUM_V
MSC_MONTHLY_SUPPLY_DEMAND_V
MSC_NETTED_SUPPLY_DEMAND_V
MSC_NET_AGGREGATE_V
MSC_NET_CONSTRAINTS_V
MSC_NET_DEMAND_SCHD_V
MSC_NET_EXCP_CRITERIA_V
MSC_NET_EXC_DETAIL_V
MSC_NET_EXC_GROUP_V
MSC_NET_EXC_TYPE_V
MSC_NET_FILTER_CRITERIA_V
MSC_NET_GOAL_V
MSC_NET_HZ_GRAPH_V
MSC_NET_OPTIMIZE_V
MSC_NET_OPTION_V
MSC_NET_ORG_V
MSC_NET_PLANS_V to display the plan LOV in the from plan of Plan Comparison Reports
MSC_NET_PLANS_V2 To display the plan LOV in the to plan of Plan Comparison Reports
MSC_NET_SUPPLY_SCHD_V
MSC_NET_VERTICAL_GRAPH_V
MSC_OPERATION_NETWORKS_V this view shows all the operations in the network routing
MSC_ORDERS_V This view shjows all the supplies,demands anf sales orders
MSC_ORGS_TREE_V
MSC_ORG_SEC_RESP_V
MSC_PARAMETERS_V
MSC_PDR_ITEM_DETAILS_V
MSC_PDR_LATE_ORDER_EXC_V
MSC_PDR_MAT_RES_EXC_V
MSC_PDR_PLAN_DETAILS_V
MSC_PDR_PLAN_DETAILS_V1
MSC_PDR_RESOURCE_DETAILS_V
MSC_PDR_VERT_LIST_V
MSC_PLANNED_RESOURCES_V This view shows all the resources used in a plan
MSC_PLANS_TREE_V
MSC_PLAN_ORGANIZATIONS_V MPS/MRP/DRP plan organizations view
MSC_PLAN_ORGS_V
MSC_PLAN_PARAMETERS_V
MSC_PLAN_SCHEDULES_V Supply/Demand Schedule information for planner.
MSC_PLAN_SCHED_V
MSC_PO_REQUISITIONS_V This view contains all the information necessary to create approved or unapproved requisitions in Oracle Purchasing. This view is used in XM
MSC_PO_RESCHEDULE_DETAILS_V This view contains the line information of a rescheduled purchase order. This view is used in XML-outbound.
MSC_PO_RESCHEDULE_HEADER_V This view contains the header information of a rescheduled purchase order. This view is used in XML-outbound
MSC_PROCESS_EFFECTIVITY_V
MSC_PRODUCT_FAMILIES_TREE_V
MSC_PROJECTS_TREE_V This view shows all the projects in a plan in the tree
MSC_PROJECT_ITEMS_TREE_V this view shows all the project items in the tree
MSC_PUBLISH_ITEMS_LOV_V
MSC_QUESTIONS_VL
MSC_RELATED_EXC_DETAILS_V
MSC_RESOURCES_TREE_V This view shows all the resources in the tree
MSC_RESOURCE_ITEMS_TREE_V
MSC_RESOURCE_REQUIREMENTS_V this view shows all the resource requirements
MSC_ROUTING_OPERATIONS_V This view shows all the operations in a routing
MSC_SAFETY_STOCKS_V
MSC_SCATP_ITEM_SR_LEVELS_V
MSC_SCATP_SOURCES_V
MSC_SCH_RULE_CRITERIA_V
MSC_SCH_RULE_NAMES_V
MSC_SC_BILL_BOM_V
MSC_SC_BILL_MAKE_AT_V
MSC_SC_BILL_SF_V Supply chain bill source from view
MSC_SC_BILL_V
MSC_SC_BILL_WU_V Supply chain bill where used view
MSC_SEARCH_ACTIONS_V this view shows all the search criteria for exceptions
MSC_SEARCH_ITEMS_V this shows all the search criteria for items
MSC_SEARCH_ORGS_V this view shows all the search criteria for organizations
MSC_SEARCH_PROJECTS_V this view shows all the search criteria for projects
MSC_SEARCH_RESOURCES_V this view shows all the search criteria for resources
MSC_SEARCH_SUPPLIERS_V this view shows the search criteria for suppliers
MSC_SECURITY_RULES_V
MSC_SELECTED_ORGS_V
MSC_SOURCES_V Inventory item source view
MSC_SR_ASSIGNMENTS_V
MSC_SR_RECEIPT_ORG_V
MSC_SR_SOURCE_ORG_V Sourcing rule source organization view
MSC_SR_VIEW_CON_V
MSC_SR_VIEW_EXP_V
MSC_SR_VIEW_MAKE_AT_V
MSC_SR_VIEW_REC_V
MSC_SR_VIEW_V
MSC_SUBSTITUTE_COMPONENTS_V Substitute component view
MSC_SUB_INVENTORIES_V
MSC_SUPPLIERS_LOV_V
MSC_SUPPLIERS_TREE_V
MSC_SUPPLIER_CAPACITY_V This view shows the capacities for all the suppliers
MSC_SUPPLIER_FLEX_FENCES_V
MSC_SUPPLIER_LT_OUTCOMES_V
MSC_SUPPLIES_OUTBOUND_V This view lists all the supplies for the plan. This view is used in XML-outbound
MSC_SUPPLY_PEGGING_V Supply pegging
MSC_SUP_DEM_ENTRIES_UI_V
MSC_SUP_DEM_ENTRIES_V
MSC_SUP_DEM_ENTRIES_VMI_V
MSC_SUP_DEM_ENT_CUSTOM_EX_V
MSC_SUP_DEM_HISTORY_V
MSC_SUP_DEM_HZ_UI_V
MSC_SUP_DEM_SECURITY_V
MSC_SUP_DEM_TRANSACTIONS_V
MSC_SUP_DEM_UPDATE_SECURITY_V
MSC_SYSTEM_ITEMS_SC_V This view shows all the items
MSC_TREE_SELECTION_V
MSC_UNDO_DETAILS_V this view shows all the changes made to the plan output
MSC_UNDO_SUMMARY_V this view shows the summary of all the changes made to the plan output
MSC_UOM_CONVERSIONS_VIEW
MSC_VERTICAL_PLAN_V this view shows the vertical plan
MSC_VMI_ITEM_V
MSC_WIP_JOB_COMPONENTS_V This view contains requests to add/delete/modify material for existing discrete jobs or repetitive schedules. This view is used in XML outb
MSC_WIP_JOB_OPERATIONS_V This view contains the information about operations for existing discrete job or repetitive schedules. This view is used in XML outbound
MSC_WIP_JOB_RESOURCES_V This view contains requests to add/delete/modify resource requirements for existing discrete jobs or repetitive schedules. This view is used
MSC_WIP_JOB_SCHEDULE_V This view contains request to create or modify discrete jobs or repetitive schedules. This view is used in XML-outbound
MSC_X_COMPANY_ORG_LOV_V
MSC_X_COMPANY_SITES_LOV_V
MSC_X_CUSTOMER_LOV_V
MSC_X_ITEMS_LOV_V
MSC_X_ITEM_EXCEPTIONS_V
MSC_X_ORGS_LOV_V
MSC_X_SUPPLIER_LOV_V
MSC_X_SUPPLY_DEMAND_V
OLD_ITEM_SOURCING_LEVELS_V
OLD_SC_BILL_SF_V