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_RCV_STD_INSPECT_APIS dependencies on MTL_UNITS_OF_MEASURE

Line 1269: FROM mtl_units_of_measure

1265: -- rather than uom code(Ea) and hence the following..
1266: -- This will be used later while inserting into interface table
1267: SELECT unit_of_measure
1268: INTO l_uom
1269: FROM mtl_units_of_measure
1270: WHERE uom_code = l_uom_code;
1271:
1272: /*OPM Convergence */
1273: IF l_sec_uom_code IS NOT NULL

Line 1277: FROM mtl_units_of_measure

1273: IF l_sec_uom_code IS NOT NULL
1274: THEN
1275: SELECT unit_of_measure
1276: INTO l_sec_uom
1277: FROM mtl_units_of_measure
1278: WHERE uom_code = l_sec_uom_code;
1279: END IF;
1280:
1281: -- Open Move Order Line cursor

Line 1603: FROM mtl_units_of_measure

1599: -- Modified for bug 6688055
1600: -- Convert l_rtv_uom(Each) into l_rtv_uom_code(Ea)
1601: SELECT uom_code
1602: INTO l_rtv_uom_code
1603: FROM mtl_units_of_measure
1604: WHERE unit_of_measure = l_rtv_uom;
1605:
1606: IF (l_debug = 1)
1607: THEN

Line 1675: FROM mtl_units_of_measure

1671: -- rather than uom code(Ea) and hence the following..
1672: -- Convert l_rtv_uom(Each) into l_rtv_uom_code(Ea)
1673: SELECT uom_code
1674: INTO l_rtv_uom_code
1675: FROM mtl_units_of_measure
1676: WHERE unit_of_measure = l_rtv_uom;
1677:
1678: -- If inspection uom is not same as receipt uom, convert
1679: IF (l_uom_code <> l_rtv_uom_code)

Line 1799: FROM mtl_units_of_measure

1795: END IF;
1796:
1797: SELECT uom_code
1798: INTO l_rtv_uom_code
1799: FROM mtl_units_of_measure
1800: WHERE unit_of_measure = t_tmp_tbl (i).unit_of_measure;
1801:
1802: IF l_uom_code <> l_rtv_uom_code
1803: THEN

Line 2406: FROM mtl_units_of_measure

2402: -- This will be used later while inserting into interface table
2403:
2404: SELECT unit_of_measure
2405: INTO l_uom
2406: FROM mtl_units_of_measure
2407: WHERE uom_code = l_uom_code;
2408:
2409: /*OPM Convergence */
2410: IF l_sec_uom_code IS NOT NULL THEN

Line 2414: FROM mtl_units_of_measure

2410: IF l_sec_uom_code IS NOT NULL THEN
2411:
2412: SELECT unit_of_measure
2413: INTO l_sec_uom
2414: FROM mtl_units_of_measure
2415: WHERE uom_code = l_sec_uom_code;
2416:
2417: END IF;
2418:

Line 2663: FROM mtl_units_of_measure

2659: -- Modified for bug 6688055
2660: -- Convert l_rtv_uom(Each) into l_rtv_uom_code(Ea)
2661: SELECT uom_code
2662: INTO l_rtv_uom_code
2663: FROM mtl_units_of_measure
2664: WHERE unit_of_measure = l_rtv_uom;
2665:
2666: IF (l_debug = 1) THEN
2667: print_debug('l_rtv_uom_code: '||l_rtv_uom_code||' l_uom_code : '||l_uom_code,4);

Line 2731: FROM mtl_units_of_measure

2727: -- rather than uom code(Ea) and hence the following..
2728: -- Convert l_rtv_uom(Each) into l_rtv_uom_code(Ea)
2729: SELECT uom_code
2730: INTO l_rtv_uom_code
2731: FROM mtl_units_of_measure
2732: WHERE unit_of_measure = l_rtv_uom;
2733:
2734: -- If inspection uom is not same as receipt uom, convert
2735:

Line 3557: FROM mtl_units_of_measure

3553: -- This will be used later while inserting into interface table
3554:
3555: SELECT unit_of_measure
3556: INTO l_uom
3557: FROM mtl_units_of_measure
3558: WHERE uom_code = l_uom_code;
3559: /* OPM Convergence */
3560: IF l_sec_uom_code IS NOT NULL THEN
3561:

Line 3564: FROM mtl_units_of_measure

3560: IF l_sec_uom_code IS NOT NULL THEN
3561:
3562: SELECT unit_of_measure
3563: INTO l_sec_uom
3564: FROM mtl_units_of_measure
3565: WHERE uom_code = l_sec_uom_code;
3566:
3567: END IF;
3568: -- dbms_output.put_line('main_process_po: Convert inspection uom code into uom');

Line 3612: FROM mtl_units_of_measure

3608: -- dbms_output.put_line('main_process_po: convert rtv uom into uom code');
3609:
3610: SELECT uom_code
3611: INTO l_rtv_uom_code
3612: FROM mtl_units_of_measure
3613: WHERE unit_of_measure = l_rtv_uom;
3614:
3615: -- If inspection uom is not same as receipt uom, convert
3616:

Line 3972: FROM mtl_units_of_measure

3968: -- This will be used later while inserting into interface table
3969:
3970: SELECT unit_of_measure
3971: INTO l_uom
3972: FROM mtl_units_of_measure
3973: WHERE uom_code = l_uom_code;
3974:
3975: /* OPM Convergence */
3976: IF l_sec_uom_code IS NOT NULL THEN

Line 3980: FROM mtl_units_of_measure

3976: IF l_sec_uom_code IS NOT NULL THEN
3977:
3978: SELECT unit_of_measure
3979: INTO l_sec_uom
3980: FROM mtl_units_of_measure
3981: WHERE uom_code = l_sec_uom_code;
3982:
3983: END IF;
3984:

Line 4029: FROM mtl_units_of_measure

4025: -- dbms_output.put_line('main_process_intransit: convert rtv uom into uom code');
4026:
4027: SELECT uom_code
4028: INTO l_rtv_uom_code
4029: FROM mtl_units_of_measure
4030: WHERE unit_of_measure = l_rtv_uom;
4031:
4032: -- If inspection uom is not same as receipt uom, convert
4033:

Line 4388: FROM mtl_units_of_measure

4384: -- This will be used later while inserting into interface table
4385:
4386: SELECT unit_of_measure
4387: INTO l_uom
4388: FROM mtl_units_of_measure
4389: WHERE uom_code = l_uom_code;
4390:
4391: /* OPM Convergence */
4392: IF l_sec_uom_code IS NOT NULL THEN

Line 4396: FROM mtl_units_of_measure

4392: IF l_sec_uom_code IS NOT NULL THEN
4393:
4394: SELECT unit_of_measure
4395: INTO l_sec_uom
4396: FROM mtl_units_of_measure
4397: WHERE uom_code = l_sec_uom_code;
4398:
4399: END IF;
4400: -- dbms_output.put_line('main_process_rma: Convert inspection uom code into uom');

Line 4444: FROM mtl_units_of_measure

4440: -- dbms_output.put_line('main_process_rma: convert rtv uom into uom code');
4441:
4442: SELECT uom_code
4443: INTO l_rtv_uom_code
4444: FROM mtl_units_of_measure
4445: WHERE unit_of_measure = l_rtv_uom;
4446:
4447: -- If inspection uom is not same as receipt uom, convert
4448:

Line 4801: FROM mtl_units_of_measure

4797: -- This will be used later while inserting into interface table
4798:
4799: SELECT unit_of_measure
4800: INTO l_uom
4801: FROM mtl_units_of_measure
4802: WHERE uom_code = l_uom_code;
4803:
4804: /* OPM Convergence */
4805: IF l_sec_uom_code IS NOT NULL THEN

Line 4809: FROM mtl_units_of_measure

4805: IF l_sec_uom_code IS NOT NULL THEN
4806:
4807: SELECT unit_of_measure
4808: INTO l_sec_uom
4809: FROM mtl_units_of_measure
4810: WHERE uom_code = l_sec_uom_code;
4811:
4812: END IF;
4813: -- dbms_output.put_line('main_process_receipt: Convert inspection uom code into uom');

Line 4870: FROM mtl_units_of_measure

4866: -- dbms_output.put_line('main_process_receipt: convert rtv uom into uom code');
4867:
4868: SELECT uom_code
4869: INTO l_rtv_uom_code
4870: FROM mtl_units_of_measure
4871: WHERE unit_of_measure = l_rtv_uom;
4872:
4873: -- If inspection uom is not same as receipt uom, convert
4874:

Line 6215: from mtl_units_of_measure

6211: -- they pass me unit of measure, now i get uom code
6212:
6213: select uom_code
6214: into l_cur_uom_code
6215: from mtl_units_of_measure
6216: where unit_of_measure = l_cur_uom_code;
6217:
6218: IF (l_cur_uom_code <> p_uom_code) THEN
6219: l_cur_qty := inv_convert.inv_um_convert(

Line 6260: from mtl_units_of_measure

6256:
6257: -- they pass me unit of measure, now i get uom code
6258: select uom_code
6259: into l_cur_uom_code
6260: from mtl_units_of_measure
6261: where unit_of_measure = l_cur_uom_code;
6262:
6263: IF (l_cur_uom_code <> p_uom_code) THEN
6264: l_cur_qty := inv_convert.inv_um_convert(

Line 6298: from mtl_units_of_measure

6294:
6295: -- they pass me unit of measure, now i get uom code
6296: select uom_code
6297: into l_cur_uom_code
6298: from mtl_units_of_measure
6299: where unit_of_measure = l_cur_uom_code;
6300:
6301: IF (l_cur_uom_code <> p_uom_code) THEN
6302: l_cur_qty := inv_convert.inv_um_convert(