FND Design Data [Home] [Help]

Table: MRP_SUPPLIER_FLEX_FENCES

Product: MRP - Master Scheduling/MRP
Description: Stores information forsupplier flex fence support
Implementation/DBA Data: TableMRP.MRP_SUPPLIER_FLEX_FENCES
Primary Key: MRP_SUPPLIER_FLEX_FENCES_PK1
  1. ColumnCOMPILE_DESIGNATOR
  2. ColumnSUPPLIER_ID
  3. ColumnSUPPLIER_SITE_ID
  4. ColumnORGANIZATION_ID
  5. ColumnINVENTORY_ITEM_ID
  6. ColumnFENCE_DAYS
  7. ColumnUSING_ORGANIZATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MRP_SUPPLIER_FLEX_FENCES FK Joins to TableMTL_SYSTEM_ITEMS_B MRP_SUPPLIER_FLEX_FENCES.INVENTORY_ITEM_ID
MRP_SUPPLIER_FLEX_FENCES.ORGANIZATION_ID
MRP_SUPPLIER_FLEX_FENCES FK Joins to TablePO_VENDOR_SITES_ALL MRP_SUPPLIER_FLEX_FENCES.SUPPLIER_SITE_ID
MRP_SUPPLIER_FLEX_FENCES FK Joins to TablePO_VENDORS MRP_SUPPLIER_FLEX_FENCES.SUPPLIER_ID
MRP_SUPPLIER_FLEX_FENCES FK Joins to TableMTL_PARAMETERS MRP_SUPPLIER_FLEX_FENCES.ORGANIZATION_ID