inv_convert.inv_um_convert(item_id => msib.inventory_item_id,
PRECISION => NULL,
from_quantity => SUM(ool.ordered_quantity), --原数量
from_unit => mu.uom_code, --英文名(关联mtl_units_of_measure表)
to_unit => '件',
from_name => mu.unit_of_measure, --中文名
to_name => '件')
所有评论(0)