APPS.INV_RCV_STD_INSPECT_APIS dependencies on MTL_UNITS_OF_MEASURE

Line 554: FROM mtl_units_of_measure

550: -- This will be used later while inserting into interface table
551:
552: SELECT unit_of_measure
553: INTO l_uom
554: FROM mtl_units_of_measure
555: WHERE uom_code = l_uom_code;
556:
557: /*OPM Convergence */
558: IF l_sec_uom_code IS NOT NULL THEN

Line 562: FROM mtl_units_of_measure

558: IF l_sec_uom_code IS NOT NULL THEN
559:
560: SELECT unit_of_measure
561: INTO l_sec_uom
562: FROM mtl_units_of_measure
563: WHERE uom_code = l_sec_uom_code;
564:
565: END IF;
566:

Line 773: FROM mtl_units_of_measure

769: -- Modified for bug 6688055
770: -- Convert l_rtv_uom(Each) into l_rtv_uom_code(Ea)
771: SELECT uom_code
772: INTO l_rtv_uom_code
773: FROM mtl_units_of_measure
774: WHERE unit_of_measure = l_rtv_uom;
775:
776: IF (l_debug = 1) THEN
777: print_debug('l_rtv_uom_code: '||l_rtv_uom_code||' l_uom_code : '||l_uom_code,4);

Line 841: FROM mtl_units_of_measure

837: -- rather than uom code(Ea) and hence the following..
838: -- Convert l_rtv_uom(Each) into l_rtv_uom_code(Ea)
839: SELECT uom_code
840: INTO l_rtv_uom_code
841: FROM mtl_units_of_measure
842: WHERE unit_of_measure = l_rtv_uom;
843:
844: -- If inspection uom is not same as receipt uom, convert
845:

Line 1665: FROM mtl_units_of_measure

1661: -- This will be used later while inserting into interface table
1662:
1663: SELECT unit_of_measure
1664: INTO l_uom
1665: FROM mtl_units_of_measure
1666: WHERE uom_code = l_uom_code;
1667: /* OPM Convergence */
1668: IF l_sec_uom_code IS NOT NULL THEN
1669:

Line 1672: FROM mtl_units_of_measure

1668: IF l_sec_uom_code IS NOT NULL THEN
1669:
1670: SELECT unit_of_measure
1671: INTO l_sec_uom
1672: FROM mtl_units_of_measure
1673: WHERE uom_code = l_sec_uom_code;
1674:
1675: END IF;
1676: -- dbms_output.put_line('main_process_po: Convert inspection uom code into uom');

Line 1720: FROM mtl_units_of_measure

1716: -- dbms_output.put_line('main_process_po: convert rtv uom into uom code');
1717:
1718: SELECT uom_code
1719: INTO l_rtv_uom_code
1720: FROM mtl_units_of_measure
1721: WHERE unit_of_measure = l_rtv_uom;
1722:
1723: -- If inspection uom is not same as receipt uom, convert
1724:

Line 2079: FROM mtl_units_of_measure

2075: -- This will be used later while inserting into interface table
2076:
2077: SELECT unit_of_measure
2078: INTO l_uom
2079: FROM mtl_units_of_measure
2080: WHERE uom_code = l_uom_code;
2081:
2082: /* OPM Convergence */
2083: IF l_sec_uom_code IS NOT NULL THEN

Line 2087: FROM mtl_units_of_measure

2083: IF l_sec_uom_code IS NOT NULL THEN
2084:
2085: SELECT unit_of_measure
2086: INTO l_sec_uom
2087: FROM mtl_units_of_measure
2088: WHERE uom_code = l_sec_uom_code;
2089:
2090: END IF;
2091:

Line 2136: FROM mtl_units_of_measure

2132: -- dbms_output.put_line('main_process_intransit: convert rtv uom into uom code');
2133:
2134: SELECT uom_code
2135: INTO l_rtv_uom_code
2136: FROM mtl_units_of_measure
2137: WHERE unit_of_measure = l_rtv_uom;
2138:
2139: -- If inspection uom is not same as receipt uom, convert
2140:

Line 2493: FROM mtl_units_of_measure

2489: -- This will be used later while inserting into interface table
2490:
2491: SELECT unit_of_measure
2492: INTO l_uom
2493: FROM mtl_units_of_measure
2494: WHERE uom_code = l_uom_code;
2495:
2496: /* OPM Convergence */
2497: IF l_sec_uom_code IS NOT NULL THEN

Line 2501: FROM mtl_units_of_measure

2497: IF l_sec_uom_code IS NOT NULL THEN
2498:
2499: SELECT unit_of_measure
2500: INTO l_sec_uom
2501: FROM mtl_units_of_measure
2502: WHERE uom_code = l_sec_uom_code;
2503:
2504: END IF;
2505: -- dbms_output.put_line('main_process_rma: Convert inspection uom code into uom');

Line 2549: FROM mtl_units_of_measure

2545: -- dbms_output.put_line('main_process_rma: convert rtv uom into uom code');
2546:
2547: SELECT uom_code
2548: INTO l_rtv_uom_code
2549: FROM mtl_units_of_measure
2550: WHERE unit_of_measure = l_rtv_uom;
2551:
2552: -- If inspection uom is not same as receipt uom, convert
2553:

Line 2901: FROM mtl_units_of_measure

2897: -- This will be used later while inserting into interface table
2898:
2899: SELECT unit_of_measure
2900: INTO l_uom
2901: FROM mtl_units_of_measure
2902: WHERE uom_code = l_uom_code;
2903:
2904: /* OPM Convergence */
2905: IF l_sec_uom_code IS NOT NULL THEN

Line 2909: FROM mtl_units_of_measure

2905: IF l_sec_uom_code IS NOT NULL THEN
2906:
2907: SELECT unit_of_measure
2908: INTO l_sec_uom
2909: FROM mtl_units_of_measure
2910: WHERE uom_code = l_sec_uom_code;
2911:
2912: END IF;
2913: -- dbms_output.put_line('main_process_receipt: Convert inspection uom code into uom');

Line 2970: FROM mtl_units_of_measure

2966: -- dbms_output.put_line('main_process_receipt: convert rtv uom into uom code');
2967:
2968: SELECT uom_code
2969: INTO l_rtv_uom_code
2970: FROM mtl_units_of_measure
2971: WHERE unit_of_measure = l_rtv_uom;
2972:
2973: -- If inspection uom is not same as receipt uom, convert
2974:

Line 4316: from mtl_units_of_measure

4312: -- they pass me unit of measure, now i get uom code
4313:
4314: select uom_code
4315: into l_cur_uom_code
4316: from mtl_units_of_measure
4317: where unit_of_measure = l_cur_uom_code;
4318:
4319: IF (l_cur_uom_code <> p_uom_code) THEN
4320: l_cur_qty := inv_convert.inv_um_convert(

Line 4361: from mtl_units_of_measure

4357:
4358: -- they pass me unit of measure, now i get uom code
4359: select uom_code
4360: into l_cur_uom_code
4361: from mtl_units_of_measure
4362: where unit_of_measure = l_cur_uom_code;
4363:
4364: IF (l_cur_uom_code <> p_uom_code) THEN
4365: l_cur_qty := inv_convert.inv_um_convert(

Line 4399: from mtl_units_of_measure

4395:
4396: -- they pass me unit of measure, now i get uom code
4397: select uom_code
4398: into l_cur_uom_code
4399: from mtl_units_of_measure
4400: where unit_of_measure = l_cur_uom_code;
4401:
4402: IF (l_cur_uom_code <> p_uom_code) THEN
4403: l_cur_qty := inv_convert.inv_um_convert(