
SELECT evenement.libelle as evenement,
    to_char(date_evenement,'DD/MM/YYYY') as date_evenement,
    to_char(date_envoi_signature,'DD/MM/YYYY') as date_envoi_signature,
    to_char(date_retour_signature,'DD/MM/YYYY') as date_retour_signature,
    to_char(date_envoi_rar,'DD/MM/YYYY') as date_envoi_rar,
    to_char(date_retour_rar,'DD/MM/YYYY') as date_retour_rar
    from &DB_PREFIXEinstruction
    inner join &DB_PREFIXEevenement on evenement.evenement = instruction.evenement
    where dossier = '&idx'
    and evenement.retour IS FALSE
    order by instruction.date_evenement asc, instruction asc
