DBA Data[Home] [Help]

APPS.CHV_CUM_PERIODS_S1 dependencies on MTL_UNITS_OF_MEASURE

Line 238: FROM mtl_units_of_measure

234: X_progress := '020';
235:
236: SELECT uom_code
237: INTO X_transaction_uom_code
238: FROM mtl_units_of_measure
239: WHERE unit_of_measure = X_unit_of_measure;
240:
241: X_progress := '030';
242:

Line 246: FROM mtl_units_of_measure

242:
243: --dbms_output.put_line('purchasing unit of meas'||X_purchasing_unit_of_measure);
244: SELECT uom_code
245: INTO X_purchasing_uom_code
246: FROM mtl_units_of_measure
247: WHERE unit_of_measure = X_purchasing_unit_of_measure;
248:
249: --dbms_output.put_line('puom code'||X_purchasing_uom_code);
250:

Line 255: FROM mtl_units_of_measure

251: X_progress := '040';
252:
253: SELECT uom_code
254: INTO X_primary_uom_code
255: FROM mtl_units_of_measure
256: WHERE unit_of_measure = X_primary_unit_of_measure;
257:
258: X_progress := '050';
259:

Line 336: FROM mtl_units_of_measure

332:
333:
334: SELECT uom_code
335: INTO X_purchasing_uom_code
336: FROM mtl_units_of_measure
337: WHERE unit_of_measure = X_purchasing_unit_of_measure;
338:
339: END IF;
340:

Line 402: FROM mtl_units_of_measure

398: -- all corrects to that quantity.
399: X_progress := '090';
400: SELECT uom_code
401: INTO X_transaction_uom_code
402: FROM mtl_units_of_measure
403: WHERE unit_of_measure = X_unit_of_measure;
404:
405: X_progress := '100';
406: SELECT uom_code

Line 408: FROM mtl_units_of_measure

404:
405: X_progress := '100';
406: SELECT uom_code
407: INTO X_primary_uom_code
408: FROM mtl_units_of_measure
409: WHERE unit_of_measure = X_primary_unit_of_measure;
410:
411: X_progress := '110';
412: SELECT uom_code

Line 414: FROM mtl_units_of_measure

410:
411: X_progress := '110';
412: SELECT uom_code
413: INTO X_purchasing_uom_code
414: FROM mtl_units_of_measure
415: WHERE unit_of_measure = X_purchasing_unit_of_measure;
416:
417: --dbms_output.put_line('Get CUM Qty: before uom convert call');
418:

Line 547: FROM mtl_units_of_measure

543:
544:
545: SELECT uom_code
546: INTO X_purchasing_uom_code
547: FROM mtl_units_of_measure
548: WHERE unit_of_measure = X_purchasing_unit_of_measure;
549:
550: END IF;
551: