DBA Data[Home] [Help]

APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_UOM_CLASS_CONVERSIONS

Line 54: from msc_uom_class_conversions

50: CURSOR interclass_conversions(p_from_class VARCHAR2, p_to_class VARCHAR2) IS
51: select decode(from_uom_class, p_from_class, 1, 2) from_flag,
52: decode(to_uom_class, p_to_class, 1, 2) to_flag,
53: conversion_rate rate
54: from msc_uom_class_conversions
55: where inventory_item_id = item_id and
56: nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate) and
57: ( (from_uom_class = p_from_class and to_uom_class = p_to_class) or
58: (from_uom_class = p_to_class and to_uom_class = p_from_class) );