APPS.OPI_DBI_REP_UOM_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 35: FROM mtl_units_of_measure

31:
32:
33: cursor get_uom_class(p_code IN varchar2) is
34: SELECT uom_class
35: FROM mtl_units_of_measure
36: WHERE uom_code = p_code
37: AND rownum < 2;
38:
39:

Line 42: FROM mtl_units_of_measure

38:
39:
40: cursor base_uom_code(p_class IN varchar2) is
41: SELECT uom_code
42: FROM mtl_units_of_measure
43: WHERE uom_class = p_class
44: AND base_uom_flag = 'Y'
45: AND rownum < 2;
46:

Line 209: mtl_units_of_measure_vl uoms

205:
206: cursor get_rep_uom is
207: SELECT uoms.unit_of_measure_tl
208: FROM opi_dbi_rep_uoms rep_uoms,
209: mtl_units_of_measure_vl uoms
210: WHERE rep_uoms.measure_code = 'WT'
211: AND rep_uoms.rep_uom_code = uoms.uom_code;
212: BEGIN
213:

Line 239: mtl_units_of_measure_vl uoms

235:
236: cursor get_rep_uom is
237: SELECT uoms.unit_of_measure_tl
238: FROM opi_dbi_rep_uoms rep_uoms,
239: mtl_units_of_measure_vl uoms
240: WHERE rep_uoms.measure_code = 'VOL'
241: AND rep_uoms.rep_uom_code = uoms.uom_code;
242: BEGIN
243:

Line 268: mtl_units_of_measure_vl uoms

264:
265: cursor get_rep_uom is
266: SELECT uoms.unit_of_measure_tl
267: FROM opi_dbi_rep_uoms rep_uoms,
268: mtl_units_of_measure_vl uoms
269: WHERE rep_uoms.measure_code = 'DIS'
270: AND rep_uoms.rep_uom_code = uoms.uom_code;
271: BEGIN
272:

Line 362: FROM mtl_units_of_measure_vl

358: l_to_class varchar2(10);
359:
360: cursor uom_info(p_code IN varchar2) is
361: SELECT unit_of_measure_tl, uom_class
362: FROM mtl_units_of_measure_vl
363: WHERE uom_code = p_code
364: AND rownum < 2;
365:
366: uom_info_rec uom_info%rowtype;