Showing posts with label WMS Transactions. Show all posts
Showing posts with label WMS Transactions. Show all posts

Oracle Apps Inventory period closure monitoring scripts

To check if there is any unprocessed material
select transaction_header_id                Txn_hdr_id,
       mmtt.transaction_temp_id             Txn_tmp_id,
       mmtt.inventory_item_id               Inv_Item_id,
       revision                             Rev,
       subinventory_code                    Subinv_code,