MRP Tables (128)
MRP - Master Scheduling/MRP — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
MRP_AD_BOMS |
12 | |
MRP_AD_CTO_ORDER_DEMAND |
11 | |
MRP_AD_DEMAND |
13 | |
MRP_AD_DEPT_RESS |
12 | |
MRP_AD_DSCR_JOBS |
15 | |
MRP_AD_FLOW_SCHDS |
13 | |
MRP_AD_FORECAST_DATES |
9 | |
MRP_AD_FORECAST_DSGN |
8 | |
MRP_AD_INV_COMPS |
13 | |
MRP_AD_MTRX_TMP |
27 | |
MRP_AD_OH_QTYS |
23 | |
MRP_AD_OPERATION_COMPONENTS |
16 | |
MRP_AD_OPR_NETWORKS |
15 | |
MRP_AD_OPR_RESS |
18 | |
MRP_AD_OPR_RTNS |
13 | |
MRP_AD_OPR_SEQS |
13 | |
MRP_AD_ORDER_LINES_ALL |
13 | |
MRP_AD_PROCESS_EFFECTIVITY |
15 | |
MRP_AD_REPT_ITEM_DEMANDS |
15 | |
MRP_AD_REPT_ITEM_SUPPLIES |
12 | |
MRP_AD_REPT_SCHDS |
11 | |
MRP_AD_RESOURCE_REQUIREMENTS |
20 | |
MRP_AD_RES_CHNGS |
19 | |
MRP_AD_SCHD_DATES |
15 | |
MRP_AD_SI_CAPA |
13 | |
MRP_AD_SUB_OPR_RESS |
19 | |
MRP_AD_SUPPLY |
16 | |
MRP_AD_U_DEMAND |
12 | |
MRP_AD_U_SUPPLY |
12 | |
MRP_AD_WIP_COMP_DEMANDS |
25 | |
MRP_AD_WIP_COMP_SUPPLIES |
25 | |
MRP_AD_WLINES |
11 | |
MRP_AD_WOPRS |
13 | |
MRP_AD_WOPR_RESS |
14 | |
MRP_AD_WREQ_OPRS |
14 | |
MRP_AGGREGATE_RATES |
23 | Suggested aggregate repetitive rates of production |
MRP_AMONG_VALUES |
10 | User selected criteria for 10SC Planner Workbench |
MRP_ASSEMBLY_OPERATIONS |
18 | Not currently used |
MRP_ASSIGNMENT_SETS |
28 | Sourcing assignment set |
MRP_ATP_DETAILS_TEMP |
145 | Holds ATP result details for Supply/Demand, Horizontal ATP and sourcing. |
MRP_ATP_SCHEDULE_TEMP |
144 | Holds ATP results |
MRP_ATP_SUPPLY_DEMAND |
33 | |
MRP_AUDIT_SQL_STATEMENTS |
32 | Holds SQL statements for the information audit |
MRP_AVAILABLE_TO_PROMISE |
17 | Available to promise information for master scheduled parts |
MRP_BIS_FORECAST_WB |
48 | Summary table stores forecast and actual values for use in the Discoverer workbook. |
MRP_BIS_INV_DETAIL |
19 | Inventory balance detail |
MRP_BIS_PLAN_PROFIT |
14 | Summary table used for the gross margin details in the BIS Plan Performance report. |
MRP_BIS_RES_SUMMARY |
19 | Summary table used for calculating the resource utilization in the BIS Plan Performance report. |
MRP_BOM_COMPONENTS |
30 | BOM and pending ECO information. |
MRP_CACHE_SEQ |
1 | This table is used to cache sequences during plan generation. |
MRP_COMPONENT_SUBSTITUTES |
16 | Inventory item substitutes |
MRP_CRITERIA |
18 | Seeded criteria for Planner Workbench |
MRP_DERIVED_SO_DEMANDS |
17 | |
MRP_DESIGNATORS |
34 | Plan names |
MRP_END_ASSEMBLIES |
17 | The end assemblies for a given item |
MRP_EXCELS |
16 | Seed data needed for generating graphs |
MRP_EXCEL_COLUMNS |
17 | Column information for graphs |
MRP_EXCEL_COMPONENTS |
14 | Seed data for generating graphs |
MRP_EXCEPTION_DETAILS |
30 | Exception details information |
MRP_FILES |
15 | File names used by the planner |
MRP_FLOW_DEMANDS |
12 | |
MRP_FORECAST_DATES |
58 | Forecast entries |
MRP_FORECAST_DESIGNATORS |
42 | Forecast names and sets |
MRP_FORECAST_INTERFACE |
44 | Interface table to load forecast |
MRP_FORECAST_ITEMS |
30 | Items in a forecast |
MRP_FORECAST_UPDATES |
24 | Forecast consumption transaction history |
MRP_FORM_QUERY |
42 | Generic query table for inquiry forms |
MRP_FULL_PEGGING |
28 | Full Pegging information |
MRP_GROSS_REQUIREMENTS |
39 | Gross requirements |
MRP_I2_PARAMETERS |
12 | An Oracle/Rhythm Integration table used for storing user configuration parameters |
MRP_INVENTORY_LOTS |
22 | Inventory lot information |
MRP_ITEM_EXCEPTIONS |
26 | MRP plan exception messages |
MRP_ITEM_PURCHASE_ORDERS |
38 | Purchase orders and purchase requisitions |
MRP_ITEM_SOURCING |
25 | Sourcing information for planned items |
MRP_ITEM_SUPPLIERS |
35 | Stores supplier specific information for items |
MRP_ITEM_WIP_ENTITIES |
35 | Discrete jobs |
MRP_KANBAN_DEMAND |
23 | Demand information for items included in a kanban plan |
MRP_KANBAN_PLANS |
36 | Kanban Plan Names table |
MRP_LOAD_PARAMETERS |
18 | Forecast/Schedule load parameters |
MRP_LOAD_SELECTIONS |
9 | Selection Lists |
MRP_LOW_LEVEL_CODES |
33 | Low level codes for Kanban planned items |
MRP_MATERIAL_PLANS |
50 | Horizontal plan for planned items |
MRP_MESSAGES_TMP |
17 | Timing statistics table |
MRP_NET_RESOURCE_AVAIL |
36 | Detail level availability of the resources |
MRP_ONHAND_QUANTITIES |
16 | On hand information for items in a plan |
MRP_PARAMETERS |
47 | Planning parameters |
MRP_PENDING_ENG_CHANGES |
28 | Not currently used |
MRP_PLANNED_RESOURCE_REQS |
27 | Resource requirements to build an assembly |
MRP_PLANNER_TASKS |
15 | MRP Planner task information |
MRP_PLANNING_EXCEPTION_SETS |
38 | Controls for a set of exception messages |
MRP_PLANS |
95 | Settings for a specific plan name |
MRP_PLAN_ORGANIZATIONS |
36 | Organizations planned by a MRP/MPS/DRP plan |
MRP_PLAN_SCHEDULES |
31 | Supply and Demand Schedules for MPS, MRP, and DRP plans |
MRP_PO_RESCHEDULE_GT |
15 | |
MRP_RECOMMENDATIONS |
92 | MRP plan recommendations |
MRP_RELIEF_INTERFACE |
31 | Interface table to relieve the master schedule tables |
MRP_REPETITIVE_PERIODS |
11 | MRP repetitive planning period start dates |
MRP_REPETITIVE_SCHEDULES |
28 | Current repetitive schedules |
MRP_RESERVATIONS |
26 | Material reservations |
MRP_SAFETY_STOCK |
16 | Safety stock levels |
MRP_SALES_ORDER_UPDATES |
38 | Sales order changes used for forecast consumption |
MRP_SCHEDULER_MESSAGES |
11 | Error messages from the schedule manager |
MRP_SCHEDULE_CONSUMPTIONS |
18 | Consumption history for master schedule |
MRP_SCHEDULE_DATES |
55 | Master production schedule and master demand schedule |
MRP_SCHEDULE_DESIGNATORS |
36 | Schedule names |
MRP_SCHEDULE_INTERFACE |
43 | Master Schedule interface for outside sources |
MRP_SCHEDULE_ITEMS |
30 | Master scheduled items |
MRP_SCHEDULING_RULES |
32 | This table stores the various scheduling rules used by the planning and execution system. |
MRP_SELECTION_CRITERIA |
16 | User selected criteria for Planner Workbench |
MRP_SNAPSHOT_TASKS |
19 | Tasks to be performed by Snapshot Workers |
MRP_SOURCING_HISTORY |
17 | Historical information related to Sourcing |
MRP_SOURCING_RULES |
32 | Sourcing Rules or Bills of Distribution |
MRP_SO_LINES_TEMP |
8 | To store modified sales order lines for planning manager |
MRP_SQLLOAD_PARAMETERS |
8 | |
MRP_SR_ASSIGNMENTS |
37 | Sourcing assignments |
MRP_SR_RECEIPT_ORG |
30 | Receiving Organizations for Sourcing Rules or Bills of distribution |
MRP_SR_SOURCE_ORG |
36 | Source organization for Sourcing Rules or Bills of distribution |
MRP_SUB_INVENTORIES |
29 | Subinventory netting information |
MRP_SUGG_REP_SCHEDULES |
31 | Suggested repetitive schedules |
MRP_SUPPLIER_CAPACITIES |
34 | Stores the supplier capacity information for items. |
MRP_SUPPLIER_FLEX_FENCES |
33 | Stores information forsupplier flex fence support |
MRP_SYSTEM_ITEMS |
84 | MRP item master |
MRP_WIP_COMPONENTS |
26 | WIP requirements |
MRP_WIP_RESOURCES |
24 | Resources used for a job |
MRP_WORKBENCH_BUCKET_DATES |
45 | Bucket dates for Planner Workbench Horizontal Plan |
MRP_WORKBENCH_CRITERIA |
28 | Criteria and criteria sets for the planner workbench |
MRP_WORKBENCH_DISPLAY_OPTIONS |
78 | Planner Workbench display options |
MRP_WORKBENCH_QUERY |
44 | Recommendations based on user criteria selected in MRP Planner WorkBench |