FND Design Data [Home] [Help]

Table: MTL_UNIT_TRANSACTIONS

Product: INV - Inventory
Description: Serial number transactions
Implementation/DBA Data: TableINV.MTL_UNIT_TRANSACTIONS
Primary Key: MTL_UNIT_TRANSACTIONS_PK
  1. ColumnTRANSACTION_ID
  2. ColumnSERIAL_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_UNIT_TRANSACTIONS FK Joins to TableMTL_ITEM_LOCATIONS MTL_UNIT_TRANSACTIONS.LOCATOR_ID
MTL_UNIT_TRANSACTIONS.ORGANIZATION_ID
MTL_UNIT_TRANSACTIONS FK Joins to TableMTL_MATERIAL_TRANSACTIONS MTL_UNIT_TRANSACTIONS.TRANSACTION_ID
MTL_UNIT_TRANSACTIONS FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_UNIT_TRANSACTIONS.SUBINVENTORY_CODE
MTL_UNIT_TRANSACTIONS.ORGANIZATION_ID
MTL_UNIT_TRANSACTIONS FK Joins to TableMTL_SERIAL_NUMBERS MTL_UNIT_TRANSACTIONS.SERIAL_NUMBER
MTL_UNIT_TRANSACTIONS.INVENTORY_ITEM_ID
MTL_UNIT_TRANSACTIONS.ORGANIZATION_ID
MTL_UNIT_TRANSACTIONS FK Joins to TableMTL_TXN_SOURCE_TYPES MTL_UNIT_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID