FND Design Data [Home] [Help]

Table: MTL_SUPPLY

Product: INV - Inventory
Description: Stores incoming supply information
Implementation/DBA Data: TableINV.MTL_SUPPLY
Primary Key: MTL_SUPPLY_PK
  1. ColumnSUPPLY_TYPE_CODE
  2. ColumnSUPPLY_SOURCE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_SUPPLY FK Joins to TablePO_REQUISITION_HEADERS_ALL MTL_SUPPLY.REQ_HEADER_ID
MTL_SUPPLY FK Joins to TableRCV_TRANSACTIONS MTL_SUPPLY.RCV_TRANSACTION_ID
MTL_SUPPLY FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_SUPPLY.ITEM_ID
MTL_SUPPLY.TO_ORGANIZATION_ID
MTL_SUPPLY FK Joins to TableMTL_ITEM_REVISIONS_B MTL_SUPPLY.ITEM_ID
MTL_SUPPLY.TO_ORGANIZATION_ID
MTL_SUPPLY.ITEM_REVISION
MTL_SUPPLY FK Joins to TableMTL_CATEGORIES_B MTL_SUPPLY.CATEGORY_ID
MTL_SUPPLY FK Joins to TableMTL_ITEM_LOCATIONS MTL_SUPPLY.LOCATION_ID
MTL_SUPPLY.TO_ORGANIZATION_ID
MTL_SUPPLY FK Joins to TableMTL_INTERORG_PARAMETERS MTL_SUPPLY.FROM_ORGANIZATION_ID
MTL_SUPPLY.TO_ORGANIZATION_ID
MTL_SUPPLY FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_SUPPLY.FROM_SUBINVENTORY
MTL_SUPPLY.FROM_ORGANIZATION_ID
MTL_SUPPLY FK Joins to TableMTL_PARAMETERS MTL_SUPPLY.TO_ORGANIZATION_ID
MTL_SUPPLY FK Joins to TablePO_REQUISITION_LINES_ALL MTL_SUPPLY.REQ_LINE_ID
MTL_SUPPLY FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_SUPPLY.TO_SUBINVENTORY
MTL_SUPPLY.TO_ORGANIZATION_ID
MTL_SUPPLY FK Joins to TableMTL_PARAMETERS MTL_SUPPLY.INTRANSIT_OWNING_ORG_ID
MTL_SUPPLY FK Joins to TableMTL_PARAMETERS MTL_SUPPLY.MRP_TO_ORGANIZATION_ID
MTL_SUPPLY FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_SUPPLY.MRP_TO_SUBINVENTORY
MTL_SUPPLY.MRP_TO_ORGANIZATION_ID
MTL_SUPPLY FK Joins to TablePO_HEADERS_ALL MTL_SUPPLY.PO_HEADER_ID
MTL_SUPPLY FK Joins to TablePO_RELEASES_ALL MTL_SUPPLY.PO_RELEASE_ID
MTL_SUPPLY FK Joins to TablePO_LINES_ALL MTL_SUPPLY.PO_LINE_ID
MTL_SUPPLY FK Joins to TablePO_LINE_LOCATIONS_ALL MTL_SUPPLY.PO_LINE_LOCATION_ID
MTL_SUPPLY FK Joins to TablePO_DISTRIBUTIONS_ALL MTL_SUPPLY.PO_DISTRIBUTION_ID
MTL_SUPPLY FK Joins to TableRCV_SHIPMENT_HEADERS MTL_SUPPLY.SHIPMENT_HEADER_ID
MTL_SUPPLY FK Joins to TableRCV_SHIPMENT_LINES MTL_SUPPLY.SHIPMENT_LINE_ID