1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| SELECT
CDE_DEMANDE.REFERENCE_INTERNE_DEMANDE,
CDE_DEMANDE.REFERENCE_DEMANDE,
CDE_DEMANDE.LIBELLE_DEMANDE,
CDE_DEMANDE.EXPOSE_DEMANDE,
CDE_DEMANDE.ID_DEMANDE,
CDE_DEMANDE.ID_PERE_DEMANDE,
CDE_DEMANDE.REDACTEUR_ORIGINE_DEMANDE,
CDE_DEMANDE.SERVICE_ORIGINE_DEMANDE,
CDE_SOFO.COMMENTAIRE_SOFO,
CDE_ETAT_EVOLUTION.ID_ETAT_EVOLUTION,
CDE_ETAT_EVOLUTION.NOM_ETAT_EVOLUTION,
CDE_EVOLUTION_SOFO.ID_EVOLUTION,
CDE_EVOLUTION_SOFO.ATTENTE_EVOLUTION,
CDE_EVOLUTION_SOFO.COMMENTAIRE_EVOLUTION,
CDE_DEMANDE.DATE_CREA_ORIGINE_DEMANDE,
CDE_SOFO.PRIORITE_SOFO,
CDE_SOFO.QSIHM_SOFO,
CDE_SOFO.MOTIF_SOFO,
CDE_SOFO.EXIGENCE_SOFO,
CDE_SOFO.DATE_REPONSE_SOFO,
CDE_SOFO.CAL_SOUHAIT_SOFO,
CDE_SOFO.IMPACT_SOFO,
CDE_SOFO.ID_TRANSVERS,
CDE_SOFO.ID_OFFRE,
CDE_SOFO.IDINSC_RECEPTEUR_SOFO
FROM
LAST_EVOLUTION_DEMANDE,
CDE_DEMANDE,
CDE_SOFO,
CDE_EVOLUTION_SOFO,
CDE_ETAT_EVOLUTION
WHERE LAST_EVOLUTION_DEMANDE.ID_DEMANDE=CDE_DEMANDE.ID_DEMANDE
AND LAST_EVOLUTION_DEMANDE.ID_SOFO=CDE_SOFO.ID_SOFO
AND LAST_EVOLUTION_DEMANDE.ID_EVOLUTION=CDE_EVOLUTION_SOFO.ID_EVOLUTION
AND CDE_EVOLUTION_SOFO.ID_ETAT_EVOLUTION=CDE_ETAT_EVOLUTION.ID_ETAT_EVOLUTION
AND CDE_ETAT_EVOLUTION.ID_ETAT_EVOLUTION IN (41,4,5,6,7,9) |
Partager