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: TableINV.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_MATERIAL_TRANSACTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ACTION_ID
ColumnTRANSACTION_TYPE_ID
ColumnTRANSACTION_SOURCE_TYPE_ID
ColumnTRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ColumnTRANSACTION_DATE
MTL_MATERIAL_TRANSACTIONS_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOSTED_FLAG
ColumnTRANSACTION_GROUP_ID
MTL_MATERIAL_TRANSACTIONS_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_SET_ID
MTL_MATERIAL_TRANSACTIONS_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPM_COST_COLLECTED
ColumnPM_COST_COLLECTOR_GROUP_ID
MTL_MATERIAL_TRANSACTIONS_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPLETION_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ACTION_ID
ColumnTRANSACTION_TYPE_ID
ColumnTRANSACTION_SOURCE_TYPE_ID
ColumnTRANSACTION_DATE
MTL_MATERIAL_TRANSACTIONS_N16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPICK_SLIP_NUMBER
MTL_MATERIAL_TRANSACTIONS_N17 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMOVE_ORDER_LINE_ID
MTL_MATERIAL_TRANSACTIONS_N18 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPICKING_LINE_ID
MTL_MATERIAL_TRANSACTIONS_N19 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRCV_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_SOURCE_ID
ColumnORGANIZATION_ID
ColumnTRANSACTION_DATE
MTL_MATERIAL_TRANSACTIONS_N20 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
MTL_MATERIAL_TRANSACTIONS_N21 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTO_PROJECT_ID
MTL_MATERIAL_TRANSACTIONS_N22 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_PROJECT_ID
MTL_MATERIAL_TRANSACTIONS_N23 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSFER_TRANSACTION_ID
MTL_MATERIAL_TRANSACTIONS_N24 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICED_FLAG
MTL_MATERIAL_TRANSACTIONS_N25 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOPM_COSTED_FLAG
MTL_MATERIAL_TRANSACTIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUBINVENTORY_CODE
ColumnORGANIZATION_ID
ColumnTRANSACTION_DATE
MTL_MATERIAL_TRANSACTIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_LOT_NUMBER
MTL_MATERIAL_TRANSACTIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_DATE
ColumnORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIPMENT_NUMBER
MTL_MATERIAL_TRANSACTIONS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCT_PERIOD_ID
ColumnORGANIZATION_ID
MTL_MATERIAL_TRANSACTIONS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_SOURCE_TYPE_ID
ColumnORGANIZATION_ID
ColumnTRANSACTION_DATE
ColumnTRANSACTION_SOURCE_NAME
MTL_MATERIAL_TRANSACTIONS_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ACTION_ID
ColumnORGANIZATION_ID
ColumnTRANSACTION_TYPE_ID
ColumnTRANSACTION_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 (20)
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 Material Expense Account
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
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:

SchemaAPPS
TriggerJAI_INV_MMT_ARIUD_T1
TriggerJA_AU_LOCAL_ACCOUNTING
SynonymMTL_MATERIAL_TRANSACTIONS