DBA Data[Home] [Help]

APPS.OPI_DBI_REP_UOM_PKG dependencies on MTL_UNITS_OF_MEASURE_VL

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;