Oracle Apps Delete Lock from Serial Number

HI Folks

Below is the query to delete the Lock from the serial number

Sometimes it happen when user unable to find the Serial Number in Transact move Order Status

Cause :- May be the serial number group_mark_id = null , line_mark_id = null, lot_line_mark_id = null, is not Null

Below is the query to Set null for the particular Serial Number

  

update mtl_serial_numbers  msn

   set group_mark_id = null ,

       line_mark_id = null,

       lot_line_mark_id = null,

       last_updated_by = :USER_ID ,

       last_update_date=sysdate

 where current_status = :CURRENT_STATUS

   and serial_number in (:SERIAL_NUMBER )

   and inventory_item_id = :INVENTORY_ITEM_ID

   and not exists (select fm_serial_number

                     from mtl_serial_numbers_temp msnt,

                          mtl_material_transactions_temp mmtt

                    where msnt.fm_serial_number = msn.serial_number

                      and msnt.transaction_temp_id = mmtt.transaction_temp_id

                      and mmtt.organization_id = msn.current_organization_id

                      and mmtt.inventory_item_id = msn.inventory_item_id)

   and not exists  (select fm_serial_number

                      from mtl_serial_numbers_interface  msni,

                           mtl_transactions_interface mti

                     where msni.fm_serial_number = msn.serial_number

                       and msni.transaction_interface_id = mti.transaction_interface_id

                       and mti.inventory_item_id = msn.inventory_item_id

                       and mti.organization_id = msn.current_organization_id)