1 Reply Latest reply on Mar 17, 2013 3:12 PM by AlexAnd

    uom conversion

    user9275313
      Dear all,

      I want to use standard procedure or package which convert primary uom into secondary uom, I have checked in material transaction table one column with name

      secondary_transaction_quantity has value after conversion into secondary uom_code for weight.

      I need to know the name of such conversion procedure,funcation or package for R12.1.3.

      Thanks
        • 1. Re: uom conversion
          AlexAnd
          look at
          inv_convert.inv_um_convert
          FUNCTION inv_um_convert(p_item_id       IN NUMBER,
                                  p_from_uom_code IN VARCHAR2,
                                  p_to_uom_code   IN VARCHAR2) RETURN NUMBER
          select inv_convert.inv_um_convert(msi.inventory_item_id,'Kg', msi.primary_uom_code)
          from mtl_system_items_b