OA_MRP Critical Tables

MTL_SYSTEM_ITEMS

Inventory master file (in version 11.03 only)

MTL_SYSTEM_ITEMS_B

Inventory master file (in version 11i or later only)

MRP_SCHEDULE_DESIGNATORS

Schedule headers

MRP_SCHEDULE_ITEMS

Schedule items

MRP_SCHEDULE_DATES

Schedule entry for given item for a given date for master demand and master production schedules

MRP_SCHEDULE_CONSUMPTIONS

Tracks master schedule relief

MRP_PLANS

Stores settings that determine the behavior of the planning process

MRP_PLAN_SCHEDULES

Supply and demand schedules for MPS, MRP and DRP plans

MRP_SYSTEM_ITEMS

Items planned in the inventory master

MRP_FORECAST_DESIGNATORS

Forecast names and sets, which are included in the header

MRP_FORECAST_ITEMS

Forecast items

MRP_FORECAST_DATES

Item level forecast schedule information over date range

MRP_RECOMMENDATIONS

Stores suggestions for a given plan