DBA Data[Home] [Help]

APPS.PO_UOM_S dependencies on MTL_UOM_CLASS_CONVERSIONS

Line 160: from mtl_uom_class_conversions

156: cursor interclass_conversions(inv_item_flag varchar2) is
157: select decode(to_uom_class, to_class, 1, 2) to_flag,
158: decode(from_uom_class, from_class, 1, to_class, 2, 0) from_flag,
159: conversion_rate rate
160: from mtl_uom_class_conversions
161: where ((inv_item_flag = 'Y' and inventory_item_id = item_id)
162: or
163: (inv_item_flag = 'N' and inventory_item_id = 0))
164: and to_uom_class in (from_class, to_class)

Line 612: from mtl_uom_class_conversions

608: cursor interclass_conversions is
609: select decode(to_uom_class, to_class, 1, 2) to_flag,
610: decode(from_uom_class, from_class, 1, to_class, 2, 0) from_flag,
611: conversion_rate rate
612: from mtl_uom_class_conversions
613: where inventory_item_id = item_id
614: and to_uom_class in (from_class, to_class)
615: and nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate);
616: