128: select mum1.unit_of_measure,
129: mum2.unit_of_measure
130: INTO v_from_emission_rate_uom,
131: v_base_uom
132: from GHG_SOURCES_ALL xnes,
133: --bug 13451779 (sasuren) : changed from GHG_SOURCES to GHG_SOURCES_ALL
134: GHG_UOM_CLASSES class,
135: mtl_units_of_measure_vl mum1,
136: mtl_units_of_measure_vl mum2
129: mum2.unit_of_measure
130: INTO v_from_emission_rate_uom,
131: v_base_uom
132: from GHG_SOURCES_ALL xnes,
133: --bug 13451779 (sasuren) : changed from GHG_SOURCES to GHG_SOURCES_ALL
134: GHG_UOM_CLASSES class,
135: mtl_units_of_measure_vl mum1,
136: mtl_units_of_measure_vl mum2
137: where xnes.source_id = x_from_emission_source_id
148: SELECT xnes.unit_of_measure,
149: mum2.unit_of_measure
150: INTO v_from_emission_rate_uom,
151: v_base_uom
152: FROM GHG_SOURCES xnes,
153: mtl_units_of_measure_vl mum1,
154: mtl_units_of_measure_vl mum2
155: WHERE xnes.source_id = x_from_emission_source_id
156: AND mum1.unit_of_measure = xnes.unit_of_measure
364: BEGIN
365: SELECT SOURCE_NAME
366: INTO vl_emission_source
367: FROM GHG_SUPPLIER_ITEMS sd
368: , GHG_SOURCES es
369: WHERE es.source_id = sd.source_id
370: AND sd.supplier_id = x_supplier_id
371: AND sd.supplier_site_id = x_supplier_site_id
372: AND es.enabled= 'Y';