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 MTL_UNITS_OF_MEASURE

Line 624: SELECT uom_code FROM mtl_units_of_measure WHERE uom_code = p_uom_code;

620: RETURN VARCHAR2
621: IS
622:
623: CURSOR is_uom_valid is
624: SELECT uom_code FROM mtl_units_of_measure WHERE uom_code = p_uom_code;
625: BEGIN
626: OPEN is_uom_valid;
627:
628: IF ( is_uom_valid%NOTFOUND) THEN

Line 695: select UOM_CLASS into l_class1 from MTL_UNITS_OF_MEASURE where UOM_CODE=uom_conv_details(j).to_uom;

691: FND_MESSAGE.set_token('UOM', uom_conv_details(j).from_uom);
692: FND_MSG_PUB.add;
693: RAISE fnd_api.g_exc_unexpected_error;
694: END IF;
695: select UOM_CLASS into l_class1 from MTL_UNITS_OF_MEASURE where UOM_CODE=uom_conv_details(j).to_uom;
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

Line 696: select UOM_CODE into l_baseunit1 from MTL_UNITS_OF_MEASURE where UOM_CLASS=l_class1 and BASE_UOM_FLAG='Y';

692: FND_MSG_PUB.add;
693: RAISE fnd_api.g_exc_unexpected_error;
694: END IF;
695: select UOM_CLASS into l_class1 from MTL_UNITS_OF_MEASURE where UOM_CODE=uom_conv_details(j).to_uom;
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);

Line 726: select UOM_CLASS into l_class2 from MTL_UNITS_OF_MEASURE where UOM_CODE=uom_conv_details(j).from_uom;

722: RAISE fnd_api.g_exc_unexpected_error;
723: END IF;
724: end if;
725: /* step -2 starts from here */
726: select UOM_CLASS into l_class2 from MTL_UNITS_OF_MEASURE where UOM_CODE=uom_conv_details(j).from_uom;
727: select UOM_CODE into l_baseunit2 from MTL_UNITS_OF_MEASURE where UOM_CLASS= l_class2 and BASE_UOM_FLAG='Y';
728: if(l_class1=l_class2) then
729: l_baseunit2:= l_baseunit1 ;
730: l_conv_rate_from_bu2_to_bu1 :=1;

Line 727: select UOM_CODE into l_baseunit2 from MTL_UNITS_OF_MEASURE where UOM_CLASS= l_class2 and BASE_UOM_FLAG='Y';

723: END IF;
724: end if;
725: /* step -2 starts from here */
726: select UOM_CLASS into l_class2 from MTL_UNITS_OF_MEASURE where UOM_CODE=uom_conv_details(j).from_uom;
727: select UOM_CODE into l_baseunit2 from MTL_UNITS_OF_MEASURE where UOM_CLASS= l_class2 and BASE_UOM_FLAG='Y';
728: if(l_class1=l_class2) then
729: l_baseunit2:= l_baseunit1 ;
730: l_conv_rate_from_bu2_to_bu1 :=1;
731: /*Next calls step-3 */