DBA Data[Home] [Help]

APPS.CHV_CUM_PERIODS_S1 dependencies on MTL_UNITS_OF_MEASURE

Line 232: FROM mtl_units_of_measure

228: X_progress := '020';
229:
230: SELECT uom_code
231: INTO X_transaction_uom_code
232: FROM mtl_units_of_measure
233: WHERE unit_of_measure = X_unit_of_measure;
234:
235: X_progress := '030';
236:

Line 240: FROM mtl_units_of_measure

236:
237: --dbms_output.put_line('purchasing unit of meas'||X_purchasing_unit_of_measure);
238: SELECT uom_code
239: INTO X_purchasing_uom_code
240: FROM mtl_units_of_measure
241: WHERE unit_of_measure = X_purchasing_unit_of_measure;
242:
243: --dbms_output.put_line('puom code'||X_purchasing_uom_code);
244:

Line 249: FROM mtl_units_of_measure

245: X_progress := '040';
246:
247: SELECT uom_code
248: INTO X_primary_uom_code
249: FROM mtl_units_of_measure
250: WHERE unit_of_measure = X_primary_unit_of_measure;
251:
252: X_progress := '050';
253:

Line 330: FROM mtl_units_of_measure

326:
327:
328: SELECT uom_code
329: INTO X_purchasing_uom_code
330: FROM mtl_units_of_measure
331: WHERE unit_of_measure = X_purchasing_unit_of_measure;
332:
333: END IF;
334:

Line 396: FROM mtl_units_of_measure

392: -- all corrects to that quantity.
393: X_progress := '090';
394: SELECT uom_code
395: INTO X_transaction_uom_code
396: FROM mtl_units_of_measure
397: WHERE unit_of_measure = X_unit_of_measure;
398:
399: X_progress := '100';
400: SELECT uom_code

Line 402: FROM mtl_units_of_measure

398:
399: X_progress := '100';
400: SELECT uom_code
401: INTO X_primary_uom_code
402: FROM mtl_units_of_measure
403: WHERE unit_of_measure = X_primary_unit_of_measure;
404:
405: X_progress := '110';
406: SELECT uom_code

Line 408: FROM mtl_units_of_measure

404:
405: X_progress := '110';
406: SELECT uom_code
407: INTO X_purchasing_uom_code
408: FROM mtl_units_of_measure
409: WHERE unit_of_measure = X_purchasing_unit_of_measure;
410:
411: --dbms_output.put_line('Get CUM Qty: before uom convert call');
412:

Line 541: FROM mtl_units_of_measure

537:
538:
539: SELECT uom_code
540: INTO X_purchasing_uom_code
541: FROM mtl_units_of_measure
542: WHERE unit_of_measure = X_purchasing_unit_of_measure;
543:
544: END IF;
545: