SELECT 
  DISTINCT   inc_soc_seq_no,
  inc_seq_no,
  inc_annee,
  inc_session,
  inc_pgm,
  inc_annee_version_pgm,
  inc_cours,
  inc_secteur,
  inc_dt_l_rappel,
  inc_nvl_en_traitement
FROM 
  social,
  cours,
  evaluation,
  inscription
WHERE 
  soc_seq_no   =   inc_soc_seq_no   AND
  soc_ind_pas_correspondance=0  AND
  crs_seq_no  =   inc_crs_seq_no   AND
  eva_crs_seq_no   =  inc_crs_seq_no  AND
  eva_typ=1  AND
  inc_dt_l_rappel  IS  NULL  AND
  inc_ind_auditeur=0  AND
  inc_ind_inactif=0  AND
  inc_ind_devoir_moitie=0  AND
  inc_nvl_bec_transfert  IS   NULL   AND
  inc_dt_expedition<='2013-12-15'
