OracleOps AI
← All tables
Oracle Fusion/Supply Chain/Inventory

MTL_TRANSACTION_TYPES

Lookup of predefined inventory transaction types (Miscellaneous Issue, Miscellaneous Receipt, Subinventory Transfer, etc.) that classify each row on MTL_MATERIAL_TRANSACTIONS.

Key Columns

TRANSACTION_TYPE_IDTRANSACTION_TYPE_NAMETRANSACTION_ACTION_ID

Common Joins

MTL_MATERIAL_TRANSACTIONSvia TRANSACTION_TYPE_ID

Every recorded transaction is classified by one of these types.

Used In

Inventory

Related

Inventory transaction types

Every row in MTL_MATERIAL_TRANSACTIONS is classified by a predefined type from MTL_TRANSACTION_TYPES — common ones are Miscellaneous Issue/Receipt (manual quantity adjustments not tied to a PO or sales order, typically requiring an account for the offsetting entry), Subinventory Transfer (moving quantity between subinventories/locators within the same org, no accounting impact), and Inter-organization Transfer (moving quantity between orgs, which can be in-transit and does have accounting impact). Shipping and receiving-driven transactions (ship confirm, PO receipt) are generated automatically by those processes rather than entered directly in Inventory.

Ask Oracle AI about MTL_TRANSACTION_TYPES