115: --Bug# 1347733
116: --togeorge 12/05/2000
117: --Switched the first two arguments in the call to the procedure po_uom_convert.
118: --This is done to avoid inaccurate value after conversion.
119: --SELECT round(po_uom_s.po_uom_convert(msi.primary_unit_of_measure, x_uom, x_item_id),10)
120: SELECT round(po_uom_s.po_uom_convert(x_uom, msi.primary_unit_of_measure, x_item_id),10)
121: INTO x_uom_conversion_temp
122: FROM mtl_system_items msi
123: WHERE msi.inventory_item_id = x_item_id
116: --togeorge 12/05/2000
117: --Switched the first two arguments in the call to the procedure po_uom_convert.
118: --This is done to avoid inaccurate value after conversion.
119: --SELECT round(po_uom_s.po_uom_convert(msi.primary_unit_of_measure, x_uom, x_item_id),10)
120: SELECT round(po_uom_s.po_uom_convert(x_uom, msi.primary_unit_of_measure, x_item_id),10)
121: INTO x_uom_conversion_temp
122: FROM mtl_system_items msi
123: WHERE msi.inventory_item_id = x_item_id
124: AND x_inventory_org_id = msi.organization_id