APPS.WMS_RETURN_SV dependencies on MTL_ITEM_UOMS_VIEW

Line 418: SELECT uom_code INTO l_uom_code FROM mtl_item_uoms_view

414: END IF;
415: END IF;
416: l_progress := '150';
417:
418: SELECT uom_code INTO l_uom_code FROM mtl_item_uoms_view
419: WHERE organization_id = i.organization_id
420: AND unit_of_measure = i.unit_of_measure
421: AND inventory_item_id = i.item_id;
422: l_progress := '160';

Line 764: FROM mtl_item_uoms_view

760: END IF;
761: -- Converting Move Order Line qty to Primary UOM
762: l_progress := '450';
763: SELECT unit_of_measure INTO l_mol_unit_of_measure
764: FROM mtl_item_uoms_view
765: WHERE organization_id = i.organization_id
766: AND uom_code = j.mol_uom_code
767: AND inventory_item_id = i.item_id;
768:

Line 4224: FROM mtl_item_uoms_view

4220: --Get the UOM code based on the Unit of Measure passed
4221: --For expense items, UOM would be null
4222: SELECT uom_code
4223: INTO l_uom_code
4224: FROM mtl_item_uoms_view
4225: WHERE inventory_item_id = p_item_id
4226: AND organization_id = p_org_id
4227: AND unit_of_measure = p_unit_of_measure;
4228: