APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_ITEM_UOMS_VIEW

Line 1290: FROM mtl_item_uoms_view

1286: l_progress := 'WMSINB-11052';
1287: BEGIN
1288: SELECT uom_code
1289: into l_uom_code
1290: FROM mtl_item_uoms_view
1291: WHERE organization_id = l_org_id
1292: AND inventory_item_id = l_item_id
1293: AND unit_of_measure = l_unit_of_measure;
1294: EXCEPTION

Line 1398: FROM mtl_item_uoms_view

1394: l_progress := 'WMSINB-11148';
1395: BEGIN
1396: SELECT uom_code
1397: into l_uom_code
1398: FROM mtl_item_uoms_view
1399: WHERE organization_id = l_org_id
1400: AND inventory_item_id = l_item_id
1401: AND unit_of_measure = l_unit_of_measure;
1402: EXCEPTION

Line 1417: FROM mtl_item_uoms_view

1413:
1414: BEGIN
1415: SELECT uom_code
1416: INTO l_sec_uom_code_2
1417: FROM mtl_item_uoms_view
1418: WHERE organization_id = l_org_id
1419: AND inventory_item_id = l_item_id
1420: AND unit_of_measure = l_sec_unit_of_measure;
1421: EXCEPTION

Line 1475: FROM mtl_item_uoms_view

1471:
1472: BEGIN
1473: SELECT uom_code
1474: into l_uom_code
1475: FROM mtl_item_uoms_view
1476: WHERE organization_id = l_org_id
1477: AND inventory_item_id = l_item_id
1478: AND unit_of_measure = l_unit_of_measure;
1479: EXCEPTION

Line 1494: FROM mtl_item_uoms_view

1490:
1491: BEGIN
1492: SELECT uom_code
1493: INTO l_sec_uom_code_2
1494: FROM mtl_item_uoms_view
1495: WHERE organization_id = l_org_id
1496: AND inventory_item_id = l_item_id
1497: AND unit_of_measure = l_sec_unit_of_measure;
1498: EXCEPTION

Line 8806: FROM mtl_item_uoms_view

8802:
8803: BEGIN
8804: SELECT uom_code
8805: into l_rti_rec.uom_code
8806: FROM mtl_item_uoms_view
8807: WHERE organization_id = l_rti_rec.to_organization_id
8808: AND inventory_item_id = l_rti_rec.item_id
8809: AND unit_of_measure = l_rti_rec.unit_of_measure;
8810: EXCEPTION

Line 9763: FROM mtl_item_uoms_view

9759:
9760: BEGIN
9761: SELECT uom_code
9762: into l_rti_rec.uom_code
9763: FROM mtl_item_uoms_view
9764: WHERE organization_id = l_rti_rec.to_organization_id
9765: AND inventory_item_id = l_rti_rec.item_id
9766: AND unit_of_measure = l_rti_rec.unit_of_measure;
9767: EXCEPTION

Line 9781: FROM mtl_item_uoms_view

9777:
9778: BEGIN
9779: SELECT uom_code
9780: INTO l_rti_rec.secondary_uom_code
9781: FROM mtl_item_uoms_view
9782: WHERE organization_id = l_rti_rec.to_organization_id
9783: AND inventory_item_id = l_rti_rec.item_id
9784: AND unit_of_measure = l_rti_rec.secondary_unit_of_measure;
9785: EXCEPTION

Line 10479: FROM mtl_item_uoms_view

10475: l_progress := 'WMSINB-15816';
10476:
10477: SELECT unit_of_measure
10478: into l_unit_of_measure
10479: FROM mtl_item_uoms_view
10480: WHERE organization_id = p_to_org_id
10481: AND inventory_item_id = p_item_id
10482: AND uom_code = p_txn_uom_code;
10483:

Line 11433: FROM mtl_item_uoms_view

11429:
11430: BEGIN
11431: SELECT uom_code
11432: into l_rs_uom_code
11433: FROM mtl_item_uoms_view
11434: WHERE organization_id = l_rs_tb(l_rs_index).organization_id
11435: AND inventory_item_id = l_rs_tb(l_rs_index).inventory_item_id
11436: AND unit_of_measure = l_rs_tb(l_rs_index).unit_of_measure;
11437: EXCEPTION

Line 16531: FROM mtl_item_uoms_view

16527: if l_uom_code is null then
16528: BEGIN
16529: SELECT uom_code
16530: into l_uom_code
16531: FROM mtl_item_uoms_view
16532: WHERE organization_id = l_to_organization_id
16533: AND inventory_item_id = l_item_id
16534: AND unit_of_measure = l_unit_of_measure;
16535: EXCEPTION

Line 16647: FROM mtl_item_uoms_view

16643: if l_uom_code is null then
16644: BEGIN
16645: SELECT uom_code
16646: into l_uom_code
16647: FROM mtl_item_uoms_view
16648: WHERE organization_id = l_to_organization_id
16649: AND inventory_item_id = l_item_id
16650: AND unit_of_measure = l_unit_of_measure;
16651: EXCEPTION

Line 16828: FROM mtl_item_uoms_view

16824: if l_uom_code is null then
16825: BEGIN
16826: SELECT uom_code
16827: into l_uom_code
16828: FROM mtl_item_uoms_view
16829: WHERE organization_id = l_to_organization_id
16830: AND inventory_item_id = l_item_id
16831: AND unit_of_measure = l_unit_of_measure;
16832: EXCEPTION