133: select t.conversion_rate std_to_rate,
134: t.uom_class std_to_class,
135: f.conversion_rate std_from_rate,
136: f.uom_class std_from_class
137: from mtl_uom_conversions t,
138: mtl_uom_conversions f
139: where t.inventory_item_id in (item_id, 0)
140: and t.unit_of_measure = to_unit
141: and nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
134: t.uom_class std_to_class,
135: f.conversion_rate std_from_rate,
136: f.uom_class std_from_class
137: from mtl_uom_conversions t,
138: mtl_uom_conversions f
139: where t.inventory_item_id in (item_id, 0)
140: and t.unit_of_measure = to_unit
141: and nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
142: and f.inventory_item_id in (item_id, 0)
590: select t.conversion_rate std_to_rate,
591: t.uom_class std_to_class,
592: f.conversion_rate std_from_rate,
593: f.uom_class std_from_class
594: from mtl_uom_conversions t,
595: mtl_uom_conversions f
596: where t.inventory_item_id in (item_id, 0)
597: and t.unit_of_measure = to_unit
598: and nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
591: t.uom_class std_to_class,
592: f.conversion_rate std_from_rate,
593: f.uom_class std_from_class
594: from mtl_uom_conversions t,
595: mtl_uom_conversions f
596: where t.inventory_item_id in (item_id, 0)
597: and t.unit_of_measure = to_unit
598: and nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
599: and f.inventory_item_id in (item_id, 0)