DBA Data[Home] [Help]

APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSC_UOM_CONVERSIONS

Line 21: from msc_uom_conversions t,

17: select t.conversion_rate std_to_rate,
18: t.uom_class std_to_class,
19: f.conversion_rate std_from_rate,
20: f.uom_class std_from_class
21: from msc_uom_conversions t,
22: msc_uom_conversions f
23: where t.inventory_item_id in (item_id, 0) and
24: t.uom_code = to_unit and
25: nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate) and

Line 22: msc_uom_conversions f

18: t.uom_class std_to_class,
19: f.conversion_rate std_from_rate,
20: f.uom_class std_from_class
21: from msc_uom_conversions t,
22: msc_uom_conversions f
23: where t.inventory_item_id in (item_id, 0) and
24: t.uom_code = to_unit and
25: nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate) and
26: f.inventory_item_id in (item_id, 0) and