R12 UOM Conversion of units using Function
Get the Conversion rate from below function easily.
FUNCTION inv_um_convert (p_item_id IN NUMBER,
p_from_uom_code IN VARCHAR2,
p_to_uom_code IN VARCHAR2) RETURN NUMBER;
select msi.segment1,
msi.primary_uom_code,
‘Kg’ as second_uom,
inv_convert.inv_um_convert (msi.inventory_item_id, ‘kg’
msi.primary_uom_code) as coefficient from mtl_system_items_b
where msi.segment1 = ‘OEAG01-ITEM’;
Leave a Reply
Want to join the discussion?Feel free to contribute!