1 2 3 4 5 6 7 8 9 10 11 12 13
|
select DISTINCT j1.jed_id_envoi
from journal_envoi_document j1,journal_envoi_document j2, Document doc
where j1.JED_ID_DOCUMENT_ENVOI = j2.JED_ID_DOCUMENT_ENVOI
and j1.JED_ID_DOCUMENT_ENVOI = doc.ID_DOCUMENT_ENVOI
and j2.jed_statut in ('2','3','4')
and j1.JED_DATE_SOUMISSION+ 400 > CURRENT_DATE
and doc.ENVOI_MSG_SEC = '1'
AND NOT EXIST
(Select j.jed_id_envoi
FROM journal_envoi_document j, Document doc, Ms_Autorisation_Envoi ms
where j.JED_ID_DOCUMENT_ENVOI = doc.ID_DOCUMENT_ENVOI
and doc.NOIP = ms.AEN_NIP) |
Partager