Oracle Inventory

 Move Order Process

Move order Tables

1) MTL_TXN_REQUEST_HEADERS: Move order headers, this stores the move order number in column (REQUEST_NUMBER).

2) MTL_TXN_REQUEST_LINES: Move order lines, this is the one that drives most queries and status checks for the move order as each line can be transacted individually.

3) MTL_MATERIAL_TRANSACTIONS_TEMP: Pending material transactions table also called the transaction temporary table, this holds allocations that act like reservations on inventory.

How to check whether move order is allocated? 
Quantity Detailed

In the move order lines table (MTL_TXN_REQUEST_LINES), the quantity detailed reflects the allocated quantity for a move order line.

The quantity detailed might be greater than the quantity delivered if a move order is allocated
but not transacted.

What happens when move order is allocated?

When a move order is allocated, a corresponding record is inserted into the pending table (MTL_MATERIAL_TRANSACTIONS_TEMP as well as lot/serial tables if required).  When the move order is transacted, the record moves from the pending table to the history table (MTL_MATERIAL_TRANSACTIONS).

Move order line status codes:

The move order table (MTL_TXN_REQUEST_LINES) provides the status of the move order in the LINE_STATUS column as a numeric.

1 Incomplete
2 Pending Approval
3 Approved
4 Not Approved
5 Closed
6 Canceled
7 Pre Approved
8 Partially Approved
9 Canceled by Source

You can look the status code using the below sql

SELECT lookup_code, substr(meaning, 1, 60) "Meaning"
FROM mfg_lookups
WHERE lookup_type = 'MTL_TXN_REQUEST_STATUS'
ORDER BY lookup_code;