Product: | INV - Inventory |
---|---|
Description: | Material transaction table |
Implementation/DBA Data: | INV.MTL_MATERIAL_TRANSACTIONS |
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 |
|
|
|