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_TEMP

Product:	INV - Inventory
Description:	Temporary table for processing material transactions
Implementation/DBA Data:	INV.MTL_MATERIAL_TRANSACTIONS_TEMP

Primary Key: MTL_MATERIAL_TRANSACTIONS_T_PK

TRANSACTION_HEADER_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_MATERIAL_TRANSACTIONS_TEMP	GL_CODE_COMBINATIONS	MTL_MATERIAL_TRANSACTIONS_TEMP.DISTRIBUTION_ACCOUNT_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	MTL_SECONDARY_INVENTORIES	MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_SUBINVENTORY MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_ORGANIZATION
MTL_MATERIAL_TRANSACTIONS_TEMP	MTL_SYSTEM_ITEMS_B	MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	RCV_TRANSACTIONS	MTL_MATERIAL_TRANSACTIONS_TEMP.RCV_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	ORG_ACCT_PERIODS	MTL_MATERIAL_TRANSACTIONS_TEMP.ACCT_PERIOD_ID MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	WIP_MOVE_TRANSACTIONS	MTL_MATERIAL_TRANSACTIONS_TEMP.MOVE_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	WIP_DISCRETE_JOBS	MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	WIP_FLOW_SCHEDULES	MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	MTL_GENERIC_DISPOSITIONS	MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_SOURCE_TYPE_ID MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	GL_CODE_COMBINATIONS	MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSPORTATION_ACCOUNT
MTL_MATERIAL_TRANSACTIONS_TEMP	MTL_TXN_REQUEST_LINES	MTL_MATERIAL_TRANSACTIONS_TEMP.MOVE_ORDER_LINE_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	MTL_RESERVATIONS	MTL_MATERIAL_TRANSACTIONS_TEMP.RESERVATION_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	MTL_ITEM_LOCATIONS	MTL_MATERIAL_TRANSACTIONS_TEMP.LOCATOR_ID MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS_TEMP	MTL_ITEM_LOCATIONS	MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_TO_LOCATION MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_ORGANIZATION
MTL_MATERIAL_TRANSACTIONS_TEMP	MTL_ITEM_REVISIONS_B	MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION
MTL_MATERIAL_TRANSACTIONS_TEMP	MTL_SECONDARY_INVENTORIES	MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID
WMS_EXCEPTIONS	MTL_MATERIAL_TRANSACTIONS_TEMP	WMS_EXCEPTIONS.TRANSACTION_HEADER_ID
WMS_SKIP_TASK_EXCEPTIONS	MTL_MATERIAL_TRANSACTIONS_TEMP	WMS_SKIP_TASK_EXCEPTIONS.TRANSACTION_HEADER_ID