DBA Data[Home] [Help]

APPS.POA_EDW_UTIL dependencies on MTL_UOM_CLASS_CONVERSIONS

Line 47: from mtl_uom_class_conversions

43: cursor interclass_conversions is
44: select decode(to_uom_class, to_class, 1, 2) to_flag,
45: decode(from_uom_class, from_class, 1, to_class, 2, 0) from_flag,
46: conversion_rate rate
47: from mtl_uom_class_conversions
48: where inventory_item_id = item_id
49: and to_uom_class in (from_class, to_class)
50: and nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate);
51: