Search from 700 + Posts

Jul 11, 2014

Tables Used for Move Order in Oracle Shipping Execution

Following are the tables used when Pick release execute the Move Order Transaction in Oracle Shipping 

1. MTL_TXN_REQUEST_HEADERS
This table stores all of the move order headers. The headers contain all information which pertains to entire move orders, including the transaction type of the move order, the move order type, the move order status, and the request number of the move order.

2. MTL_TXN_REQUEST_LINES
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 orderheader.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