eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: MTL_TRANSACTION_LOT_NUMBERS

Product:	INV - Inventory
Description:	Transaction lot numbers
Implementation/DBA Data:	INV.MTL_TRANSACTION_LOT_NUMBERS

Primary Key: MTL_TRANSACTION_LOT_NUMBERS_PK

TRANSACTION_ID
LOT_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_TRANSACTION_LOT_NUMBERS	MTL_MATERIAL_TRANSACTIONS	MTL_TRANSACTION_LOT_NUMBERS.TRANSACTION_ID
MTL_TRANSACTION_LOT_NUMBERS	MTL_TXN_SOURCE_TYPES	MTL_TRANSACTION_LOT_NUMBERS.TRANSACTION_SOURCE_TYPE_ID
MTL_TRANSACTION_LOT_NUMBERS	MTL_LOT_NUMBERS	MTL_TRANSACTION_LOT_NUMBERS.INVENTORY_ITEM_ID MTL_TRANSACTION_LOT_NUMBERS.ORGANIZATION_ID MTL_TRANSACTION_LOT_NUMBERS.LOT_NUMBER