FND Design Data [Home] [Help]

Table: MTL_ONHAND_QUANTITIES

Product: INV - Inventory
Description: FIFO quantities by control level and receipt
Implementation/DBA Data: Not implemented in this database
Primary Key: MTL_FIFO_COSTS_PK
  1. ColumnINVENTORY_ITEM_ID
  2. ColumnORGANIZATION_ID
  3. ColumnDATE_RECEIVED
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_ONHAND_QUANTITIES FK Joins to TableMTL_ITEM_LOCATIONS MTL_ONHAND_QUANTITIES.LOCATOR_ID
MTL_ONHAND_QUANTITIES.ORGANIZATION_ID
MTL_ONHAND_QUANTITIES FK Joins to TableMTL_ITEM_REVISIONS_B MTL_ONHAND_QUANTITIES.INVENTORY_ITEM_ID
MTL_ONHAND_QUANTITIES.ORGANIZATION_ID
MTL_ONHAND_QUANTITIES.REVISION
MTL_ONHAND_QUANTITIES FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_ONHAND_QUANTITIES.SUBINVENTORY_CODE
MTL_ONHAND_QUANTITIES.ORGANIZATION_ID
MTL_ONHAND_QUANTITIES FK Joins to TableMTL_LOT_NUMBERS MTL_ONHAND_QUANTITIES.INVENTORY_ITEM_ID
MTL_ONHAND_QUANTITIES.ORGANIZATION_ID
MTL_ONHAND_QUANTITIES.LOT_NUMBER
MTL_ONHAND_QUANTITIES FK Joins to TableMTL_MATERIAL_TRANSACTIONS MTL_ONHAND_QUANTITIES.CREATE_TRANSACTION_ID
MTL_ONHAND_QUANTITIES FK Joins to TableMTL_MATERIAL_TRANSACTIONS MTL_ONHAND_QUANTITIES.UPDATE_TRANSACTION_ID
MTL_ONHAND_QUANTITIES FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_ONHAND_QUANTITIES.INVENTORY_ITEM_ID
MTL_ONHAND_QUANTITIES.ORGANIZATION_ID