FND Design Data [Home] [Help]

Table: MRP_SCHEDULE_DATES

Product: MRP - Master Scheduling/MRP
Description: Master production schedule and master demand schedule
Implementation/DBA Data: TableMRP.MRP_SCHEDULE_DATES
Primary Key: MRP_SCHEDULE_DATES_PK
  1. ColumnMPS_TRANSACTION_ID
  2. ColumnSCHEDULE_LEVEL
  3. ColumnSUPPLY_DEMAND_TYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
MRP_SCHEDULE_DATES FK Joins to TableMRP_FORECAST_DESIGNATORS MRP_SCHEDULE_DATES.SOURCE_FORECAST_DESIGNATOR
MRP_SCHEDULE_DATES.ORGANIZATION_ID
MRP_SCHEDULE_DATES FK Joins to TableMTL_SALES_ORDERS MRP_SCHEDULE_DATES.SOURCE_SALES_ORDER_ID
MRP_SCHEDULE_DATES FK Joins to TableWIP_LINES MRP_SCHEDULE_DATES.LINE_ID
MRP_SCHEDULE_DATES FK Joins to TableMRP_FORECAST_DATES MRP_SCHEDULE_DATES.FORECAST_ID
MRP_SCHEDULE_DATES FK Joins to TableMRP_SCHEDULE_ITEMS MRP_SCHEDULE_DATES.INVENTORY_ITEM_ID
MRP_SCHEDULE_DATES.ORGANIZATION_ID
MRP_SCHEDULE_DATES.SCHEDULE_DESIGNATOR
MRP_SCHEDULE_DATES FK Joins to TableMRP_RECOMMENDATIONS MRP_SCHEDULE_DATES.REFERENCE_SCHEDULE_ID
MRP_SCHEDULE_DATES FK Joins to TableMRP_SCHEDULE_DESIGNATORS MRP_SCHEDULE_DATES.SOURCE_SCHEDULE_DESIGNATOR
MRP_SCHEDULE_DATES.SOURCE_ORGANIZATION_ID