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,

       locator_id                           Loc_id,

       mtlt.LOT_NUMBER                      Lot_Number,

       msnt.fm_serial_number                FmSerial_Num,