DBA Data[Home] [Help]

APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_UOM_CLASS_CONVERSIONS

Line 39: from msc_uom_class_conversions

35: CURSOR interclass_conversions(p_from_class VARCHAR2, p_to_class VARCHAR2) IS
36: select decode(from_uom_class, p_from_class, 1, 2) from_flag,
37: decode(to_uom_class, p_to_class, 1, 2) to_flag,
38: conversion_rate rate
39: from msc_uom_class_conversions
40: where inventory_item_id = item_id and
41: nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate) and
42: ( (from_uom_class = p_from_class and to_uom_class = p_to_class) or
43: (from_uom_class = p_to_class and to_uom_class = p_from_class) );