SELECT 
  soc_cdp,
  soc_nom,
  soc_prenom,
  soc_au_soin_de,
  soc_appartement,
  soc_no_civique,
  soc_rue,
  soc_case_postale,
  soc_succursale,
  soc_ville,
  soc_province,
  soc_pays,
  soc_code_postal,
  soc_sexe,
  soc_langue,
  soc_no_da,
  sti_titre,
  crs_cours,
  crs_option,
  crs_version,
  crs_edition,
  inc_session,
  inc_annee,
  fac_typ,
  fac_no,
  inc_groupe,
  crs_ind_soci
FROM 
  social,
  sobec_titre,
  cours,
  inscription,
  facturation
WHERE 
  soc_seq_no =  fac_soc_seq_no  AND
  sti_cours(+)  =  crs_cours  AND
  crs_seq_no  =  inc_crs_seq_no  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 soc_cdp, fac_typ, fac_no, crs_cours
