Total Pageviews

June 18, 2016

6/18/2016 09:55:00 AM
ebiztechnics oracle apps training

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).

 
Related Posts Plugin for WordPress, Blogger...