select distinct MSI.SEGMENT1 || ',' 物料编码, MSI.DESCRIPTION 物料名称, MSI.UNIT_WEIGHT 毛重, MSI.WEIGHT_UOM_CODE 毛重单位, MSI.UNIT_VOLUME 净重, MSI.VOLUME_UOM_CODE 净重单位 from MTL_SYSTEM_ITEMS_FVL MSI where MSI.INVENTORY_ITEM_STATUS_CODE = 'Active' and MSI.SEGMENT1 like '82%' --物料编码 --and (MSI.UNIT_WEIGHT is null or MSI.UNIT_VOLUME is null) order by 1
|