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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: INV.MTL_MATERIAL_TRANSACTIONS

Object Details

Object Name:	MTL_MATERIAL_TRANSACTIONS
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_MATERIAL_TRANSACTIONS
Subobject Name:
Status:	VALID

MTL_MATERIAL_TRANSACTIONS stores a record of every material
transaction or cost update performed in Inventory.
.
.
.
Records are inserted into this table either through the transaction
processor or by the standard cost update program. The columns
TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID,
TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_ID and
TRANSACTION_SOURCE_NAME describe what the transaction is and against
what entity it was performed.
.
.
.
All accounting journal entries for a given transaction are stored in
MTL_TRANSACTION_ACCOUNTS, joined by the column TRANSACTION_ID.
.
.
.
If the item is under lot control then the lot records are stored in
MTL_TRANSACTION_LOT_NUMBERS, joined by the column TRANSACTION_ID. If
the item is under serial control then the serial records are stored in
MTL_UNIT_TRANSACTIONS, joined by the column TRANSACTION_ID. The Item
revision and locator control are stored in the columns REVISION and
LOCATOR_ID respectively.
.
.
.
Transfer transactions are represented as two single records in the
table. They are related through the column TRANSFER_TRANSACTION_ID,
which contains the TRANSACTION_ID of the other transaction in the
transfer.
.
.
.
.
.
.
.
.
The index MTL_MATERIAL_TRANSACTIONS_UPGD is used only during install
and upgrade, and will be dropped during the course thereof, but is
included here for completeness.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_MATERIAL_TRANSACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ACTION_ID TRANSACTION_TYPE_ID TRANSACTION_SOURCE_TYPE_ID TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID ORGANIZATION_ID TRANSACTION_DATE
MTL_MATERIAL_TRANSACTIONS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COSTED_FLAG TRANSACTION_GROUP_ID
MTL_MATERIAL_TRANSACTIONS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_SET_ID
MTL_MATERIAL_TRANSACTIONS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PM_COST_COLLECTED PM_COST_COLLECTOR_GROUP_ID
MTL_MATERIAL_TRANSACTIONS_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPLETION_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ACTION_ID TRANSACTION_TYPE_ID TRANSACTION_SOURCE_TYPE_ID TRANSACTION_DATE
MTL_MATERIAL_TRANSACTIONS_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PICK_SLIP_NUMBER
MTL_MATERIAL_TRANSACTIONS_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MOVE_ORDER_LINE_ID
MTL_MATERIAL_TRANSACTIONS_N18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PICKING_LINE_ID
MTL_MATERIAL_TRANSACTIONS_N19	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RCV_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_SOURCE_ID ORGANIZATION_ID TRANSACTION_DATE
MTL_MATERIAL_TRANSACTIONS_N20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID
MTL_MATERIAL_TRANSACTIONS_N21	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TO_PROJECT_ID
MTL_MATERIAL_TRANSACTIONS_N22	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_PROJECT_ID
MTL_MATERIAL_TRANSACTIONS_N23	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSFER_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_N24	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICED_FLAG TRANSACTION_SOURCE_TYPE_ID TRANSACTION_ACTION_ID
MTL_MATERIAL_TRANSACTIONS_N25	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OPM_COSTED_FLAG
MTL_MATERIAL_TRANSACTIONS_N26	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_EXTRACTED
MTL_MATERIAL_TRANSACTIONS_N27	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRX_SOURCE_LINE_ID
MTL_MATERIAL_TRANSACTIONS_N28	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	XML_DOCUMENT_ID
MTL_MATERIAL_TRANSACTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUBINVENTORY_CODE ORGANIZATION_ID TRANSACTION_DATE
MTL_MATERIAL_TRANSACTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_LOT_NUMBER
MTL_MATERIAL_TRANSACTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_DATE ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_NUMBER
MTL_MATERIAL_TRANSACTIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCT_PERIOD_ID ORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_SOURCE_TYPE_ID ORGANIZATION_ID TRANSACTION_DATE TRANSACTION_SOURCE_NAME
MTL_MATERIAL_TRANSACTIONS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ACTION_ID ORGANIZATION_ID TRANSACTION_TYPE_ID TRANSACTION_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Transaction identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
REVISION	VARCHAR2	(3)		Inventory item revision
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
SUBINVENTORY_CODE	VARCHAR2	(10)		Transaction secondary inventory
LOCATOR_ID	NUMBER			Locator id for stock locators
TRANSACTION_TYPE_ID	NUMBER		Yes	Transaction type identifier
TRANSACTION_ACTION_ID	NUMBER		Yes	Transaction action identifier
TRANSACTION_SOURCE_TYPE_ID	NUMBER		Yes	Transaction source type identifier
TRANSACTION_SOURCE_ID	NUMBER			Transaction source identifier
TRANSACTION_SOURCE_NAME	VARCHAR2	(80)		Transaction source identfier
TRANSACTION_QUANTITY	NUMBER		Yes	Transaction quantity
TRANSACTION_UOM	VARCHAR2	(3)	Yes	Transaction unit of measure
PRIMARY_QUANTITY	NUMBER		Yes	Transaction quantity in terms of primary uom of the item
TRANSACTION_DATE	DATE		Yes	Transaction date
VARIANCE_AMOUNT	NUMBER			Used for average cost update transactions
ACCT_PERIOD_ID	NUMBER			Accounting period identifier
TRANSACTION_REFERENCE	VARCHAR2	(240)		Transaction reference code
REASON_ID	NUMBER			Transaction reason identifier
DISTRIBUTION_ACCOUNT_ID	NUMBER			Distribution account identifier
ENCUMBRANCE_ACCOUNT	NUMBER			Encumbrance account identifier for PO transactions
ENCUMBRANCE_AMOUNT	NUMBER			Total encumbrance amount
COST_UPDATE_ID	NUMBER			Cost identifier
COSTED_FLAG	VARCHAR2	(1)		Costed flag to mark if the transactions are costed or not
TRANSACTION_GROUP_ID	NUMBER			Transaction group iIdentifier for distribution processing by the cost processor
INVOICED_FLAG	VARCHAR2	(1)		Invoiced flag to mark if the transactions are invoiced
ACTUAL_COST	NUMBER			Actual cost
TRANSACTION_COST	NUMBER			The cost entered by the user during a transaction
PRIOR_COST	NUMBER			Item cost before the transaction
NEW_COST	NUMBER			Item cost after the transaction processing
CURRENCY_CODE	VARCHAR2	(10)		Currency conversion code
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		ussgl transaction code
QUANTITY_ADJUSTED	NUMBER			Standard cost quantity adjusted
EMPLOYEE_CODE	VARCHAR2	(10)		Transaction requestor
DEPARTMENT_ID	NUMBER			Department identifier
OPERATION_SEQ_NUM	NUMBER			Operation sequence number within a routing
MASTER_SCHEDULE_UPDATE_CODE	VARCHAR2	(10)		Master schedule update code
RECEIVING_DOCUMENT	VARCHAR2	(10)		Receiving document
PICKING_LINE_ID	NUMBER			Picking line id
TRX_SOURCE_LINE_ID	NUMBER			Line level transaction source id
TRX_SOURCE_DELIVERY_ID	NUMBER			Sales order delivery identifier
REPETITIVE_LINE_ID	NUMBER			Repetitive line id
PHYSICAL_ADJUSTMENT_ID	NUMBER			Physical adjustment identifier
CYCLE_COUNT_ID	NUMBER			Cycle count identifier
RMA_LINE_ID	NUMBER			Rma line identifier
TRANSFER_TRANSACTION_ID	NUMBER			Transaction id of the opposing transfer transaction
TRANSACTION_SET_ID	NUMBER			Transaction group identifier
RCV_TRANSACTION_ID	NUMBER			Receiving transaction cross reference
MOVE_TRANSACTION_ID	NUMBER			Move transaction cross reference
COMPLETION_TRANSACTION_ID	NUMBER			Completion transaction cross reference
SHORTAGE_PROCESS_CODE	NUMBER			Flag indicating workflow notifications should be provided for this transaction if shortage exists
SOURCE_CODE	VARCHAR2	(30)		User- entered source code for outside transactions
SOURCE_LINE_ID	NUMBER			User entered source line identifier for outside transactions
VENDOR_LOT_NUMBER	VARCHAR2	(30)		Supplier lot number
TRANSFER_ORGANIZATION_ID	NUMBER			Transfer opposing organization id
TRANSFER_SUBINVENTORY	VARCHAR2	(10)		Transfer transaction opposing subinventory
TRANSFER_LOCATOR_ID	NUMBER			Transfer transaction opposing locator id
SHIPMENT_NUMBER	VARCHAR2	(30)		Intransit shipment identifier
TRANSFER_COST	NUMBER			Transfer cost specified for inter-org transfers
TRANSPORTATION_DIST_ACCOUNT	NUMBER			Transfer transportation distribution account
TRANSPORTATION_COST	NUMBER			Transfer transportation cost
TRANSFER_COST_DIST_ACCOUNT	NUMBER			Transaction transfer cost distribution account
WAYBILL_AIRBILL	VARCHAR2	(30)		Airbill / waybill number
FREIGHT_CODE	VARCHAR2	(30)		Intransit shipment freight code
NUMBER_OF_CONTAINERS	NUMBER			Number of containers
VALUE_CHANGE	NUMBER			Total value change for average cost update
PERCENTAGE_CHANGE	NUMBER			Percentage average cost change for average cost update
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
MOVEMENT_ID	NUMBER			Movement statistics cross reference
TASK_ID	NUMBER	(15)		Task identifier
TO_TASK_ID	NUMBER	(15)		"To" task identifier
PROJECT_ID	NUMBER	(15)		project identifier
TO_PROJECT_ID	NUMBER	(15)		"To" project identifier
SOURCE_PROJECT_ID	NUMBER			Source project identifier
PA_EXPENDITURE_ORG_ID	NUMBER			Oracle Projects related expenditure organization identifier
SOURCE_TASK_ID	NUMBER			Source task identifier
EXPENDITURE_TYPE	VARCHAR2	(30)		Oracle Projects related expenditure type
ERROR_CODE	VARCHAR2	(240)		Error Code
ERROR_EXPLANATION	VARCHAR2	(240)		Error explanation
PRIOR_COSTED_QUANTITY	NUMBER			Costed quantity before this transaction
TRANSFER_PRIOR_COSTED_QUANTITY	NUMBER			Transfer quantity costed before this transaction
FINAL_COMPLETION_FLAG	VARCHAR2	(1)		Indicates if job costs need to be flushed out for this discrete jobcompletion
PM_COST_COLLECTED	VARCHAR2	(1)		Specifies whether the row has been interfaced to Oracle Projects
PM_COST_COLLECTOR_GROUP_ID	NUMBER			Group identifier used by cost collector to process group of records.
SHIPMENT_COSTED	VARCHAR2	(1)		Indicates if the shipment transaction has been processed by the cost worker
TRANSFER_PERCENTAGE	NUMBER			Percentage of value to attribute to transfer costs in an Inter-Orgtransfer
MATERIAL_ACCOUNT	NUMBER			Specifies the material account
MATERIAL_OVERHEAD_ACCOUNT	NUMBER			Specifies the material overhead account
RESOURCE_ACCOUNT	NUMBER			Specifies the resource account
OUTSIDE_PROCESSING_ACCOUNT	NUMBER			Specifies the acount to be charged for outside processing
OVERHEAD_ACCOUNT	NUMBER			Specifies the overhead account
COST_GROUP_ID	NUMBER			Cost group identifier
TRANSFER_COST_GROUP_ID	NUMBER			Transfer cost group identifier
FLOW_SCHEDULE	VARCHAR2	(1)		Specifies whether the WIP transaction is a flow or a schedule type transaction
QA_COLLECTION_ID	NUMBER			Quality Results Identifier
OVERCOMPLETION_TRANSACTION_QTY	NUMBER			Overcompletion transaction quantity
OVERCOMPLETION_PRIMARY_QTY	NUMBER			Overcompletion Primary quantity
OVERCOMPLETION_TRANSACTION_ID	NUMBER			Overcompletion transaction Identifier
MVT_STAT_STATUS	VARCHAR2	(240)		Flag to indicate that the transaction is updated/processed/new
COMMON_BOM_SEQ_ID	NUMBER			BOM identifier of common bill
COMMON_ROUTING_SEQ_ID	NUMBER			Routing identifier of common routing
ORG_COST_GROUP_ID	NUMBER			organization's cost group id
COST_TYPE_ID	NUMBER			cost type id
PERIODIC_PRIMARY_QUANTITY	NUMBER			transaction quantity converted to primary uom of the transfer organization in case of periodic costing
MOVE_ORDER_LINE_ID	NUMBER			The move order line that this transaction line is tied to
TASK_GROUP_ID	NUMBER			Task group identifier for this task
PICK_SLIP_NUMBER	NUMBER			Pick Slip number for the transaction line
LPN_ID	NUMBER			License Plate Number Identifier - used by WMS only
TRANSFER_LPN_ID	NUMBER			Transfer License Plate Number Identifier
PICK_STRATEGY_ID	NUMBER			WMS strategy used for picking
PICK_RULE_ID	NUMBER			WMS rule used for picking
PUT_AWAY_STRATEGY_ID	NUMBER			WMS strategy used for put away
PUT_AWAY_RULE_ID	NUMBER			WMS rule used for put away
CONTENT_LPN_ID	NUMBER			Transfer License Plate Number Identifier - used by WMS only
PICK_SLIP_DATE	DATE			Pick Slip Date
COST_CATEGORY_ID	NUMBER			Cost Category
ORGANIZATION_TYPE	NUMBER			Organization Type. The values are based on MTL_TP_TYPES lookup.
TRANSFER_ORGANIZATION_TYPE	NUMBER			Transfer Organization Type. The values are based on MTL_TP_TYPES lookup.
OWNING_ORGANIZATION_ID	NUMBER			Owning organization identifier
OWNING_TP_TYPE	NUMBER			Owning Trading Partner Type. The values are based on MTL_TP_TYPES lookup.
XFR_OWNING_ORGANIZATION_ID	NUMBER			Transfer owning organization identifier
TRANSFER_OWNING_TP_TYPE	NUMBER			Transfer Owning Trading Partner Type. The values are based on MTL_TP_TYPES lookup.
PLANNING_ORGANIZATION_ID	NUMBER			Planning organization identifier
PLANNING_TP_TYPE	NUMBER			Planning Trading Partner Type. The values are based on MTL_TP_TYPES lookup.
XFR_PLANNING_ORGANIZATION_ID	NUMBER			Transfer planning organization identifier
TRANSFER_PLANNING_TP_TYPE	NUMBER			Transfer Planning Trading Partner Type. The values are based on MTL_TP_TYPES lookup.
SECONDARY_UOM_CODE	VARCHAR2	(3)		Secondary unit of measure that may have been used to do the material transaction
SECONDARY_TRANSACTION_QUANTITY	NUMBER			Secondary quantity
TRANSACTION_GROUP_SEQ	NUMBER
SHIP_TO_LOCATION_ID	NUMBER			Location identifier
RESERVATION_ID	NUMBER			Reservation identifier
TRANSACTION_MODE	NUMBER			Transaction Mode
TRANSACTION_BATCH_ID	NUMBER			Batch ID for Transactions
TRANSACTION_BATCH_SEQ	NUMBER			Batch Sequence for Transactions
INTRANSIT_ACCOUNT	NUMBER			INTRANSIT_ACCOUNT corresponds to INV_INTRANSIT_ACCOUNT from mtl_interorg_parameters
FOB_POINT	NUMBER			FOB_POINT corresponds to FOB_POINT between two Organizations in mtl_interorg_parameters
PARENT_TRANSACTION_ID	NUMBER			Parent Transaction Identifier
LOGICAL_TRX_TYPE_CODE	NUMBER			Logical Transaction Type Identifier
TRX_FLOW_HEADER_ID	NUMBER			Transaction Flow Identifier
LOGICAL_TRANSACTIONS_CREATED	NUMBER			Identifies Deferred Transactions
LOGICAL_TRANSACTION	NUMBER			Logical Transaction Identifier
INTERCOMPANY_COST	NUMBER			Intercompany Cost
INTERCOMPANY_PRICING_OPTION	NUMBER			Intercompany Pricing Option Identifier
INTERCOMPANY_CURRENCY_CODE	VARCHAR2	(15)		The currency code for the intercompany cost
ORIGINAL_TRANSACTION_TEMP_ID	NUMBER			Required for electronic records to keep the original transaction's temp ID
TRANSFER_PRICE	NUMBER			Transfer Price
EXPENSE_ACCOUNT_ID	NUMBER			Expense Account Identifer
COGS_RECOGNITION_PERCENT	NUMBER			Deferred Cogs Percentage
SO_ISSUE_ACCOUNT_TYPE	NUMBER			Deferred Cogs Acount Type
OPM_COSTED_FLAG	VARCHAR2	(1)		Flag to mark if the transaction is costed or not (for Process Organizations)
MATERIAL_EXPENSE_ACCOUNT	NUMBER			Specifies the material expense account
TRANSACTION_EXTRACTED	VARCHAR2	(1)		Flag to indicate that the transaction is extracted
XML_DOCUMENT_ID	NUMBER			XML document identifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INVENTORY_ITEM_ID
,      REVISION
,      ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_NAME
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_QUANTITY
,      TRANSACTION_DATE
,      VARIANCE_AMOUNT
,      ACCT_PERIOD_ID
,      TRANSACTION_REFERENCE
,      REASON_ID
,      DISTRIBUTION_ACCOUNT_ID
,      ENCUMBRANCE_ACCOUNT
,      ENCUMBRANCE_AMOUNT
,      COST_UPDATE_ID
,      COSTED_FLAG
,      TRANSACTION_GROUP_ID
,      INVOICED_FLAG
,      ACTUAL_COST
,      TRANSACTION_COST
,      PRIOR_COST
,      NEW_COST
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      USSGL_TRANSACTION_CODE
,      QUANTITY_ADJUSTED
,      EMPLOYEE_CODE
,      DEPARTMENT_ID
,      OPERATION_SEQ_NUM
,      MASTER_SCHEDULE_UPDATE_CODE
,      RECEIVING_DOCUMENT
,      PICKING_LINE_ID
,      TRX_SOURCE_LINE_ID
,      TRX_SOURCE_DELIVERY_ID
,      REPETITIVE_LINE_ID
,      PHYSICAL_ADJUSTMENT_ID
,      CYCLE_COUNT_ID
,      RMA_LINE_ID
,      TRANSFER_TRANSACTION_ID
,      TRANSACTION_SET_ID
,      RCV_TRANSACTION_ID
,      MOVE_TRANSACTION_ID
,      COMPLETION_TRANSACTION_ID
,      SHORTAGE_PROCESS_CODE
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      VENDOR_LOT_NUMBER
,      TRANSFER_ORGANIZATION_ID
,      TRANSFER_SUBINVENTORY
,      TRANSFER_LOCATOR_ID
,      SHIPMENT_NUMBER
,      TRANSFER_COST
,      TRANSPORTATION_DIST_ACCOUNT
,      TRANSPORTATION_COST
,      TRANSFER_COST_DIST_ACCOUNT
,      WAYBILL_AIRBILL
,      FREIGHT_CODE
,      NUMBER_OF_CONTAINERS
,      VALUE_CHANGE
,      PERCENTAGE_CHANGE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      MOVEMENT_ID
,      TASK_ID
,      TO_TASK_ID
,      PROJECT_ID
,      TO_PROJECT_ID
,      SOURCE_PROJECT_ID
,      PA_EXPENDITURE_ORG_ID
,      SOURCE_TASK_ID
,      EXPENDITURE_TYPE
,      ERROR_CODE
,      ERROR_EXPLANATION
,      PRIOR_COSTED_QUANTITY
,      TRANSFER_PRIOR_COSTED_QUANTITY
,      FINAL_COMPLETION_FLAG
,      PM_COST_COLLECTED
,      PM_COST_COLLECTOR_GROUP_ID
,      SHIPMENT_COSTED
,      TRANSFER_PERCENTAGE
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      OVERHEAD_ACCOUNT
,      COST_GROUP_ID
,      TRANSFER_COST_GROUP_ID
,      FLOW_SCHEDULE
,      QA_COLLECTION_ID
,      OVERCOMPLETION_TRANSACTION_QTY
,      OVERCOMPLETION_PRIMARY_QTY
,      OVERCOMPLETION_TRANSACTION_ID
,      MVT_STAT_STATUS
,      COMMON_BOM_SEQ_ID
,      COMMON_ROUTING_SEQ_ID
,      ORG_COST_GROUP_ID
,      COST_TYPE_ID
,      PERIODIC_PRIMARY_QUANTITY
,      MOVE_ORDER_LINE_ID
,      TASK_GROUP_ID
,      PICK_SLIP_NUMBER
,      LPN_ID
,      TRANSFER_LPN_ID
,      PICK_STRATEGY_ID
,      PICK_RULE_ID
,      PUT_AWAY_STRATEGY_ID
,      PUT_AWAY_RULE_ID
,      CONTENT_LPN_ID
,      PICK_SLIP_DATE
,      COST_CATEGORY_ID
,      ORGANIZATION_TYPE
,      TRANSFER_ORGANIZATION_TYPE
,      OWNING_ORGANIZATION_ID
,      OWNING_TP_TYPE
,      XFR_OWNING_ORGANIZATION_ID
,      TRANSFER_OWNING_TP_TYPE
,      PLANNING_ORGANIZATION_ID
,      PLANNING_TP_TYPE
,      XFR_PLANNING_ORGANIZATION_ID
,      TRANSFER_PLANNING_TP_TYPE
,      SECONDARY_UOM_CODE
,      SECONDARY_TRANSACTION_QUANTITY
,      TRANSACTION_GROUP_SEQ
,      SHIP_TO_LOCATION_ID
,      RESERVATION_ID
,      TRANSACTION_MODE
,      TRANSACTION_BATCH_ID
,      TRANSACTION_BATCH_SEQ
,      INTRANSIT_ACCOUNT
,      FOB_POINT
,      PARENT_TRANSACTION_ID
,      LOGICAL_TRX_TYPE_CODE
,      TRX_FLOW_HEADER_ID
,      LOGICAL_TRANSACTIONS_CREATED
,      LOGICAL_TRANSACTION
,      INTERCOMPANY_COST
,      INTERCOMPANY_PRICING_OPTION
,      INTERCOMPANY_CURRENCY_CODE
,      ORIGINAL_TRANSACTION_TEMP_ID
,      TRANSFER_PRICE
,      EXPENSE_ACCOUNT_ID
,      COGS_RECOGNITION_PERCENT
,      SO_ISSUE_ACCOUNT_TYPE
,      OPM_COSTED_FLAG
,      MATERIAL_EXPENSE_ACCOUNT
,      TRANSACTION_EXTRACTED
,      XML_DOCUMENT_ID
FROM INV.MTL_MATERIAL_TRANSACTIONS;

Dependencies

[top of page]

INV.MTL_MATERIAL_TRANSACTIONS does not reference any database object

INV.MTL_MATERIAL_TRANSACTIONS is referenced by following:

INV: MTL_MATERIAL_TRANSACTIONS#