UOM_CONVERT

Similar to UOMService, Platform provides the UOM_CONVERT function at the database level. Developers can use this in their queries/reports to convert an enumeration from one unit of measure to another. You can optionally provide a comma-separated list of tilde-separated modellevel~id pair as scope.

convert_uom (
    value_chain_id IN Enum_Conversion_Factor.Vc_Id%TYPE, --  Value Chain ID of the instance
    enum_name IN Enum_Conversion_Def.Enumeration_Name%TYPE, -- name of Enumeration
    value_of_uom IN Enum_Conversion_Factor.Factor%TYPE, -- Float value of UOM
    value_uom IN Enum_Conversion_Factor.Measure%TYPE, -- name of valueUOM
    target_uom IN Enum_Conversion_Factor.Measure%TYPE, -- name of targetUOM
    scope_var_arg IN VARCHAR2 DEFAULT NULL -- comma separated scope eg 'Test~1000 , Test1~1001'
)