SELECT DISTINCT sub.castyname "Наименование",
  sub.castynumnal "ИНН",
  sub.Cnastynasty,
  sub.cnastyprizn,
  sub.history,
  sum(nvl (sub.MmrtyRSUM_all_period_dt, 0)) "Сумма ДТ",
  sum(nvl (sub.MmrtyRSUM_all_period_kt, 0)) "Сумма КТ"
from(
SELECT DISTINCT s.castyname ,
  s.castynumnal ,
  a.Cnastynasty,
  a.cnastyprizn,
  MmrtyRSUM_all_period_dt.MmrtyRSUM  MmrtyRSUM_all_period_dt,
  MmrtyRSUM_all_period_kt.MmrtyRSUM  MmrtyRSUM_all_period_kt,
  tr.CbasdfFLAG || ' - ' || tr.dbasdfdate history
FROM xxi.asty s,
xxi."nasty" a ,
(SELECT DISTINCT aa.Cbasdfnasty,
                        DECODE (aa.CbasdfFLAG, 'О', 'Открыт', 'Б', 'Блокирован', 'З', 'Закрыт', 'Ч', 'Частично блокирован', NULL) CbasdfFLAG,
                        aa.dbasdfdate 
                        FROM xxi."basdf" aa 
                         ) tr, 
(SELECT SUM(t.MmrtyRSUM) MmrtyRSUM, t.cmrtynastyd   FROM xxi."mrty" t   
                      WHERE t.DmrtyTRAN BETWEEN to_date('20.03.2017 00.00.00','dd.mm.yyyy hh24.mi.ss') and to_date('17.04.2017 23.59.59','dd.mm.yyyy hh24.mi.ss')   
                      group by t.cmrtynastyd  ) MmrtyRSUM_all_period_dt,
                            
                            
(SELECT SUM(t.MmrtyRSUM) MmrtyRSUM, t.cmrtynastyc   FROM xxi."mrty" t   
            WHERE t.DmrtyTRAN BETWEEN to_date('20.03.2017 00.00.00','dd.mm.yyyy hh24.mi.ss') and to_date('17.04.2017 23.59.59','dd.mm.yyyy hh24.mi.ss')   
             group by t.cmrtynastyc) MmrtyRSUM_all_period_kt  
                         
WHERE 
a.inastyasty = s.iastynum and
tr.Cbasdfnasty = a.cnastynasty and
MmrtyRSUM_all_period_dt.cmrtynastyd(+) = a.Cnastynasty and
MmrtyRSUM_all_period_kt.cmrtynastyc(+) = a.Cnastynasty and
a.IDSMR <> '16'
AND a.InastyBS2 LIKE '40%'
AND a.inastybs2 NOT IN ('40817', '40911', '40821','40820', '40901', '40906', '40912', '40913')
AND s.castynumnal IN ( '6658211146',
'7452139843',
'1832129590')

) sub
group by sub.castyname, sub.castynumnal, sub.history, sub.Cnastynasty,
sub.cnastyprizn
 ;

listagg () within group (order by )