You are browsing the archive for SCP.

Views in Master Scheduling MRP Module

List of views in Oracle Master Scheduling MRP Module

MRP_AP_APPS_INSTANCES
MRP_ASSIGNMENT_SETS_DFV
MRP_ATP_BACKLOG_TEMP_V
MRP_ATP_BASE_V
MRP_ATP_ITEMS_ALL_V
MRP_ATP_ITEMS_RESOURCE_V
MRP_ATP_PERIOD_V
MRP_ATP_PROPERTIES_V
MRP_ATP_SCHEDULE_TEMP_V
MRP_ATP_SD_TEMP_V
MRP_ATP_SOURCES_V
MRP_ATP_V
MRP_BIS_FORECAST_SET_V
MRP_BIS_FORECAST_TREND_V
MRP_BIS_FORECAST_V
MRP_BIS_FORECAST_WB_V
MRP_BIS_FORECASTS_LOV_V
MRP_BIS_LATE_ORDERS_V
MRP_BIS_ORDERS_V
MRP_BIS_ORG_PROFIT_V
MRP_BIS_PLAN_PROD_V
MRP_BIS_PLAN_PROFIT_V
MRP_BIS_PLANS_LOV_V
MRP_BOD_TASK_SR_LEVELS_V
MRP_BOM_PLAN_NAME_LOV_V
MRP_CL_REFRESH_COLL_SNAPSHOT_V
MRP_COMPONENTS_SC_V
MRP_CRP_STATUS_V
MRP_CUST_SUP_ORG_V
MRP_CUSTOMER_SITES_V
MRP_DAILY_DEMAND_VIEW
MRP_DAILY_SCHEDULES_V
MRP_DAILY_SUPPLY_VIEW
MRP_DEFAULT_ABC_ASSIGN_VIEW
MRP_DEMAND_OM_RESERVATIONS_V
MRP_DESIGNATORS_DFV
MRP_DESIGNATORS_VIEW
MRP_END_ASSEMBLIES_V
MRP_EXCEPTION_DETAILS_V
MRP_EXCEPTION_SUMMARY_V
MRP_FLP_DEMAND_SUPPLY_V
MRP_FLP_DEMAND_SUPPLY_V2
MRP_FLP_END_DEMAND_V
MRP_FLP_END_DEMAND2_V
MRP_FLP_ONHAND_V
MRP_FLP_SUPPLY_DEMAND_V
MRP_FLP_SUPPLY_DEMAND_V2
MRP_FLP_SUPPLY_V
MRP_FORECAST_DATES_DFV
MRP_FORECAST_DATES_V
MRP_FORECAST_DATES1_DFV
MRP_FORECAST_DESIGNATORS_DFV
MRP_FORECAST_DESIGNATORS_V
MRP_FORECAST_DESIGNATORS1_DFV
MRP_FORECAST_ITEMS_DFV
MRP_FORECAST_ITEMS_V
MRP_FORECAST_UPDATES_V
MRP_FORECASTS_LOV_V
MRP_FORM_QUERY_DFV
MRP_GRP_DIST_ITEM_ATPS_VIEW
MRP_INTER_LOCATIONS_V
MRP_ITEM_BORROW_PAYBACK_QTY_V
MRP_ITEM_EXCEPTION_V
MRP_ITEM_LOT_QUANTITIES_DET_V
MRP_ITEM_LOT_QUANTITIES_V
MRP_ITEM_LOWEST_SR_LEVEL_V
MRP_ITEM_SOURCING_LEVELS_V
MRP_ITEM_SOURCING_V
MRP_ITEM_SR_LEVELS_V
MRP_ITEM_TASK_SR_LEVELS_V
MRP_KANBAN_ACTUAL_PROD_V
MRP_KANBAN_COMPARISON_V
MRP_KANBAN_DEMAND_V
MRP_KANBAN_DETAILS_V
MRP_KANBAN_PLANS_DFV
MRP_KANBAN_PLANS_V
MRP_LAST_PLAN_ORGS_V
MRP_LINE_SCH_AVAIL_V
MRP_LINE_SCHEDULES_V
MRP_LOAD_PARAMETERS_V
MRP_ONHAND_QUANTITIES_SC_V
MRP_ORDERS_SC_V
MRP_ORDERS_V
MRP_ORG_DEFINITIONS_V
MRP_ORG_QUANTITY_DET_V
MRP_ORG_QUANTITY_V
MRP_ORGANIZATIONS_V
MRP_PARAMETERS_V
MRP_PERIODIC_DEMAND_VIEW
MRP_PERIODIC_SUPPLY_VIEW
MRP_PF_ATP_ITEMS_ALL_V
MRP_PF_ATP_V
MRP_PLAN_JOBS_V
MRP_PLAN_ORGANIZATIONS_V
MRP_PLAN_ORGS_V
MRP_PLAN_PARAMETERS_V
MRP_PLAN_SCHED_V
MRP_PLAN_SCHEDULES_V
MRP_PLANNER_TASKS_V
MRP_PLANNING_EXCEPTION_SET_DFV
MRP_PLANNING_EXCEPTION_SETS_V
MRP_PLANS_SC_V
MRP_PO_FLEX_FENCES_V
MRP_PO_SUPPLIER_CAPACITY_V
MRP_PO_SUPPLIERS_V
MRP_PO_SUPPLY_VIEW
MRP_PROJECT_V
MRP_SC_BILL_BOM_V
MRP_SC_BILL_MAKE_AT_V
MRP_SC_BILL_SF_V
MRP_SC_BILL_V
MRP_SC_BILL_WU_V
MRP_SCATP_ITEM_SR_LEVELS_V
MRP_SCATP_SOURCES_V
MRP_SCATP_SUPPLY_SOURCES_V
MRP_SCH_RULE_CRITERIA_V
MRP_SCH_RULE_NAMES_V
MRP_SCHEDULE_CONSUMPTIONS_V
MRP_SCHEDULE_DATES_DFV
MRP_SCHEDULE_DATES_V
MRP_SCHEDULE_DATES1_DFV
MRP_SCHEDULE_DESIGNATORS_DFV
MRP_SCHEDULE_DESIGNATORS_V
MRP_SCHEDULE_ITEM_DATES_V
MRP_SCHEDULE_ITEMS_DFV
MRP_SCHEDULE_ITEMS_V
MRP_SCHEDULING_RULES_DFV
MRP_SCHEDULING_RULES_V
MRP_SNAPSHOT_TASKS_V
MRP_SO_UPDATES_SUMMARY_V
MRP_SOURCES_V
MRP_SOURCING_RULES_DFV
MRP_SR_ASSIGNMENTS_DFV
MRP_SR_ASSIGNMENTS_V
MRP_SR_RECEIPT_ORG_DFV
MRP_SR_RECEIPT_ORG_V
MRP_SR_SOURCE_ORG_DFV
MRP_SR_SOURCE_ORG_V
MRP_SR_VIEW_CON_V
MRP_SR_VIEW_EXP_V
MRP_SR_VIEW_MAKE_AT_V
MRP_SR_VIEW_REC_V
MRP_SR_VIEW_V
MRP_SRS_FCST_LOAD_SOURCE_V
MRP_SRS_ORG_SELECT_PLAN_V
MRP_SRS_ORG_SELECT_SCHED_V
MRP_SRS_SCHED_LOAD_SOURCE_V
MRP_SUB_INVENTORIES_V
MRP_SYSTEM_ITEMS_SC_V
MRP_TASK_V
MRP_TEMP_QUANTITY_V
MRP_UNIT_BORROW_QTY_V
MRP_UNIT_PAYBACK_QTY_V
MRP_UNSCHEDULED_ORDERS_V
MRP_USING_ASSEMBLY_SC_V
MRP_WEB_ENTERPRISE_V
MRP_WEB_HORIZONTAL_PLAN_V
MRP_WEB_PLAN_ITEMS_V
MRP_WEB_PLANNED_SUPPLY_V
MRP_WEEKLY_DEMAND_VIEW
MRP_WEEKLY_SUPPLY_VIEW
MRP_WIP_JOBS_VIEW
MRP_WIP_REP_SCHD_VIEW
MRP_WORKBENCH_MESSAGES_SC_V
MRP_WORKBENCH_MESSAGES_V
MRP_WORKBENCH_QUERY_DFV
MRPBV_BILL_OF_DISTRIBUTIONS
MRPBV_BILL_OF_RESOURCE_ITEMS
MRPBV_BILL_OF_RESOURCE_REQS
MRPBV_BILL_OF_RESOURCES
MRPBV_DEMAND_CLASSES
MRPBV_DRP_PLANS
MRPBV_FORECAST_CONSUMPTIONS
MRPBV_FORECAST_ENTRIES
MRPBV_FORECAST_ITEMS
MRPBV_FORECAST_RULES
MRPBV_FORECAST_SETS
MRPBV_FORECASTS
MRPBV_MASTER_DEMAND_SCHEDS
MRPBV_MASTER_PROD_SCHEDS
MRPBV_MDS_CONSUMPTIONS
MRPBV_MDS_ENTRIES
MRPBV_MDS_ITEMS
MRPBV_MFG_DIST_PLANS
MRPBV_MPS_CONSUMPTIONS
MRPBV_MPS_ENTRIES
MRPBV_MPS_ITEMS
MRPBV_MPS_PLANS
MRPBV_MRP_PLANS
MRPBV_PLAN_BILL_OF_MATERIALS
MRPBV_PLAN_BOM_COMPONENTS
MRPBV_PLAN_DEMANDS
MRPBV_PLAN_DEPT_RESOURCES
MRPBV_PLAN_EXCEPTION_DETAILS
MRPBV_PLAN_EXCEPTION_SETS
MRPBV_PLAN_INVENTORY_LOTS
MRPBV_PLAN_ITEM_CAPACITIES
MRPBV_PLAN_ITEM_EXCEPTIONS
MRPBV_PLAN_ITEM_FLEX_FENCES
MRPBV_PLAN_ITEM_SOURCES
MRPBV_PLAN_ITEM_SUPPLIERS
MRPBV_PLAN_MFG_LINES
MRPBV_PLAN_OPERATION_RESOURCES
MRPBV_PLAN_OPERATIONS
MRPBV_PLAN_ORG_ITEMS
MRPBV_PLAN_ORGANIZATIONS
MRPBV_PLAN_PEGS
MRPBV_PLAN_RESOURCE_CAPACITIES
MRPBV_PLAN_RESOURCE_LOADS
MRPBV_PLAN_ROUTINGS
MRPBV_PLAN_SAFETY_STOCKS
MRPBV_PLAN_SCHEDULES
MRPBV_PLAN_SIMULATION_SETS
MRPBV_PLAN_SUBINVENTORIES
MRPBV_PLAN_SUPPLIES
MRPBV_PLANNERS
MRPBV_REPLENISHMENT_DSTNS
MRPBV_REPLENISHMENT_SOURCES
MRPBV_SOURCING_RULES
MRPBV_SR_ASSIGNMENT_SETS
MRPBV_SR_BOD_ASSIGNMENTS
MRPFV_BILL_OF_DISTRIBUTIONS
MRPFV_BILL_OF_RESOURCE_ITEMS
MRPFV_BILL_OF_RESOURCE_REQS
MRPFV_BILL_OF_RESOURCES
MRPFV_DEMAND_CLASSES
MRPFV_DRP_PLANS
MRPFV_FORECAST_CONSUMPTIONS
MRPFV_FORECAST_ENTRIES
MRPFV_FORECAST_ITEMS
MRPFV_FORECAST_RULES
MRPFV_FORECAST_SETS
MRPFV_FORECASTS
MRPFV_MASTER_DEMAND_SCHEDS
MRPFV_MASTER_PROD_SCHEDS
MRPFV_MDS_CONSUMPTIONS
MRPFV_MDS_ENTRIES
MRPFV_MDS_ITEMS
MRPFV_MFG_DIST_PLANS
MRPFV_MPS_CONSUMPTIONS
MRPFV_MPS_ENTRIES
MRPFV_MPS_ITEMS
MRPFV_MPS_PLANS
MRPFV_MRP_PLANS
MRPFV_PLAN_BILL_OF_MATERIALS
MRPFV_PLAN_BOM_COMPONENTS
MRPFV_PLAN_DEMANDS
MRPFV_PLAN_DEPT_RESOURCES
MRPFV_PLAN_EXCEPTION_DETAILS
MRPFV_PLAN_EXCEPTION_SETS
MRPFV_PLAN_INVENTORY_LOTS
MRPFV_PLAN_ITEM_CAPACITIES
MRPFV_PLAN_ITEM_EXCEPTIONS
MRPFV_PLAN_ITEM_FLEX_FENCES
MRPFV_PLAN_ITEM_SOURCES
MRPFV_PLAN_ITEM_SUPPLIERS
MRPFV_PLAN_MFG_LINES
MRPFV_PLAN_OPERATION_RESOURCES
MRPFV_PLAN_OPERATIONS
MRPFV_PLAN_ORG_ITEMS
MRPFV_PLAN_ORGANIZATIONS
MRPFV_PLAN_PEGS
MRPFV_PLAN_RESOURCE_CAPACITIES
MRPFV_PLAN_RESOURCE_LOADS
MRPFV_PLAN_ROUTINGS
MRPFV_PLAN_SAFETY_STOCKS
MRPFV_PLAN_SCHEDULES
MRPFV_PLAN_SIMULATION_SETS
MRPFV_PLAN_SUBINVENTORIES
MRPFV_PLAN_SUPPLIES
MRPFV_PLANNERS
MRPFV_REPLENISHMENT_DSTNS
MRPFV_REPLENISHMENT_SOURCES
MRPFV_SOURCING_RULES
MRPFV_SR_ASSIGNMENT_SETS
MRPFV_SR_BOD_ASSIGNMENTS

Master Scheduling Descriptive Flex Fields

Oracle Master Scheduling/MRP DFF list

DFF View DFF CODE NAME DFF name
MRP_FORM_QUERY_DFV Bucketed Schedule inquiry Bucketed Schedule Inquiry
MRP_FORECAST_DATES1_DFV DDF_MRPFFDIF Comment
MRP_FORECAST_DESIGNATORS_DFV MRPFFCFN1 MRPFFCFN1
MRP_FORECAST_DESIGNATORS1_DFV MRPFFCFN2 MRP_FORECAST_DESIGNATORS
MRP_SCHEDULE_DATES1_DFV MRPFSDMS_DDF MRPFSDMS_DDF
MRP_ASSIGNMENT_SETS_DFV MRP_ASSIGNMENT_SETS MRP_ASSIGNMENT_SETS
MRP_DESIGNATORS_DFV MRP_DESIGNATORS MRP_DESIGNATORS
MRP_FORECAST_DATES_DFV MRP_FORECAST_DATES MRP_FORECAST_DATES
MRP_FORECAST_ITEMS_DFV MRP_FORECAST_ITEMS MRP_FORECAST_ITEMS
MRP_WORKBENCH_QUERY_DFV MRP_IMPLEMENT_PLANNED_ORDERS MRP_IMPLEMENT_PLANNED_ORDERS
MRP_KANBAN_PLANS_DFV MRP_KANBAN_PLANS MRP_KANBAN_PLANS
MRP_PLANNING_EXCEPTION_SET_DFV MRP_PLANNING_EXCEPTION_SETS MRP_PLANNING_EXCEPTION_SETS
MRP_SCHEDULE_DATES_DFV MRP_SCHEDULE_DATES MRP_SCHEDULE_DATES
MRP_SCHEDULE_DESIGNATORS_DFV MRP_SCHEDULE_DESIGNATORS MRP_SCHEDULE_DESIGNATORS
MRP_SCHEDULE_ITEMS_DFV MRP_SCHEDULE_ITEMS MRP_SCHEDULE_ITEMS
MRP_SOURCING_RULES_DFV MRP_SOURCING_RULES MRP_SOURCING_RULES
MRP_SR_ASSIGNMENTS_DFV MRP_SR_ASSIGNMENTS MRP_SR_ASSIGNMENTS
MRP_SR_RECEIPT_ORG_DFV MRP_SR_RECEIPT_ORG MRP_SR_RECEIPT_ORG
MRP_SR_SOURCE_ORG_DFV MRP_SR_SOURCE_ORG MRP_SR_SOURCE_ORG
RHX_DP_DATA_ELEMENTS_DFV RHX_DP_DATA_ELEMENTS RHX_DP_DATA_ELEMENTS
RHX_DP_DATA_LEVELS_DFV RHX_DP_DATA_LEVELS RHX_DP_DATA_LEVELS
RHX_DP_DEMAND_PLANS_DFV RHX_DP_DEMAND_PLANS RHX_DP_DEMAND_PLANS
RHX_DP_HIERARCHIES_DFV RHX_DP_HIERARCHIES RHX_DP_HIERARCHIES
RHX_DP_HIERARCHY_LEVELS_DFV RHX_DP_HIERARCHY_LEVELS RHX_DP_HIERARCHY_LEVELS
RHX_DP_LEVELS_DFV RHX_DP_LEVELS RHX_DP_LEVELS
MRP_SCHEDULING_RULES_DFV Scheduling Rules Scheduling Rules

MRP/MPS Concurrent Programs

Oracle MRP/MPS Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
MRPRPRSC Order Reschedule Report
MRPRPPLO Planned Order Report
MRCPRG Purge Designator
MRRSCD Master Schedule Detail Report
MRPRPSST Master Schedule Status Report
MRRDPR Planning Detail Report
MRCEXP Exploder
MRCPLN Planner
MRCSNP Snapshot
MRCSAL Master Schedule Autoload
MRPRPLOR Late Order Report
MRCAUD Audit Information Report
MRRGRF Demand vs. Replenishment Graphical Report
MRCRLF Planning Manager
MRRFCS Forecast Detail Report
MRCFAL Item Forecast Autoload
MRPRUSUR Planning Parameters Report
MRPRPPIT Financial Analysis Report
MRCPLW Planner Worker
MRCFIM Forecast Interface Load
MRCEAP Calculate End Assemblies
MRCSNW MPS/MRP Snapshot Worker
MRCSCW Planning Manager Worker
MRRSCC Master Schedule Comparison Report
MRRFCC Forecast Comparison Report
MRCSOW Sales Order Consumption Worker
MRCMDW MDS Relief Worker
MRCMPW MPS Relief Worker
MRCSLW Master Schedule Interface Load
MRCFLW Forecast Load Worker
MRPRPPES Planning Exception Sets Report
MRCSCW1 Planning Manager Worker (once-a-day tasks)
MRRGRF2 Current Projected On Hand vs. Projected Available Graphical Report
MRCFCC Consume Forecast Set
MRPSPMRP Maintain Repetitive Planning Periods
MRCNEW Memory-based Planner
MRCNSP Memory-based Snapshot
MRCSDW Snapshot Delete Worker
MRCPDW Planner Delete Worker
MRCMON Snapshot Monitor
MRCSLD Loader Worker
MRCSAL1 Load/Copy/Merge MDS
MRCFAL1 Copy/Merge Forecast
MRPSLPPR Launch Planning Processes
MRCSAL2 Copy/Merge MPS
MRCSAL3 Load MPS
INCFIF Generate Forecast
MRPSLPPR1 Launch MPS Planning Processes
MRCNSW Memory-based Snapshot Worker
MRCNCP Net Change Simulation Planner
MRPAUREL Auto-release Planned Orders
MRRDPS Supply Chain Planning Detail Report
MRPRPLOS Supply Chain Late Order Report
MRPRPPLS Supply Chain Planned Order Report
MRPRPRSS Supply Chain Order Reschedule Report
MRRGS1 Supply Chain Demand vs. Replenishment Graphical Report
MRRGS2 Supply Chain Current Projected On Hand vs. Projected Available Graphical Report
MRPRPSSS Supply Chain Schedule Status Report
MRPRPPIS Supply Chain Financial Analysis Report
MRPSLPPS1 Launch MRP Supply Chain Planning Processes
MRPSLPPS2 Launch MPS Supply Chain Planning Processes
MRPSLPPS3 Launch DRP Supply Chain Planning Processes
MRCIDX Reset Indexes after Direct SQL load
MRCCPP Copy MRP Plan
MRCCPP1 Copy Supply Chain MRP Plan
MRCCPP2 Copy MPS Plan
MRCCPP3 Copy Supply Chain MPS Plan
MRCCPP4 Copy Supply Chain DRP Plan
MRPRPROP Reorder Point Report
MRPKQCAL Kanban Planner
MRCOLP Online Planner
MRCODW Online Planner Delete Worker
MRP_I2_LOAD_USEUP_ORACLE Load use-up Information to Oracle
MRPI2CLEARRL Clear RhythmLink
MRPI2STARTRL Start RhythmLink
MRPI2STOPRL Stop RhythmLink
MRPI2STARTFP Start Factory Planner
MRPI2CLEARFP Clear Factory Planner
MRPI2STOPFP Stop Factory Planner
MRPI2STOPLISTENER Stop Oracle Listener
MRPI2_LOAD_TO_RHYTHM_SO Load Data to RHYTHM Advanced Scheduler
MRPI2_LOAD_PO_ORACLE Load Procurement to Oracle
MRPI2_LOAD_WO_ORACLE Load Production to Oracle
MRP_I2_CONFIGURE Create Oracle/RHYTHM Integration Flexfields
MRP_I2_SETUP_PARAMETERS Setup RHYTHM Parameters
MRPDELFS Delete Flow Schedules
MRPROLFS Roll Flow Schedules
MRPCBIS Calculate Plan Performance Indicators
MRPWXPWF Launch Plan Exceptions Workflow
RHXDPLVG Level Values Generation
MRPIWSCH Schedule Work Orders
MRPIPRLD Load Data to RHYTHM Factory Planner
MRPIPOPL Populate and Load Data to RHYTHM FP
MRPI2CUMUYLD Calculate and Update Cumulative Yields
MRPEXPWF Launch Planning Exceptions Workflow
MRPPBIS Populate Forecast Analysis data (BIS)
MRPI2CFGENH1 Create Oracle/RHYTHM Integration Flexfields for Enhancement Set1
MRPI2CFGENH2 Create Oracle/RHYTHM Integration Flexfields for Attr. Base Planning
MSRFWOR Refresh Collection Snapshots
EDW_MRP_DM_CLS_M Collect Demand Class Dimension
EDW_MRP_PLAN_M Collect Plan Name Dimension
EDW_MRP_FORECAST_M Collect Forecast Dimension
MRCBLC MRP BOM/Wip Loop Checking Program
MRPPRGSN Truncate Large Snapshot Logs
MRPWFBG MRPWFBG
MRPRELWF Start Reschedule PO Workflow
MRPRSHPO Reschedule PO
MRPRPSST_XML Master Schedule Status Report (XML)
MRPRUSUR_XML Planning Parameters Report (XML)
MRPRPLOR_XML Late Order Report (XML)
MRPRPPES_XML Planning Exception Sets Report (XML)
MRPRPPIT_XML Financial Analysis Report (XML)
MRPRPPLO_XML Planned Order Report (XML)
MRPRPPLS_XML Supply Chain Planned Order Report (XML)
MRPRPROP_XML Reorder Point Report (XML)
MRPRPRSC_XML Order Reschedule Report (XML)
MRPRPRSS_XML Supply Chain Order Reschedule Report (XML)
MRPRPSSS_XML Supply Chain Schedule Status Report (XML)
MRPRPLOS_XML Supply Chain Late Order Report (XML)
MRPRPPIS_XML Supply Chain Financial Analysis Report (XML)