Oracle EBS Application

  Select * from mtl_transaction_lots_temp where TRANSACTION_TEMP_ID in (1095168787); Delete from mtl_transaction_lots_temp where TRANSACTION_TEMP_ID in (1095168787); select * from mtl_material_transactions_temp where TRANSACTION_TEMP_ID in (1095168787); Delete from mtl_material_transactions_temp where TRANSACTION_TEMP_ID in (1095168787); Commit;

 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;