APPS.INV_WIP_PICKING_PVT dependencies on MTL_SYSTEM_ITEMS

Line 903: FROM mtl_system_items

899:
900: BEGIN
901: SELECT revision_qty_control_code, lot_control_code
902: INTO l_revision_control_code, l_lot_control_code
903: FROM mtl_system_items
904: WHERE organization_id = l_organization_id
905: AND inventory_item_id = l_mo_line.inventory_item_id;
906: EXCEPTION
907: WHEN NO_DATA_FOUND THEN

Line 1548: FROM mtl_system_items

1544: l_mol_allocation_status := g_completely_allocated;
1545: END IF;
1546: -- Calculate the quantity detailed in the UOM of the move order line
1547: SELECT primary_uom_code INTO l_primary_uom
1548: FROM mtl_system_items
1549: WHERE organization_id = p_mo_line_rec.organization_id
1550: AND inventory_item_id = p_mo_line_rec.inventory_item_id;
1551:
1552: IF (l_primary_uom <> p_mo_line_rec.uom_code) THEN