APPS.INV_EBI_ITEM_HELPER dependencies on MTL_UOM_CONVERSIONS

Line 702: for l_list1_uom_rec in (select conversion_rate,UOM_CODE from MTL_UOM_CONVERSIONS where UOM_CLASS = l_class1 and inventory_item_id= 0)

698: l_convrate_from_unit_to_bu :=1;
699: else
700: inv_convert.inv_um_conversion(uom_conv_details(j).to_uom,l_baseunit1,p_item_id,l_convrate_from_unit_to_bu);
701: if(l_convrate_from_unit_to_bu = -99999) then
702: for l_list1_uom_rec in (select conversion_rate,UOM_CODE from MTL_UOM_CONVERSIONS where UOM_CLASS = l_class1 and inventory_item_id= 0)
703: loop
704: for i in 1..uom_conv_details.count loop
705: uom_from_v_list1_uom_cur := l_list1_uom_rec.UOM_CODE;
706: if(uom_conv_details(i).from_uom = uom_from_v_list1_uom_cur) then

Line 735: for l_list2_uom_rec in (select conversion_rate,UOM_CODE from MTL_UOM_CONVERSIONS where UOM_CLASS = l_class2 and inventory_item_id= 0) loop

731: /*Next calls step-3 */
732: else
733: inv_convert.inv_um_conversion(l_baseunit2,l_baseunit1,p_item_id,l_conv_rate_from_bu2_to_bu1 );
734: if(l_conv_rate_from_bu2_to_bu1 = -99999) then
735: for l_list2_uom_rec in (select conversion_rate,UOM_CODE from MTL_UOM_CONVERSIONS where UOM_CLASS = l_class2 and inventory_item_id= 0) loop
736: for l in 1..uom_conv_details.Count loop
737: uom_from_v_list2_uom_cur := l_list2_uom_rec.UOM_CODE;
738: if(uom_conv_details(l).from_uom = uom_from_v_list2_uom_cur) then
739: l_conv_rate_from_mu1_to_unit := uom_conv_details(l).conversion_rate;