576: select t.conversion_rate std_to_rate,
577: t.uom_class std_to_class,
578: f.conversion_rate std_from_rate,
579: f.uom_class std_from_class
580: from msc_uom_conversions t,
581: msc_uom_conversions f
582: where t.inventory_item_id in (item_id, 0) and
583: t.uom_code = to_unit and
584: nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate) and
577: t.uom_class std_to_class,
578: f.conversion_rate std_from_rate,
579: f.uom_class std_from_class
580: from msc_uom_conversions t,
581: msc_uom_conversions f
582: where t.inventory_item_id in (item_id, 0) and
583: t.uom_code = to_unit and
584: nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate) and
585: f.inventory_item_id in (item_id, 0) and