DBA Data[Home] [Help]

APPS.GHG_UTILITIES_PKG dependencies on GHG_SOURCES

Line 132: from GHG_SOURCES_ALL xnes,

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

Line 133: --bug 13451779 (sasuren) : changed from GHG_SOURCES to GHG_SOURCES_ALL

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

Line 152: FROM GHG_SOURCES xnes,

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

Line 368: , GHG_SOURCES es

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';