APPS.INVPPROC dependencies on MTL_UOM_CONVERSIONS

Line 36: from mtl_uom_conversions

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

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

1830: */
1831:
1832:
1833: /*
1834: ** Insert a record into mtl_uom_conversions for items with
1835: ** specific UOM (allowed_units_lookup_code = 1)
1836: */
1837:
1838: FOR UOM_process_rec IN UOM_Process LOOP

Line 1845: from mtl_uom_conversions

1841: conversion_rate_temp := 1;
1842: ELSE
1843: select conversion_rate
1844: into conversion_rate_temp
1845: from mtl_uom_conversions
1846: where inventory_item_id = 0
1847: and uom_code = UOM_process_rec.PUOMCODE;
1848: END IF;
1849:

Line 1852: INSERT INTO mtl_uom_conversions

1848: END IF;
1849:
1850: l_default_conversion_flag := 'N';
1851:
1852: INSERT INTO mtl_uom_conversions
1853: (
1854: unit_of_measure,
1855: uom_code,
1856: uom_class,

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

1916: ** This is a major fix to the code.
1917: */
1918:
1919: IF l_inv_debug_level IN(101, 102) THEN
1920: INVPUTLI.info('INVPPROC: Finished inserting in mtl_uom_conversions');
1921: END IF;
1922:
1923:
1924: