DBA Data[Home] [Help]

APPS.PO_UOM_S dependencies on MTL_UOM_CLASS_CONVERSIONS

Line 223: from mtl_uom_class_conversions

219: cursor interclass_conversions(inv_item_flag varchar2) is
220: select decode(to_uom_class, to_class, 1, 2) to_flag,
221: decode(from_uom_class, from_class, 1, to_class, 2, 0) from_flag,
222: conversion_rate rate
223: from mtl_uom_class_conversions
224: where ((inv_item_flag = 'Y' and inventory_item_id = item_id)
225: or
226: (inv_item_flag = 'N' and inventory_item_id = 0))
227: and to_uom_class in (from_class, to_class)

Line 690: from mtl_uom_class_conversions

686: cursor interclass_conversions is
687: select decode(to_uom_class, to_class, 1, 2) to_flag,
688: decode(from_uom_class, from_class, 1, to_class, 2, 0) from_flag,
689: conversion_rate rate
690: from mtl_uom_class_conversions
691: where inventory_item_id = item_id
692: and to_uom_class in (from_class, to_class)
693: and nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate);
694: