select es.sys_name, ctp.cust_type_name, sum(p.summ) summ
 from payments p join customers c on c.cust_id=p.cust_id
 join exsystems es on es.sys_id=p.es_id
 join cust_types ctp on ctp.cust_type_id=c.cust_type
 where p.paydate between '01.10.2014' and '31.10.2014'
 and (p.summ>=0 or p.es_id in (1,10,684282,702815)) and p.es_id != 3
 
 
  and c.region1='27'
 group by 1,2 order by 1,2

SQL> select es.sys_name, ctp.cust_type_name, sum(p.summ) summ
CON>  from payments p join customers c on c.cust_id=p.cust_id
CON>  join exsystems es on es.sys_id=p.es_id
CON>  join cust_types ctp on ctp.cust_type_id=c.cust_type
CON>  where p.paydate between '01.10.2014' and '31.10.2014'
CON>  and (p.summ>=0 or p.es_id in (1,10,684282,702815)) and p.es_id != 3
CON>
CON>
CON>   and c.region1='11'
CON>  group by 1,2 order by 1,2;

SYS_NAME
                     CUST_TYPE_NAME
                                                             SUMM
===============================================================================
===============================================================================
=======================
Statement failed, SQLSTATE = HY000
BLOB not found
SQL>