Mass move items from STAGED to CURRENT subinventories
When SO lines are backordered the items are left in subinv STAGED. I would like to periodically (weekly?) remove all free and unallocated items from STAGED back to CURRENT (where items sit for picking) so they are available for orders.
Is there a way to identify the unreserved/free quantity of all items in STAGED so i can mass change them back to CURRENT without ship confirming all outstanding pick slips?
Many thanks,
JN
We are running DB 10g and Oracle R12