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 132: FROM mtl_units_of_measure

128: l_action_type VARCHAR2(10); --bug#12566380
129:
130: CURSOR get_uom_code_values (p_uom_code VARCHAR2) IS
131: SELECT unit_of_measure, uom_class
132: FROM mtl_units_of_measure
133: WHERE uom_code = p_uom_code;
134:
135: CURSOR get_unit_of_meas_values (p_unit_of_measure VARCHAR2) IS
136: SELECT uom_code, uom_class

Line 137: FROM mtl_units_of_measure

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

Line 142: FROM mtl_units_of_measure

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

Line 145: l_from_uom_code mtl_units_of_measure.uom_code%TYPE;

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

Line 146: l_from_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;

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

Line 147: l_from_uom_class mtl_units_of_measure.uom_class%TYPE;

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

Line 148: l_to_uom_code mtl_units_of_measure.uom_code%TYPE;

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

Line 149: l_to_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;

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

Line 150: l_to_uom_class mtl_units_of_measure.uom_class%TYPE;

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

Line 165: l_from_base_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

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

Line 166: l_from_base_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

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

Line 167: l_to_base_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

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

Line 168: l_to_base_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

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

Line 178: FROM mtl_units_of_measure

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

Line 206: FROM mtl_units_of_measure

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

Line 210: l_item_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

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