DBA Data[Home] [Help]

APPS.MSD_SR_UTIL dependencies on MTL_UOM_CONVERSIONS

Line 144: from mtl_uom_conversions t

140: l_master_uom varchar2(3);
141:
142: cursor base_uom_code_conversion(p_item_id number, p_uom_code varchar2) is
143: select t.conversion_rate std_conv_rate
144: from mtl_uom_conversions t
145: where t.inventory_item_id in (p_item_id, 0)
146: and t.uom_code= p_uom_code
147: and nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
148: and t.conversion_rate is not null