DBA Data[Home] [Help]

APPS.PO_UOM_S dependencies on MTL_UOM_CONVERSIONS

Line 200: from mtl_uom_conversions t,

196: select t.conversion_rate std_to_rate,
197: t.uom_class std_to_class,
198: f.conversion_rate std_from_rate,
199: f.uom_class std_from_class
200: from mtl_uom_conversions t,
201: mtl_uom_conversions f
202: where t.inventory_item_id in (item_id, 0)
203: and t.unit_of_measure = to_unit
204: and nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)

Line 201: mtl_uom_conversions f

197: t.uom_class std_to_class,
198: f.conversion_rate std_from_rate,
199: f.uom_class std_from_class
200: from mtl_uom_conversions t,
201: mtl_uom_conversions f
202: where t.inventory_item_id in (item_id, 0)
203: and t.unit_of_measure = to_unit
204: and nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
205: and f.inventory_item_id in (item_id, 0)

Line 672: from mtl_uom_conversions t,

668: select t.conversion_rate std_to_rate,
669: t.uom_class std_to_class,
670: f.conversion_rate std_from_rate,
671: f.uom_class std_from_class
672: from mtl_uom_conversions t,
673: mtl_uom_conversions f
674: where t.inventory_item_id in (item_id, 0)
675: and t.unit_of_measure = to_unit
676: and nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)

Line 673: mtl_uom_conversions f

669: t.uom_class std_to_class,
670: f.conversion_rate std_from_rate,
671: f.uom_class std_from_class
672: from mtl_uom_conversions t,
673: mtl_uom_conversions f
674: where t.inventory_item_id in (item_id, 0)
675: and t.unit_of_measure = to_unit
676: and nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
677: and f.inventory_item_id in (item_id, 0)