Delete Orphan Reservation Transactions in oracle inventory

 delete

from    mtl_reservations mr 

where   lot_number is not null

and     exists (

            select  1

            from    oe_order_lines_all oola

            where oola.line_id = mr.demand_source_line_id

            and     shipped_quantity = ordered_quantity

        )

;    

Commit;