Search Results mtl_unit_transactions

Overview

The MTL_UNIT_TRANSACTIONS table is a core transactional data object within the Oracle E-Business Suite Inventory (INV) module. It serves as the definitive repository for recording serial number-specific movement and status changes. Its primary role is to maintain a granular, historical audit trail for every individual serialized unit as it transacts through inventory, linking each serial number to its corresponding material transaction. This table is essential for serial number tracking, genealogy, warranty management, and compliance reporting.

Key Information Stored

The table's structure centers on the unique combination of a transaction identifier and a serial number, which forms its primary key. Key columns include TRANSACTION_ID, which links to the parent material transaction in MTL_MATERIAL_TRANSACTIONS, and SERIAL_NUMBER, identifying the specific unit. Other critical columns capture the unit's context at the time of the transaction, such as INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE, and LOCATOR_ID. The table also stores TRANSACTION_SOURCE_TYPE_ID to categorize the nature of the transaction (e.g., Sales Order, Work Order).

Common Use Cases and Queries

A primary use case is tracing the complete lifecycle of a serialized item. Support and repair teams frequently query this table to determine an item's receipt, internal transfers, and final shipment. Another common scenario is generating serial number status reports for physical inventory or audit purposes. A typical query pattern involves joining to MTL_MATERIAL_TRANSACTIONS for transaction dates and details, and to MTL_SERIAL_NUMBERS for current status.

• Sample Query (Transaction History for a Serial): SELECT mut.serial_number, mmt.transaction_date, mmt.transaction_type_id FROM mtl_unit_transactions mut, mtl_material_transactions mmt WHERE mut.transaction_id = mmt.transaction_id AND mut.serial_number = 'SERIAL123' ORDER BY mmt.transaction_date;
• Reporting Use Case: Listing all serial numbers involved in a specific inter-organization transfer or sales order shipment.

Related Objects

MTL_UNIT_TRANSACTIONS has integral relationships with several fundamental Inventory tables, as documented by its foreign keys. It is a child table of MTL_MATERIAL_TRANSACTIONS, joined on TRANSACTION_ID. Each serialized unit record is linked to its master serial definition via MTL_SERIAL_NUMBERS on SERIAL_NUMBER, INVENTORY_ITEM_ID, and ORGANIZATION_ID. The table also references location data through MTL_ITEM_LOCATIONS (LOCATOR_ID) and MTL_SECONDARY_INVENTORIES (SUBINVENTORY_CODE, ORGANIZATION_ID). Finally, it categorizes the transaction source by joining to MTL_TXN_SOURCE_TYPES on TRANSACTION_SOURCE_TYPE_ID.