APPS.INVPPROC dependencies on MTL_UOM_CONVERSIONS

Line 35: from mtl_uom_conversions

31: AND msii.set_process_id = xset_id
32: AND muom.uom_code = msii.primary_uom_code
33: AND NOT EXISTS
34: ( select 'x'
35: from mtl_uom_conversions
36: where inventory_item_id = msii.inventory_item_id
37: and uom_code = msii.primary_uom_code
38: );
39:

Line 1748: ** Insert a record into mtl_uom_conversions for items with

1744: */
1745:
1746:
1747: /*
1748: ** Insert a record into mtl_uom_conversions for items with
1749: ** specific UOM (allowed_units_lookup_code = 1)
1750: */
1751:
1752: FOR UOM_process_rec IN UOM_Process LOOP

Line 1759: from mtl_uom_conversions

1755: conversion_rate_temp := 1;
1756: ELSE
1757: select conversion_rate
1758: into conversion_rate_temp
1759: from mtl_uom_conversions
1760: where inventory_item_id = 0
1761: and uom_code = UOM_process_rec.PUOMCODE;
1762: END IF;
1763:

Line 1766: INSERT INTO mtl_uom_conversions

1762: END IF;
1763:
1764: l_default_conversion_flag := 'N';
1765:
1766: INSERT INTO mtl_uom_conversions
1767: (
1768: unit_of_measure,
1769: uom_code,
1770: uom_class,

Line 1834: INVPUTLI.info('INVPPROC: Finished inserting in mtl_uom_conversions');

1830: ** This is a major fix to the code.
1831: */
1832:
1833: IF l_inv_debug_level IN(101, 102) THEN
1834: INVPUTLI.info('INVPPROC: Finished inserting in mtl_uom_conversions');
1835: END IF;
1836:
1837:
1838: