DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on MTL_UOM_CONVERSIONS

Line 4991: FROM MTL_UOM_CONVERSIONS

4987: AND px_attr_value_obj.ATTR_UNIT_OF_MEASURE <> p_attr_metadata_obj.UNIT_OF_MEASURE_BASE ) THEN
4988: BEGIN
4989: SELECT CONVERSION_RATE
4990: INTO l_conv_rate
4991: FROM MTL_UOM_CONVERSIONS
4992: WHERE UOM_CLASS = p_attr_metadata_obj.UNIT_OF_MEASURE_CLASS
4993: AND UOM_CODE = px_attr_value_obj.ATTR_UNIT_OF_MEASURE
4994: AND ROWNUM = 1;
4995: Debug_Msg('In Disp_Val_Replacement_Is_Bad UOM conversion rate is ' || to_char(l_conv_rate));

Line 12100: FROM MTL_UOM_CONVERSIONS

12096: l_conv_rate := 1;
12097:
12098: SELECT CONVERSION_RATE
12099: INTO l_conv_rate
12100: FROM MTL_UOM_CONVERSIONS
12101: WHERE UOM_CLASS = l_new_attr_metadata_obj.UNIT_OF_MEASURE_CLASS
12102: AND UOM_CODE = NVL(l_uom_value, l_new_attr_metadata_obj.UNIT_OF_MEASURE_BASE)
12103: AND ROWNUM = 1;
12104: