APPS.OPI_DBI_REP_UOM_PKG dependencies on OPI_DBI_REP_UOMS

Line 174: FROM opi_dbi_rep_uoms

170:
171:
172: cursor get_rep_uom(p_measure IN varchar2) is
173: SELECT rep_uom_code
174: FROM opi_dbi_rep_uoms
175: WHERE measure_code = p_measure;
176: BEGIN
177:
178: open get_rep_uom(p_measure_code);

Line 208: FROM opi_dbi_rep_uoms rep_uoms,

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

Line 238: FROM opi_dbi_rep_uoms rep_uoms,

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

Line 267: FROM opi_dbi_rep_uoms rep_uoms,

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