Infor WMS: Query Update UOM and Packey

update wmwhse1.Receiptdetail set PACKKEY = (select PACKKEY from wmwhse1.sku where sku.sku = Receiptdetail.SKU ) where RECEIPTKEY = '0000000011'

update wmwhse1.Receiptdetail set UOM = (select  PACKUOM3 from wmwhse1.sku inner join  wmwhse1.PACK on pack.PACKKEY = sku.PACKKEY where sku.sku = Receiptdetail.SKU ) where RECEIPTKEY = '0000000011'

UPdate default RF Receiving

update wmwhse1.SKU set RFDEFAULTUOM = (select  PACKUOM3  from  wmwhse1.PACK  where pack.PACKKEY = sku.PACKKEY )

by KMxTEN