DBA Data[Home] [Help]

APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_UOM_CONVERSIONS

Line 36: from msc_uom_conversions t,

32: select t.conversion_rate std_to_rate,
33: t.uom_class std_to_class,
34: f.conversion_rate std_from_rate,
35: f.uom_class std_from_class
36: from msc_uom_conversions t,
37: msc_uom_conversions f
38: where t.inventory_item_id in (item_id, 0) and
39: t.uom_code = to_unit and
40: nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate) and

Line 37: msc_uom_conversions f

33: t.uom_class std_to_class,
34: f.conversion_rate std_from_rate,
35: f.uom_class std_from_class
36: from msc_uom_conversions t,
37: msc_uom_conversions f
38: where t.inventory_item_id in (item_id, 0) and
39: t.uom_code = to_unit and
40: nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate) and
41: f.inventory_item_id in (item_id, 0) and