DBA Data[Home] [Help]

APPS.GHG_UTILITIES_PKG dependencies on MTL_UOM_CONVERSIONS

Line 74: mtl_uom_conversions muc

70:
71: SELECT muc.conversion_rate
72: INTO v_from_emission_conv_rate
73: FROM mtl_units_of_measure_vl mum1,
74: mtl_uom_conversions muc
75: WHERE mum1.unit_of_measure = v_from_emission_rate_uom
76: AND muc.unit_of_measure = mum1.unit_of_measure;
77:
78: -- Find the emission uom to the base uom conversion.

Line 82: mtl_uom_conversions muc

78: -- Find the emission uom to the base uom conversion.
79: SELECT muc.conversion_rate
80: INTO v_emission_conv_rate
81: FROM mtl_units_of_measure_vl mum1,
82: mtl_uom_conversions muc
83: WHERE mum1.unit_of_measure = x_from_uom
84: AND muc.unit_of_measure = mum1.unit_of_measure;
85:
86: --v_uom_conversion_rate := v_from_emission_conv_rate / v_emission_conv_rate;

Line 169: mtl_uom_conversions muc

165: -- Find the from emission rate uom to the base uom conversion.
166: SELECT muc.conversion_rate
167: INTO v_from_emission_conv_rate
168: FROM mtl_units_of_measure_vl mum1,
169: mtl_uom_conversions muc
170: WHERE mum1.unit_of_measure = v_from_emission_rate_uom
171: AND muc.unit_of_measure = mum1.unit_of_measure;
172:
173: -- Find the emission uom to the base uom conversion.

Line 177: mtl_uom_conversions muc

173: -- Find the emission uom to the base uom conversion.
174: SELECT muc.conversion_rate
175: INTO v_emission_conv_rate
176: FROM mtl_units_of_measure_vl mum1,
177: mtl_uom_conversions muc
178: WHERE mum1.unit_of_measure = x_from_uom
179: AND muc.unit_of_measure = mum1.unit_of_measure;
180:
181: --v_uom_conversion_rate := v_from_emission_conv_rate / v_emission_conv_rate;