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,