DBA Data[Home] [Help]

APPS.INV_CONVERT dependencies on MTL_LOT_UOM_CLASS_CONVERSIONS

Line 149: from mtl_lot_uom_class_conversions

145: decode(from_uom_class, from_class, 1, to_class, 2, 0) from_flag,
146: conversion_rate rate
147: from (
148: select from_uom_class, to_uom_class , conversion_rate
149: from mtl_lot_uom_class_conversions
150: where inventory_item_id = item_id
151: and organization_id = p_organization_id
152: and lot_number = p_lot_number
153: and to_uom_class in (from_class, to_class)

Line 164: from mtl_lot_uom_class_conversions mluc

160: and to_uom_class in (from_class, to_class)
161: and nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate)
162: and not exists (
163: select 1
164: from mtl_lot_uom_class_conversions mluc
165: where inventory_item_id = item_id
166: and organization_id = p_organization_id
167: and lot_number = p_lot_number
168: and to_uom_class in (from_class, to_class)