UPDATE [dbo].[agv_loc_mast] SET loc_sts = 'X' WHERE loc_type1 = 6