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.MTL_LOT_UOM_CONV_PUB dependencies on MTL_UNITS_OF_MEASURE

Line 130: FROM mtl_units_of_measure

126: l_trans_count NUMBER;
127:
128: CURSOR get_uom_code_values (p_uom_code VARCHAR2) IS
129: SELECT unit_of_measure, uom_class
130: FROM mtl_units_of_measure
131: WHERE uom_code = p_uom_code;
132:
133: CURSOR get_unit_of_meas_values (p_unit_of_measure VARCHAR2) IS
134: SELECT uom_code, uom_class

Line 135: FROM mtl_units_of_measure

131: WHERE uom_code = p_uom_code;
132:
133: CURSOR get_unit_of_meas_values (p_unit_of_measure VARCHAR2) IS
134: SELECT uom_code, uom_class
135: FROM mtl_units_of_measure
136: WHERE unit_of_measure = p_unit_of_measure;
137:
138: CURSOR get_uom_class_values (p_uom_class VARCHAR2) IS
139: SELECT unit_of_measure, uom_code

Line 140: FROM mtl_units_of_measure

136: WHERE unit_of_measure = p_unit_of_measure;
137:
138: CURSOR get_uom_class_values (p_uom_class VARCHAR2) IS
139: SELECT unit_of_measure, uom_code
140: FROM mtl_units_of_measure
141: WHERE uom_class = p_uom_class and base_uom_flag = 'Y';
142:
143: l_from_uom_code mtl_units_of_measure.uom_code%TYPE;
144: l_from_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;

Line 143: l_from_uom_code mtl_units_of_measure.uom_code%TYPE;

139: SELECT unit_of_measure, uom_code
140: FROM mtl_units_of_measure
141: WHERE uom_class = p_uom_class and base_uom_flag = 'Y';
142:
143: l_from_uom_code mtl_units_of_measure.uom_code%TYPE;
144: l_from_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
145: l_from_uom_class mtl_units_of_measure.uom_class%TYPE;
146: l_to_uom_code mtl_units_of_measure.uom_code%TYPE;
147: l_to_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;

Line 144: l_from_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;

140: FROM mtl_units_of_measure
141: WHERE uom_class = p_uom_class and base_uom_flag = 'Y';
142:
143: l_from_uom_code mtl_units_of_measure.uom_code%TYPE;
144: l_from_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
145: l_from_uom_class mtl_units_of_measure.uom_class%TYPE;
146: l_to_uom_code mtl_units_of_measure.uom_code%TYPE;
147: l_to_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
148: l_to_uom_class mtl_units_of_measure.uom_class%TYPE;

Line 145: l_from_uom_class mtl_units_of_measure.uom_class%TYPE;

141: WHERE uom_class = p_uom_class and base_uom_flag = 'Y';
142:
143: l_from_uom_code mtl_units_of_measure.uom_code%TYPE;
144: l_from_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
145: l_from_uom_class mtl_units_of_measure.uom_class%TYPE;
146: l_to_uom_code mtl_units_of_measure.uom_code%TYPE;
147: l_to_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
148: l_to_uom_class mtl_units_of_measure.uom_class%TYPE;
149:

Line 146: l_to_uom_code mtl_units_of_measure.uom_code%TYPE;

142:
143: l_from_uom_code mtl_units_of_measure.uom_code%TYPE;
144: l_from_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
145: l_from_uom_class mtl_units_of_measure.uom_class%TYPE;
146: l_to_uom_code mtl_units_of_measure.uom_code%TYPE;
147: l_to_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
148: l_to_uom_class mtl_units_of_measure.uom_class%TYPE;
149:
150:

Line 147: l_to_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;

143: l_from_uom_code mtl_units_of_measure.uom_code%TYPE;
144: l_from_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
145: l_from_uom_class mtl_units_of_measure.uom_class%TYPE;
146: l_to_uom_code mtl_units_of_measure.uom_code%TYPE;
147: l_to_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
148: l_to_uom_class mtl_units_of_measure.uom_class%TYPE;
149:
150:
151: l_return_status VARCHAR2(2);

Line 148: l_to_uom_class mtl_units_of_measure.uom_class%TYPE;

144: l_from_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
145: l_from_uom_class mtl_units_of_measure.uom_class%TYPE;
146: l_to_uom_code mtl_units_of_measure.uom_code%TYPE;
147: l_to_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
148: l_to_uom_class mtl_units_of_measure.uom_class%TYPE;
149:
150:
151: l_return_status VARCHAR2(2);
152: l_msg_count NUMBER;

Line 163: l_from_base_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

159: Joe DiIorio 01/13/2005 BUG#4107431
160: =======================================*/
161:
162:
163: l_from_base_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
164: l_from_base_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
165: l_to_base_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
166: l_to_base_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
167:

Line 164: l_from_base_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

160: =======================================*/
161:
162:
163: l_from_base_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
164: l_from_base_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
165: l_to_base_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
166: l_to_base_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
167:
168:

Line 165: l_to_base_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

161:
162:
163: l_from_base_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
164: l_from_base_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
165: l_to_base_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
166: l_to_base_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
167:
168:
169: /*======================================

Line 166: l_to_base_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

162:
163: l_from_base_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
164: l_from_base_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
165: l_to_base_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
166: l_to_base_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
167:
168:
169: /*======================================
170: Cursor to get base values for a

Line 176: FROM mtl_units_of_measure

172: ======================================*/
173:
174: CURSOR get_base_values (l_uom_class VARCHAR2) IS
175: SELECT unit_of_measure, uom_code
176: FROM mtl_units_of_measure
177: WHERE uom_class = l_uom_class and base_uom_flag = 'Y';
178:
179:
180: l_factor NUMBER;

Line 204: FROM mtl_units_of_measure

200: ======================================*/
201:
202: CURSOR get_item_uom_class IS
203: SELECT uom_class
204: FROM mtl_units_of_measure
205: WHERE uom_code = l_item_uom_code;
206:
207:
208: l_item_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

Line 208: l_item_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

204: FROM mtl_units_of_measure
205: WHERE uom_code = l_item_uom_code;
206:
207:
208: l_item_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
209:
210:
211: l_from_rate NUMBER;
212: