DBA Data[Home] [Help]

APPS.MSD_COMMON_UTILITIES dependencies on MSC_UOM_CLASS_CONVERSIONS

Line 598: from msc_uom_class_conversions

594: CURSOR interclass_conversions(p_from_class VARCHAR2, p_to_class VARCHAR2) IS
595: select decode(from_uom_class, p_from_class, 1, 2) from_flag,
596: decode(to_uom_class, p_to_class, 1, 2) to_flag,
597: conversion_rate rate
598: from msc_uom_class_conversions
599: where inventory_item_id = item_id and
600: nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate) and
601: ( (from_uom_class = p_from_class and to_uom_class = p_to_class) or
602: (from_uom_class = p_to_class and to_uom_class = p_from_class) );