FND Design Data [Home] [Help]

Table: MRP_ITEM_SOURCING

Product: MRP - Master Scheduling/MRP
Description: Sourcing information for planned items
Implementation/DBA Data: TableMRP.MRP_ITEM_SOURCING
Primary Key: MRP_ITEM_SOURCING_PK
  1. ColumnCOMPILE_DESIGNATOR
  2. ColumnORGANIZATION_ID
  3. ColumnINVENTORY_ITEM_ID
  4. ColumnSOURCE_ORGANIZATION_ID
  5. ColumnVENDOR_ID
  6. ColumnVENDOR_SITE_ID
  7. ColumnEFFECTIVE_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
MRP_ITEM_SOURCING FK Joins to TableMRP_SYSTEM_ITEMS MRP_ITEM_SOURCING.INVENTORY_ITEM_ID
MRP_ITEM_SOURCING.ORGANIZATION_ID
MRP_ITEM_SOURCING.COMPILE_DESIGNATOR