DBA Data[Home] [Help]

APPS.MSD_DEM_SR_UTIL dependencies on MTL_UOM_CONVERSIONS

Line 210: from mtl_uom_conversions t

206: l_master_uom varchar2(3);
207:
208: cursor base_uom_code_conversion(p_item_id number, p_uom_code varchar2) is
209: select t.conversion_rate std_conv_rate
210: from mtl_uom_conversions t
211: where t.inventory_item_id in (p_item_id, 0)
212: and t.uom_code= p_uom_code
213: and nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
214: and t.conversion_rate is not null