eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_EBI_ITEM_HELPER dependencies on INV_CONVERT

Line 700: inv_convert.inv_um_conversion(uom_conv_details(j).to_uom,l_baseunit1,p_item_id,l_convrate_from_unit_to_bu);

696: select UOM_CODE into l_baseunit1 from MTL_UNITS_OF_MEASURE where UOM_CLASS=l_class1 and BASE_UOM_FLAG='Y';
697: if(l_baseunit1 = uom_conv_details(j).to_uom) then
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

Line 708: inv_convert.inv_um_conversion(uom_conv_details(i).from_uom,l_baseunit1,p_item_id,l_convrate_from_mu_to_bu);

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
707: l_conv_rate_from_mu_to_unit :=uom_conv_details(i).conversion_rate;
708: inv_convert.inv_um_conversion(uom_conv_details(i).from_uom,l_baseunit1,p_item_id,l_convrate_from_mu_to_bu);
709: l_convrate_from_unit_to_bu :=l_convrate_from_mu_to_bu/l_conv_rate_from_mu_to_unit;
710: inv_convert.create_uom_conversion(l_baseunit1,uom_conv_details(i).to_uom,p_item_id,(1/l_convrate_from_unit_to_bu),l_ret);
711: flag := 1;
712: end if;

Line 710: inv_convert.create_uom_conversion(l_baseunit1,uom_conv_details(i).to_uom,p_item_id,(1/l_convrate_from_unit_to_bu),l_ret);

706: if(uom_conv_details(i).from_uom = uom_from_v_list1_uom_cur) then
707: l_conv_rate_from_mu_to_unit :=uom_conv_details(i).conversion_rate;
708: inv_convert.inv_um_conversion(uom_conv_details(i).from_uom,l_baseunit1,p_item_id,l_convrate_from_mu_to_bu);
709: l_convrate_from_unit_to_bu :=l_convrate_from_mu_to_bu/l_conv_rate_from_mu_to_unit;
710: inv_convert.create_uom_conversion(l_baseunit1,uom_conv_details(i).to_uom,p_item_id,(1/l_convrate_from_unit_to_bu),l_ret);
711: flag := 1;
712: end if;
713: end loop;
714: end loop;

Line 717: inv_convert.create_uom_conversion(l_baseunit1,uom_conv_details(j).to_uom,p_item_id,l_convrate_from_unit_to_bu,l_ret);

713: end loop;
714: end loop;
715: if(flag <> 1) then
716: l_convrate_from_unit_to_bu :=1;
717: inv_convert.create_uom_conversion(l_baseunit1,uom_conv_details(j).to_uom,p_item_id,l_convrate_from_unit_to_bu,l_ret);
718: end if;
719: end if;
720: if (l_ret <> FND_API.g_ret_sts_success) then
721: x_return_status := FND_API.G_RET_STS_ERROR;

Line 733: inv_convert.inv_um_conversion(l_baseunit2,l_baseunit1,p_item_id,l_conv_rate_from_bu2_to_bu1 );

729: l_baseunit2:= l_baseunit1 ;
730: l_conv_rate_from_bu2_to_bu1 :=1;
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;

Line 740: inv_convert.inv_um_conversion(uom_conv_details(l).from_uom,l_baseunit2,p_item_id,l_conv_rate_from_mu1_to_bu2);

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;
740: inv_convert.inv_um_conversion(uom_conv_details(l).from_uom,l_baseunit2,p_item_id,l_conv_rate_from_mu1_to_bu2);
741: l_conv_rate_from_bu2_to_bu1 := (l_conv_rate_from_mu1_to_unit * l_convrate_from_unit_to_bu )/l_conv_rate_from_mu1_to_bu2;
742: inv_convert.create_uom_conversion(l_baseunit1,l_baseunit2,p_item_id,l_conv_rate_from_bu2_to_bu1,l_ret);
743: flag1 :=1;
744: /*Next calls step-3 */

Line 742: inv_convert.create_uom_conversion(l_baseunit1,l_baseunit2,p_item_id,l_conv_rate_from_bu2_to_bu1,l_ret);

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;
740: inv_convert.inv_um_conversion(uom_conv_details(l).from_uom,l_baseunit2,p_item_id,l_conv_rate_from_mu1_to_bu2);
741: l_conv_rate_from_bu2_to_bu1 := (l_conv_rate_from_mu1_to_unit * l_convrate_from_unit_to_bu )/l_conv_rate_from_mu1_to_bu2;
742: inv_convert.create_uom_conversion(l_baseunit1,l_baseunit2,p_item_id,l_conv_rate_from_bu2_to_bu1,l_ret);
743: flag1 :=1;
744: /*Next calls step-3 */
745: end if ;
746: end loop;

Line 750: inv_convert.create_uom_conversion(l_baseunit1,l_baseunit2,p_item_id,l_conv_rate_from_bu2_to_bu1,l_ret);

746: end loop;
747: end loop;
748: if(flag1 <> 1) then
749: l_conv_rate_from_bu2_to_bu1 :=1;
750: inv_convert.create_uom_conversion(l_baseunit1,l_baseunit2,p_item_id,l_conv_rate_from_bu2_to_bu1,l_ret);
751: end if;
752: end if;
753: if (l_ret <> FND_API.g_ret_sts_success) then
754: x_return_status := FND_API.G_RET_STS_ERROR;

Line 771: inv_convert.inv_um_conversion(uom_conv_details(j).from_uom,l_baseunit2,p_item_id,l_conv_rate_from_unit1_to_bu1);

767: FND_MSG_PUB.add;
768: RAISE fnd_api.g_exc_unexpected_error;
769: end if;
770: else
771: inv_convert.inv_um_conversion(uom_conv_details(j).from_uom,l_baseunit2,p_item_id,l_conv_rate_from_unit1_to_bu1);
772: if(l_conv_rate_from_unit1_to_bu1 = -99999) then
773: l_conv_rate_from_unit1_to_bu1 := ((uom_conv_details(j).conversion_rate) * l_convrate_from_unit_to_bu)/l_conv_rate_from_bu2_to_bu1;
774: inv_convert.create_uom_conversion(l_baseunit2,uom_conv_details(j).from_uom,p_item_id,l_conv_rate_from_unit1_to_bu1,l_ret);
775: if (l_ret <> FND_API.g_ret_sts_success) then

Line 774: inv_convert.create_uom_conversion(l_baseunit2,uom_conv_details(j).from_uom,p_item_id,l_conv_rate_from_unit1_to_bu1,l_ret);

770: else
771: inv_convert.inv_um_conversion(uom_conv_details(j).from_uom,l_baseunit2,p_item_id,l_conv_rate_from_unit1_to_bu1);
772: if(l_conv_rate_from_unit1_to_bu1 = -99999) then
773: l_conv_rate_from_unit1_to_bu1 := ((uom_conv_details(j).conversion_rate) * l_convrate_from_unit_to_bu)/l_conv_rate_from_bu2_to_bu1;
774: inv_convert.create_uom_conversion(l_baseunit2,uom_conv_details(j).from_uom,p_item_id,l_conv_rate_from_unit1_to_bu1,l_ret);
775: if (l_ret <> FND_API.g_ret_sts_success) then
776: x_return_status := FND_API.G_RET_STS_ERROR;
777: RAISE fnd_api.g_exc_unexpected_error;
778: end if;