DBA Data[Home] [Help]

APPS.PO_UOM_S dependencies on MTL_UOM_CONVERSIONS

Line 137: from mtl_uom_conversions t,

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)

Line 138: mtl_uom_conversions f

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)

Line 594: from mtl_uom_conversions t,

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)

Line 595: mtl_uom_conversions f

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)