What is the difference between move order transactions and internal sales order and sub-inventory transfer in oracle apps? |
Both these transactions are used for the movement of items from one subinventory to the other. The difference is that move order generates a pick slip and a subinventory transfer doesn’t.
Move order requires ‘approval’. Also, move orders create allocations. So you can place hold on the material with the intention of picking it up a little later. In subinventory transfer, there is no reservation / allocation.
LOOKUP_TYPE
|
LOOKUP_CODE
|
MEANING
|
DESCRIPTION
|
MOVE_ORDER_TYPE
|
1
|
Requisition
|
Move
Order Requisition
|
MOVE_ORDER_TYPE
|
2
|
Replenishment
|
Move
Order Type created from replenishment
|
MOVE_ORDER_TYPE
|
3
|
Pick
Wave
|
Move
Order Type created for outbound shipping
|
MOVE_ORDER_TYPE
|
4
|
Receipt
|
Move
Order Type for receiving transactions
|
MOVE_ORDER_TYPE
|
5
|
Manufacturing
Component Pick
|
Move
Order Type created from Component Pick Release
|
MOVE_ORDER_TYPE
|
6
|
Put
Away
|
Move order important tables
select * from mtl_txn_request_headers
select * from mtl_txn_request_lines
select * from mtl_system_items_b
select * from mtl_item_locations
1. Create move order:
Quantity: 10
Quantity Delivered: NULL
Quantity Detailed: NULL
Quantity Required: NULL
Line Status: 1 (Incomplete)
2. Approve move order:
Quantity: 10
Quantity Delivered: NULL
Quantity Detailed: NULL
Quantity Required: NULL
Line Status: 3 (Approved)
3. Allocate move order for full quantity:
Quantity: 10
Quantity Delivered: NULL
Quantity Detailed: 10
Quantity Required: NULL
Line Status: 3 (Approved)
4. Transact move order:
Quantity: 10
Quantity Delivered: 10
Quantity Detailed: 10
Quantity Required: NULL
Line Status: 5 (Closed)
NOTE: 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).
select * from mtl_txn_request_lines
select * from mtl_system_items_b
select * from mtl_item_locations
1. Create move order:
Quantity: 10
Quantity Delivered: NULL
Quantity Detailed: NULL
Quantity Required: NULL
Line Status: 1 (Incomplete)
2. Approve move order:
Quantity: 10
Quantity Delivered: NULL
Quantity Detailed: NULL
Quantity Required: NULL
Line Status: 3 (Approved)
3. Allocate move order for full quantity:
Quantity: 10
Quantity Delivered: NULL
Quantity Detailed: 10
Quantity Required: NULL
Line Status: 3 (Approved)
4. Transact move order:
Quantity: 10
Quantity Delivered: 10
Quantity Detailed: 10
Quantity Required: NULL
Line Status: 5 (Closed)
NOTE: 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).
