Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Wednesday, November 23, 2011

MTL_TXN_REQUEST_LINES

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.

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect