DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on MTL_UOM_CONVERSIONS

Line 5460: from mtl_uom_conversions

5456: msii.set_process_id = xset_id + 1000000000000)
5457: AND muom.uom_code = msii.primary_uom_code
5458: AND NOT EXISTS
5459: ( select 'x'
5460: from mtl_uom_conversions
5461: where inventory_item_id = msii.inventory_item_id
5462: and uom_code = msii.primary_uom_code
5463: );
5464:

Line 6593: from mtl_uom_conversions

6589: IF ( UOM_process_rec.base_uom_flag = 'Y' ) THEN
6590: conversion_rate_temp := 1;
6591: ELSE
6592: select conversion_rate into conversion_rate_temp
6593: from mtl_uom_conversions
6594: where inventory_item_id = 0
6595: and uom_code = UOM_process_rec.PUOMCODE;
6596: END IF;
6597:

Line 6600: INSERT INTO mtl_uom_conversions(

6596: END IF;
6597:
6598: l_default_conversion_flag := 'N';
6599:
6600: INSERT INTO mtl_uom_conversions(
6601: unit_of_measure,
6602: uom_code,
6603: uom_class,
6604: inventory_item_id,