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_MATERIAL_TRANSACTIONS

Product:	INV - Inventory
Description:	Material transaction table
Implementation/DBA Data:	INV.MTL_MATERIAL_TRANSACTIONS

Primary Key: MTL_MATERIAL_TRANSACTIONS_PK

TRANSACTION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_MATERIAL_TRANSACTIONS	GL_CODE_COMBINATIONS	MTL_MATERIAL_TRANSACTIONS.TRANSFER_COST_DIST_ACCOUNT
MTL_MATERIAL_TRANSACTIONS	MTL_ITEM_REVISIONS_B	MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID MTL_MATERIAL_TRANSACTIONS.REVISION
MTL_MATERIAL_TRANSACTIONS	MTL_CYCLE_COUNT_ENTRIES	MTL_MATERIAL_TRANSACTIONS.CYCLE_COUNT_ID
MTL_MATERIAL_TRANSACTIONS	MTL_PHYSICAL_ADJUSTMENTS	MTL_MATERIAL_TRANSACTIONS.PHYSICAL_ADJUSTMENT_ID
MTL_MATERIAL_TRANSACTIONS	MTL_TRANSACTION_TYPES	MTL_MATERIAL_TRANSACTIONS.TRANSACTION_TYPE_ID
MTL_MATERIAL_TRANSACTIONS	GL_DAILY_CONVERSION_TYPES	MTL_MATERIAL_TRANSACTIONS.CURRENCY_CODE
MTL_MATERIAL_TRANSACTIONS	MTL_SYSTEM_ITEMS_B	MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS	CST_COST_GROUPS	MTL_MATERIAL_TRANSACTIONS.TRANSFER_COST_GROUP_ID
MTL_MATERIAL_TRANSACTIONS	WIP_DISCRETE_JOBS	MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_ID
MTL_MATERIAL_TRANSACTIONS	WIP_REPETITIVE_ITEMS	MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_ID MTL_MATERIAL_TRANSACTIONS.REPETITIVE_LINE_ID
MTL_MATERIAL_TRANSACTIONS	MTL_ITEM_LOCATIONS	MTL_MATERIAL_TRANSACTIONS.LOCATOR_ID MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS	ORG_ACCT_PERIODS	MTL_MATERIAL_TRANSACTIONS.ACCT_PERIOD_ID MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS	GL_CODE_COMBINATIONS	MTL_MATERIAL_TRANSACTIONS.TRANSPORTATION_DIST_ACCOUNT
MTL_MATERIAL_TRANSACTIONS	MTL_SECONDARY_INVENTORIES	MTL_MATERIAL_TRANSACTIONS.SUBINVENTORY_CODE MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS	WIP_FLOW_SCHEDULES	MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_ID
MTL_MATERIAL_TRANSACTIONS	RCV_TRANSACTIONS	MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS	WIP_MOVE_TRANSACTIONS	MTL_MATERIAL_TRANSACTIONS.MOVE_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS	MTL_TXN_SOURCE_TYPES	MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID
MTL_MATERIAL_TRANSACTIONS	MTL_TXN_REQUEST_LINES	MTL_MATERIAL_TRANSACTIONS.MOVE_ORDER_LINE_ID
MTL_MATERIAL_TRANSACTIONS	MTL_TRANSACTION_REASONS	MTL_MATERIAL_TRANSACTIONS.REASON_ID
MTL_MATERIAL_TRANSACTIONS	GL_CODE_COMBINATIONS	MTL_MATERIAL_TRANSACTIONS.DISTRIBUTION_ACCOUNT_ID
MTL_MATERIAL_TRANSACTIONS	GL_CODE_COMBINATIONS	MTL_MATERIAL_TRANSACTIONS.ENCUMBRANCE_ACCOUNT
MTL_MATERIAL_TRANSACTIONS	CST_COST_GROUPS	MTL_MATERIAL_TRANSACTIONS.COST_GROUP_ID
AHL_WORKORDER_MTL_TXNS	MTL_MATERIAL_TRANSACTIONS	AHL_WORKORDER_MTL_TXNS.MATERIAL_TRANSACTION_ID
CST_COGS_EVENTS	MTL_MATERIAL_TRANSACTIONS	CST_COGS_EVENTS.MMT_TRANSACTION_ID
CST_AE_HEADERS	MTL_MATERIAL_TRANSACTIONS	CST_AE_HEADERS.ACCOUNTING_EVENT_ID
CST_COMP_SNAPSHOT	MTL_MATERIAL_TRANSACTIONS	CST_COMP_SNAPSHOT.TRANSACTION_ID
CST_MGD_INFL_TSF_ORG_ENTRIES	MTL_MATERIAL_TRANSACTIONS	CST_MGD_INFL_TSF_ORG_ENTRIES.TRANSACTION_ID
CST_MISC_RECONCILIATION	MTL_MATERIAL_TRANSACTIONS	CST_MISC_RECONCILIATION.INVENTORY_TRANSACTION_ID
CST_WRITE_OFFS	MTL_MATERIAL_TRANSACTIONS	CST_WRITE_OFFS.INVENTORY_TRANSACTION_ID
CST_WRITE_OFF_DETAILS	MTL_MATERIAL_TRANSACTIONS	CST_WRITE_OFF_DETAILS.INVENTORY_TRANSACTION_ID
JAI_CMN_RG_23D_TRXS	MTL_MATERIAL_TRANSACTIONS	JAI_CMN_RG_23D_TRXS.GOODS_ISSUE_ID
JAI_CMN_TRANSACTIONS_T	MTL_MATERIAL_TRANSACTIONS	JAI_CMN_TRANSACTIONS_T.TRANSACTION_ID
JAI_ENCUM_TAX_RVRSL_DTLS	MTL_MATERIAL_TRANSACTIONS	JAI_ENCUM_TAX_RVRSL_DTLS.ACCT_TXN_ID
JAI_PO_RMA_RTN_LINES	MTL_MATERIAL_TRANSACTIONS	JAI_PO_RMA_RTN_LINES.RMA_RTN_ID
JAI_PO_RMA_RTN_TX_LNS	MTL_MATERIAL_TRANSACTIONS	JAI_PO_RMA_RTN_TX_LNS.RMA_RTN_ID
MTL_ACTUAL_COST_SUBELEMENT	MTL_MATERIAL_TRANSACTIONS	MTL_ACTUAL_COST_SUBELEMENT.TRANSACTION_ID
MTL_CST_ACTUAL_COST_DETAILS	MTL_MATERIAL_TRANSACTIONS	MTL_CST_ACTUAL_COST_DETAILS.TRANSACTION_ID
MTL_CST_TXN_COST_DETAILS	MTL_MATERIAL_TRANSACTIONS	MTL_CST_TXN_COST_DETAILS.TRANSACTION_ID
MTL_MATERIAL_TXN_ALLOCATIONS	MTL_MATERIAL_TRANSACTIONS	MTL_MATERIAL_TXN_ALLOCATIONS.TRANSACTION_ID
MTL_OBJECT_EVENTS	MTL_MATERIAL_TRANSACTIONS	MTL_OBJECT_EVENTS.TRANSACTION_ID
MTL_OBJECT_GENEALOGY	MTL_MATERIAL_TRANSACTIONS	MTL_OBJECT_GENEALOGY.ORIGIN_TXN_ID
MTL_ONHAND_QUANTITIES	MTL_MATERIAL_TRANSACTIONS	MTL_ONHAND_QUANTITIES.CREATE_TRANSACTION_ID
MTL_ONHAND_QUANTITIES	MTL_MATERIAL_TRANSACTIONS	MTL_ONHAND_QUANTITIES.UPDATE_TRANSACTION_ID
MTL_PAC_ACTUAL_COST_DETAILS	MTL_MATERIAL_TRANSACTIONS	MTL_PAC_ACTUAL_COST_DETAILS.TRANSACTION_ID
MTL_PAC_COST_SUBELEMENTS	MTL_MATERIAL_TRANSACTIONS	MTL_PAC_COST_SUBELEMENTS.TRANSACTION_ID
MTL_PAC_TXN_COST_DETAILS	MTL_MATERIAL_TRANSACTIONS	MTL_PAC_TXN_COST_DETAILS.TRANSACTION_ID
MTL_SERIAL_NUMBERS	MTL_MATERIAL_TRANSACTIONS	MTL_SERIAL_NUMBERS.LAST_TRANSACTION_ID
MTL_TRANSACTION_ACCOUNTS	MTL_MATERIAL_TRANSACTIONS	MTL_TRANSACTION_ACCOUNTS.TRANSACTION_ID
MTL_TRANSACTION_LOT_NUMBERS	MTL_MATERIAL_TRANSACTIONS	MTL_TRANSACTION_LOT_NUMBERS.TRANSACTION_ID
MTL_UNIT_TRANSACTIONS	MTL_MATERIAL_TRANSACTIONS	MTL_UNIT_TRANSACTIONS.TRANSACTION_ID
PJM_BORROW_PAYBACKS	MTL_MATERIAL_TRANSACTIONS	PJM_BORROW_PAYBACKS.PAYBACK_TRANSACTION_ID
PJM_BORROW_TRANSACTIONS	MTL_MATERIAL_TRANSACTIONS	PJM_BORROW_TRANSACTIONS.BORROW_TRANSACTION_ID
PO_ACCRUAL_RECONCILE_TEMP_ALL	MTL_MATERIAL_TRANSACTIONS	PO_ACCRUAL_RECONCILE_TEMP_ALL.INV_TRANSACTION_ID
PO_ACCRUAL_WRITE_OFFS_ALL	MTL_MATERIAL_TRANSACTIONS	PO_ACCRUAL_WRITE_OFFS_ALL.INV_TRANSACTION_ID
RCV_TRANSACTIONS	MTL_MATERIAL_TRANSACTIONS	RCV_TRANSACTIONS.INV_TRANSACTION_ID
RCV_TRANSACTIONS_INTERFACE	MTL_MATERIAL_TRANSACTIONS	RCV_TRANSACTIONS_INTERFACE.INV_TRANSACTION_ID
WIP_SCRAP_VALUES	MTL_MATERIAL_TRANSACTIONS	WIP_SCRAP_VALUES.TRANSACTION_ID
WMS_DISPATCHED_TASKS_HISTORY	MTL_MATERIAL_TRANSACTIONS	WMS_DISPATCHED_TASKS_HISTORY.TRANSACTION_ID