Aligning Bin Storage Type With ULD Status

To align the bin storage type with the ULD status, using the following:

Copy 
UPDATE ULD

INNER JOIN ULDB ON ULDB.ULDID = ULD.ULDID

INNER JOIN BIN ON BIN.BinID = ULDB.BinID

SET ULD.Status = BIN.StorageType

WHERE ULD.InstanceID = :InstanceID AND ULD.WarehouseID = :WarehouseID AND ULD.Status != 
BIN.StorageType AND ULD.Status IN ('Picking','Bulk')