APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 18201: l_uom_code mtl_units_of_measure_vl.uom_code%TYPE;

18197: IS
18198: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
18199: l_item_id number;
18200: l_org_id number;
18201: l_uom_code mtl_units_of_measure_vl.uom_code%TYPE;
18202: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;
18203:
18204: -- Bug 13886318 need to revert bug 12329840
18205: --x_serial_number_control_code NUMBER; -- Bug 12329840

Line 18202: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;

18198: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
18199: l_item_id number;
18200: l_org_id number;
18201: l_uom_code mtl_units_of_measure_vl.uom_code%TYPE;
18202: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;
18203:
18204: -- Bug 13886318 need to revert bug 12329840
18205: --x_serial_number_control_code NUMBER; -- Bug 12329840
18206: BEGIN

Line 18219: FROM MTL_UNITS_OF_MEASURE_VL

18215: IF(l_uom_code is null) then
18216: BEGIN
18217: SELECT uom_code
18218: INTO l_uom_code
18219: FROM MTL_UNITS_OF_MEASURE_VL
18220: WHERE unit_of_measure = l_unit_of_measure;
18221:
18222: EXCEPTION
18223: WHEN NO_DATA_FOUND THEN

Line 19595: FROM MTL_UNITS_OF_MEASURE_VL

19591: if l_rti_uom_code is null then
19592: BEGIN
19593: SELECT uom_code
19594: INTO l_rti_uom_code
19595: FROM MTL_UNITS_OF_MEASURE_VL
19596: WHERE unit_of_measure = l_rti_UNIT_OF_MEASURE;
19597:
19598: EXCEPTION
19599: WHEN NO_DATA_FOUND THEN

Line 29367: FROM mtl_units_of_measure

29363: THEN
29364: BEGIN
29365: SELECT uom_code
29366: INTO l_uom_code
29367: FROM mtl_units_of_measure
29368: WHERE unit_of_measure = p_uom ;
29369:
29370: EXCEPTION
29371: WHEN NO_DATA_FOUND