SELECT 
  DISTINCT soc_cdp,
  soc_nom,
  soc_prenom,
  tut_nom,
  tut_prenom,
  tut_appartement_travail,
  tut_no_civique_travail,
  tut_rue_travail,
  tut_case_postale_travail,
  tut_succursale_travail,
  tut_ville_travail,
  tut_province_travail,
  tut_pays_travail,
  tut_code_postal_travail,
  tut_sexe
FROM 
  social,
  tuteur,
  tuteur_cours_groupe,
  inscription,
  facturation
WHERE 
  soc_seq_no  =  fac_soc_seq_no AND
  tut_no = tcg_tut_no AND
  tcg_crs_seq_no = inc_crs_seq_no AND
  tcg_groupe  =  inc_groupe AND
  ( tcg_dt_debut = 
    (SELECT  MAX(tcg_dt_debut)  FROM  tuteur_cours_groupe  WHERE  tcg_crs_seq_no = inc_crs_seq_no AND
      tcg_groupe =  inc_groupe  AND
     tcg_ind_temporaire=0  AND
      tcg_dt_debut<=SYSDATE)) AND
  inc_soc_seq_no = fac_soc_seq_no AND
  inc_fac_typ  =  fac_typ  AND
  inc_fac_no = fac_no AND
  fac_nvl_reprise_lettre=1
ORDER BY tut_nom, tut_prenom, soc_cdp
