DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on MTL_UOM_CONVERSIONS

Line 5706: from mtl_uom_conversions

5702: msii.set_process_id = xset_id + 1000000000000)
5703: AND muom.uom_code = msii.primary_uom_code
5704: AND NOT EXISTS
5705: ( select 'x'
5706: from mtl_uom_conversions
5707: where inventory_item_id = msii.inventory_item_id
5708: and uom_code = msii.primary_uom_code
5709: );
5710:

Line 7027: from mtl_uom_conversions

7023: IF ( UOM_process_rec.base_uom_flag = 'Y' ) THEN
7024: conversion_rate_temp := 1;
7025: ELSE
7026: select conversion_rate into conversion_rate_temp
7027: from mtl_uom_conversions
7028: where inventory_item_id = 0
7029: and uom_code = UOM_process_rec.PUOMCODE;
7030: END IF;
7031:

Line 7034: INSERT INTO mtl_uom_conversions(

7030: END IF;
7031:
7032: l_default_conversion_flag := 'N';
7033:
7034: INSERT INTO mtl_uom_conversions(
7035: unit_of_measure,
7036: uom_code,
7037: uom_class,
7038: inventory_item_id,