FND Design Data [Home] [Help]

Table: MTL_TRANSACTION_LOT_NUMBERS

Product: INV - Inventory
Description: Transaction lot numbers
Implementation/DBA Data: TableINV.MTL_TRANSACTION_LOT_NUMBERS
Primary Key: MTL_TRANSACTION_LOT_NUMBERS_PK
  1. ColumnTRANSACTION_ID
  2. ColumnLOT_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_TRANSACTION_LOT_NUMBERS FK Joins to TableMTL_MATERIAL_TRANSACTIONS MTL_TRANSACTION_LOT_NUMBERS.TRANSACTION_ID
MTL_TRANSACTION_LOT_NUMBERS FK Joins to TableMTL_TXN_SOURCE_TYPES MTL_TRANSACTION_LOT_NUMBERS.TRANSACTION_SOURCE_TYPE_ID
MTL_TRANSACTION_LOT_NUMBERS FK Joins to TableMTL_LOT_NUMBERS MTL_TRANSACTION_LOT_NUMBERS.INVENTORY_ITEM_ID
MTL_TRANSACTION_LOT_NUMBERS.ORGANIZATION_ID
MTL_TRANSACTION_LOT_NUMBERS.LOT_NUMBER