MTL_TXN_REQUEST_LINES

Tag:
Table Number: 
IN.02.02
Table Owner: 
Inventory
Table Or View: 
Table
Important columns: 

LINE_ID : Line identifier
HEADER_ID : Header identifier
LINE_NUMBER : Line number
ORGANIZATION_ID : Organization identifier
INVENTORY_ITEM_ID : Inventory item identifier
FROM_SUBINVENTORY_CODE : From subinventory code
TO_SUBINVENTORY_CODE : To subinventory code
QUANTITY :  Quantity requested
QUANTITY_DELIVERED : Quantity which has been delivered

Description: 

The table MTL_TXN_REQUEST_LINES stores all of the move order lines. The lines are requests to move some quantity of an item from a source location to a destination location or account. Each move order line must be tied to a specific move order header.

When a line is detailed or pick released, the quantity detailed is updated appropriately and transaction lines are created in MTL_MATERIAL_TRANSACTIONS_TEMP. When the transaction lines are transacted, the quantity delivered is updated.

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
All Rights Reserved. Copyright 2008-11 OracleUG.com.