select aa.cd_perd_letv, o.nm_org, cc.NM_IDENT_COMPNT_CURR, cc.NM_COMPNT_CURR, t.NM_IDENT_TURMA
  from siga_turma t,
       siga_atividade_academica aa,
       siga_componente_curricular cc,
       siga_orgao o
 where t.cd_ativ_acad=aa.cd_ativ_acad
   and aa.cd_compnt_curr=cc.cd_compnt_curr
   and aa.cd_org=o.cd_org   
   and t.cd_tp_sit_turma='1'
 --and o.cd_tp_org not in (42)
   and aa.cd_perd_letv in ('2014.1','2014.2') --Alterar Ano Base
   and not exists (select 8
                     from siga_matricula_turma mt
                    where mt.cd_turma=t.cd_turma
                      and mt.nu_sit_matr_turma=1)
order by aa.cd_perd_letv, o.nm_org, cc.NM_COMPNT_CURR