Search 800 + 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.

2 comments:

  1. You have shared wonderful tips about shipping. These are very helpful for those who are looking for shipping logistics. Shipping is the physical moving of good from one point to another. Thanks for sharing such an informative post.
    shipping logistics company in USA

    ReplyDelete
  2. This content is written very well. Your use of formatting when making your points makes your observations very clear and easy to understand. Thank you. Furniture shipping quote

    ReplyDelete