eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHG_UTILITIES_PKG dependencies on MTL_UNITS_OF_MEASURE_VL

Line 55: from mtl_units_of_measure_vl x

51: select x.uom_class,
52: x.base_uom_flag
53: into v_uom_class,
54: v_uom_base
55: from mtl_units_of_measure_vl x
56: where unit_of_measure = x_from_uom;
57:
58:
59:

Line 67: from mtl_units_of_measure_vl

63: END IF;
64:
65: select unit_of_measure
66: into v_from_emission_rate_uom
67: from mtl_units_of_measure_vl
68: where uom_class = v_uom_profile
69: and base_uom_flag = 'Y';
70:
71: SELECT muc.conversion_rate

Line 73: FROM mtl_units_of_measure_vl mum1,

69: and base_uom_flag = 'Y';
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:

Line 81: FROM mtl_units_of_measure_vl mum1,

77:
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:

Line 102: mtl_units_of_measure_vl mum1,

98: mum2.unit_of_measure
99: INTO v_from_emission_rate_uom,
100: v_base_uom
101: FROM GHG_SUPPLIER_FACTORS_V xner,
102: mtl_units_of_measure_vl mum1,
103: mtl_units_of_measure_vl mum2
104: WHERE xner.COMBINATION_OVERRIDE_TYPE = 'Supplier'
105: AND xner.SOURCE_COMBINATION_ID = x_from_emission_source_id
106: AND mum1.unit_of_measure = xner.unit_of_measure

Line 103: mtl_units_of_measure_vl mum2

99: INTO v_from_emission_rate_uom,
100: v_base_uom
101: FROM GHG_SUPPLIER_FACTORS_V xner,
102: mtl_units_of_measure_vl mum1,
103: mtl_units_of_measure_vl mum2
104: WHERE xner.COMBINATION_OVERRIDE_TYPE = 'Supplier'
105: AND xner.SOURCE_COMBINATION_ID = x_from_emission_source_id
106: AND mum1.unit_of_measure = xner.unit_of_measure
107: AND mum2.uom_class = mum1.uom_class

Line 119: mtl_units_of_measure_vl mum1,

115: mum2.unit_of_measure
116: INTO v_from_emission_rate_uom,
117: v_base_uom
118: FROM GHG_ITEM_FACTORS_V xner,
119: mtl_units_of_measure_vl mum1,
120: mtl_units_of_measure_vl mum2
121: WHERE xner.COMBINATION_OVERRIDE_TYPE = 'Item'
122: AND xner.SOURCE_COMBINATION_ID = x_from_emission_source_id
123: AND mum1.unit_of_measure = xner.unit_of_measure

Line 120: mtl_units_of_measure_vl mum2

116: INTO v_from_emission_rate_uom,
117: v_base_uom
118: FROM GHG_ITEM_FACTORS_V xner,
119: mtl_units_of_measure_vl mum1,
120: mtl_units_of_measure_vl mum2
121: WHERE xner.COMBINATION_OVERRIDE_TYPE = 'Item'
122: AND xner.SOURCE_COMBINATION_ID = x_from_emission_source_id
123: AND mum1.unit_of_measure = xner.unit_of_measure
124: AND mum2.uom_class = mum1.uom_class

Line 135: mtl_units_of_measure_vl mum1,

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
138: and xnes.ghg_uom_class_code = class.ghg_uom_class_code
139: and mum1.unit_of_measure = class.STANDARD_UOM

Line 136: mtl_units_of_measure_vl mum2

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
138: and xnes.ghg_uom_class_code = class.ghg_uom_class_code
139: and mum1.unit_of_measure = class.STANDARD_UOM
140: and mum2.unit_of_measure = x_from_uom

Line 153: mtl_units_of_measure_vl mum1,

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
157: AND mum2.uom_class = mum1.uom_class

Line 154: mtl_units_of_measure_vl mum2

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
157: AND mum2.uom_class = mum1.uom_class
158: AND mum2.base_uom_flag = 'Y';

Line 168: FROM mtl_units_of_measure_vl mum1,

164:
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:

Line 176: FROM mtl_units_of_measure_vl mum1,

172:
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: