ORA-00923:FROM keyword not found where expected
<p>When I try to execute the script below on sql developer I've got this exception :</p>

<blockquote>
  <p>ORA-00923:FROM keyword not found where expected</p>
</blockquote>

<pre><code>INSERT INTO PROFIL_CADRE_PORTFOLIO (NUMERO_ORDRE, INTITULE_RESSOURCE, ID_NOM_TYPE_DOCUMENT, LIEN_VERS_OBJET, UTILISATEUR_CREATION, DESCRIPTION, DATE_CREATION, UTILISATEUR_MODIFICATION,DATE_MODIFICATION, ID_PROFIL_CADRE)
(SELECT TEMPO_PORTFOLIO.ORDRE,
        TEMPO_PORTFOLIO.RUBRIQUE_DOCUMENT,
        TEMPO_PORTFOLIO.ID_NOM_TYPE_DOCUMENT,
        CASE
        WHEN TEMPO_PORTFOLIO.TYPE_PORTFOLIO=1
        THEN TEMPO_PORTFOLIO.FICHIER_DOCUMENT
        ELSE TEMPO_PORTFOLIO.ADRESSE_URL_SITE
        END
        TEMPO_PORTFOLIO.CREATEUR_PORTFOLIO,
        CASE
        WHEN TEMPO_PORTFOLIO.TYPE_PORTFOLIO=1
        THEN TEMPO_PORTFOLIO.TITRE_DOCUMENT
        ELSE TEMPO_PORTFOLIO.TITRE_SITE
        END
        TEMPO_PORTFOLIO.DATE_CREATION_PORTFOLIO,
        TEMPO_PORTFOLIO.MODIFICATEUR_PORTFOLIO,
        TEMPO_PORTFOLIO.DATE_MODIFICATION_PORTFOLIO,
        TEMPO_PORTFOLIO.ID_COMPTE_CADRE
FROM TEMPO_PORTFOLIO   
WHERE TEMPO_PORTFOLIO.ID_COMPTE_CADRE IN (SELECT distinct(TEMPO_PORTFOLIO.ID_COMPTE_CADRE) FROM TEMPO_PORTFOLIO,CV 
                                          WHERE CV.ID_COMPTE_CADRE = TEMPO_PORTFOLIO.ID_COMPTE_CADRE
                                          AND CV.CV_WORD IS NOT NULL));
</code></pre>

<p>I don't get what's wrong with my script.
Can anyone help please?</p>