select pf.cd_progr_form as COD_CURSO, 
       pf.nm_progr_form as NOME_CURSO, 
       cc.nm_ident_compnt_curr as IDENT_DISCIPLINA, 
       cc.nm_compnt_curr as NOME_DISCIPLINA, 
       p.nm_cpf_pess as CPF_DISCENTE, 
       p.nm_pess as NOME_DISCENTE, 
       p.nm_email_secd as EMAIL_PESSOAL
from siga_modal_progr_form mpf, 
     siga_matricula_turma mt, 
     siga_programa_formacao pf,
     siga_vinculo v, 
     siga_pessoa p, 
     siga_atividade_academica aa, 
     siga_componente_curricular cc, 
     siga_turma t
where mt.nu_matr_curso = v.nu_matr_curso
  and mt.cd_turma = t.cd_turma
  and t.cd_ativ_acad = aa.cd_ativ_acad
  and aa.cd_compnt_curr = cc.cd_compnt_curr
  and v.nm_cpf_pess = p.nm_cpf_pess
  and v.cd_progr_form = pf.cd_progr_form
  and pf.cd_progr_form = mpf.cd_progr_form
  and mt.nu_sit_matr_turma = 1
  and pf.cd_nivel = 1
  and (mpf.cd_modal = 1 or pf.cd_progr_form in (120,121))
  and aa.cd_perd_letv = '2013.1'
order by pf.nm_progr_form, 
         cc.nm_compnt_curr, 
         p.nm_pess

select pf.cd_progr_form as COD_CURSO, 
       pf.nm_progr_form as NOME_CURSO, 
       cc.nm_ident_compnt_curr as IDENT_DISCIPLINA, 
       cc.nm_compnt_curr as NOME_DISCIPLINA, 
       p.nm_cpf_pess as CPF_DISCENTE, 
       p.nm_pess as NOME_DISCENTE, 
       p.nm_email_secd as EMAIL_PESSOAL
from siga_modal_progr_form mpf, 
     siga_matricula_turma mt, 
     siga_programa_formacao pf,
     siga_vinculo v, 
     siga_pessoa p, 
     siga_atividade_academica aa, 
     siga_componente_curricular cc, 
     siga_turma t
where mt.nu_matr_curso = v.nu_matr_curso
  and mt.cd_turma = t.cd_turma
  and t.cd_ativ_acad = aa.cd_ativ_acad
  and aa.cd_compnt_curr = cc.cd_compnt_curr
  and v.nm_cpf_pess = p.nm_cpf_pess
  and v.cd_progr_form = pf.cd_progr_form
  and pf.cd_progr_form = mpf.cd_progr_form
  and mt.nu_sit_matr_turma = 34
  and pf.cd_nivel = 1
  and (mpf.cd_modal = 1 or pf.cd_progr_form in (120,121))
  and aa.cd_perd_letv = '2013.1'
order by pf.nm_progr_form, 
         cc.nm_compnt_curr, 
         p.nm_pess