APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_ITEM_UOMS_VIEW

Line 1314: FROM mtl_item_uoms_view

1310: l_progress := 'WMSINB-11052';
1311: BEGIN
1312: SELECT uom_code
1313: into l_uom_code
1314: FROM mtl_item_uoms_view
1315: WHERE organization_id = l_org_id
1316: AND inventory_item_id = l_item_id
1317: AND unit_of_measure = l_unit_of_measure;
1318: EXCEPTION

Line 1422: FROM mtl_item_uoms_view

1418: l_progress := 'WMSINB-11148';
1419: BEGIN
1420: SELECT uom_code
1421: into l_uom_code
1422: FROM mtl_item_uoms_view
1423: WHERE organization_id = l_org_id
1424: AND inventory_item_id = l_item_id
1425: AND unit_of_measure = l_unit_of_measure;
1426: EXCEPTION

Line 1441: FROM mtl_item_uoms_view

1437:
1438: BEGIN
1439: SELECT uom_code
1440: INTO l_sec_uom_code_2
1441: FROM mtl_item_uoms_view
1442: WHERE organization_id = l_org_id
1443: AND inventory_item_id = l_item_id
1444: AND unit_of_measure = l_sec_unit_of_measure;
1445: EXCEPTION

Line 1499: FROM mtl_item_uoms_view

1495:
1496: BEGIN
1497: SELECT uom_code
1498: into l_uom_code
1499: FROM mtl_item_uoms_view
1500: WHERE organization_id = l_org_id
1501: AND inventory_item_id = l_item_id
1502: AND unit_of_measure = l_unit_of_measure;
1503: EXCEPTION

Line 1518: FROM mtl_item_uoms_view

1514:
1515: BEGIN
1516: SELECT uom_code
1517: INTO l_sec_uom_code_2
1518: FROM mtl_item_uoms_view
1519: WHERE organization_id = l_org_id
1520: AND inventory_item_id = l_item_id
1521: AND unit_of_measure = l_sec_unit_of_measure;
1522: EXCEPTION

Line 9224: FROM mtl_item_uoms_view

9220:
9221: BEGIN
9222: SELECT uom_code
9223: into l_rti_rec.uom_code
9224: FROM mtl_item_uoms_view
9225: WHERE organization_id = l_rti_rec.to_organization_id
9226: AND inventory_item_id = l_rti_rec.item_id
9227: AND unit_of_measure = l_rti_rec.unit_of_measure;
9228: EXCEPTION

Line 10193: FROM mtl_item_uoms_view

10189:
10190: BEGIN
10191: SELECT uom_code
10192: into l_rti_rec.uom_code
10193: FROM mtl_item_uoms_view
10194: WHERE organization_id = l_rti_rec.to_organization_id
10195: AND inventory_item_id = l_rti_rec.item_id
10196: AND unit_of_measure = l_rti_rec.unit_of_measure;
10197: EXCEPTION

Line 10211: FROM mtl_item_uoms_view

10207:
10208: BEGIN
10209: SELECT uom_code
10210: INTO l_rti_rec.secondary_uom_code
10211: FROM mtl_item_uoms_view
10212: WHERE organization_id = l_rti_rec.to_organization_id
10213: AND inventory_item_id = l_rti_rec.item_id
10214: AND unit_of_measure = l_rti_rec.secondary_unit_of_measure;
10215: EXCEPTION

Line 10956: FROM mtl_item_uoms_view

10952: l_progress := 'WMSINB-15816';
10953:
10954: SELECT unit_of_measure
10955: into l_unit_of_measure
10956: FROM mtl_item_uoms_view
10957: WHERE organization_id = p_to_org_id
10958: AND inventory_item_id = p_item_id
10959: AND uom_code = p_txn_uom_code;
10960:

Line 11918: FROM mtl_item_uoms_view

11914:
11915: BEGIN
11916: SELECT uom_code
11917: into l_rs_uom_code
11918: FROM mtl_item_uoms_view
11919: WHERE organization_id = l_rs_tb(l_rs_index).organization_id
11920: AND inventory_item_id = l_rs_tb(l_rs_index).inventory_item_id
11921: AND unit_of_measure = l_rs_tb(l_rs_index).unit_of_measure;
11922: EXCEPTION

Line 17316: FROM mtl_item_uoms_view

17312: if l_uom_code is null then
17313: BEGIN
17314: SELECT uom_code
17315: into l_uom_code
17316: FROM mtl_item_uoms_view
17317: WHERE organization_id = l_to_organization_id
17318: AND inventory_item_id = l_item_id
17319: AND unit_of_measure = l_unit_of_measure;
17320: EXCEPTION

Line 17432: FROM mtl_item_uoms_view

17428: if l_uom_code is null then
17429: BEGIN
17430: SELECT uom_code
17431: into l_uom_code
17432: FROM mtl_item_uoms_view
17433: WHERE organization_id = l_to_organization_id
17434: AND inventory_item_id = l_item_id
17435: AND unit_of_measure = l_unit_of_measure;
17436: EXCEPTION

Line 17615: FROM mtl_item_uoms_view

17611: if l_uom_code is null then
17612: BEGIN
17613: SELECT uom_code
17614: into l_uom_code
17615: FROM mtl_item_uoms_view
17616: WHERE organization_id = l_to_organization_id
17617: AND inventory_item_id = l_item_id
17618: AND unit_of_measure = l_unit_of_measure;
17619: EXCEPTION