APPS.CHV_INQ_SV2 dependencies on MTL_UNITS_OF_MEASURE

Line 190: FROM mtl_units_of_measure

186: BEGIN
187:
188: SELECT uom_code
189: INTO x_primary_uom_code
190: FROM mtl_units_of_measure
191: WHERE unit_of_measure = x_primary_unit_of_measure;
192:
193: EXCEPTION
194: WHEN NO_DATA_FOUND THEN null;

Line 204: FROM mtl_units_of_measure

200: BEGIN
201:
202: SELECT uom_code
203: INTO x_purchasing_uom_code
204: FROM mtl_units_of_measure
205: WHERE unit_of_measure = p_purchasing_uom;
206:
207: EXCEPTION
208: WHEN NO_DATA_FOUND THEN null;

Line 351: FROM mtl_units_of_measure

347: X_progress := '020';
348:
349: SELECT uom_code
350: INTO X_transaction_uom_code
351: FROM mtl_units_of_measure
352: WHERE unit_of_measure = X_unit_of_measure;
353:
354: X_progress := '030';
355:

Line 359: FROM mtl_units_of_measure

355:
356:
357: SELECT uom_code
358: INTO X_purchasing_uom_code
359: FROM mtl_units_of_measure
360: WHERE unit_of_measure = X_purchasing_unit_of_measure;
361:
362:
363: X_progress := '040';

Line 367: FROM mtl_units_of_measure

363: X_progress := '040';
364:
365: SELECT uom_code
366: INTO X_primary_uom_code
367: FROM mtl_units_of_measure
368: WHERE unit_of_measure = X_primary_unit_of_measure;
369:
370: X_progress := '050';
371:

Line 424: FROM mtl_units_of_measure

420: AND organization_id = X_organization_id;
421:
422: SELECT uom_code
423: INTO X_purchasing_uom_code
424: FROM mtl_units_of_measure
425: WHERE unit_of_measure = X_purchasing_unit_of_measure;
426:
427: END IF;
428:

Line 470: FROM mtl_units_of_measure

466: -- all corrects to that quantity.
467: X_progress := '090';
468: SELECT uom_code
469: INTO X_transaction_uom_code
470: FROM mtl_units_of_measure
471: WHERE unit_of_measure = X_unit_of_measure;
472:
473: X_progress := '100';
474: SELECT uom_code

Line 476: FROM mtl_units_of_measure

472:
473: X_progress := '100';
474: SELECT uom_code
475: INTO X_primary_uom_code
476: FROM mtl_units_of_measure
477: WHERE unit_of_measure = X_primary_unit_of_measure;
478:
479: X_progress := '110';
480: SELECT uom_code

Line 482: FROM mtl_units_of_measure

478:
479: X_progress := '110';
480: SELECT uom_code
481: INTO X_purchasing_uom_code
482: FROM mtl_units_of_measure
483: WHERE unit_of_measure = X_purchasing_unit_of_measure;
484:
485:
486: X_progress := '120';

Line 616: FROM mtl_units_of_measure

612: AND paa2.item_id = x_item_id) ;
613:
614: SELECT uom_code
615: INTO x_primary_uom_code
616: FROM mtl_units_of_measure
617: WHERE unit_of_measure = X_primary_unit_of_measure;
618:
619: SELECT uom_code
620: INTO x_purchasing_uom_code

Line 621: FROM mtl_units_of_measure

617: WHERE unit_of_measure = X_primary_unit_of_measure;
618:
619: SELECT uom_code
620: INTO x_purchasing_uom_code
621: FROM mtl_units_of_measure
622: WHERE unit_of_measure = X_purchasing_unit_of_measure;
623:
624: inv_convert.inv_um_conversion(x_primary_uom_code,
625: x_purchasing_uom_code,