select fo kkkk,nvl(getmaincode(t10.own_id),'') || ' ' || to_char(t10.bso_num) 
  num_tic,t10.ops_id,t10.bso_num, t10.saledate, t10.fo_full routing,     
  getmaincode(pid) stamp, getmaincode(CC_SUM) gk, to_char(saledate,'DD.MM.YY')
   sdate, max(pbso_num) pbso_num,   DATA tourcode,  sum( t10.fare) fare,  
  sum( t10.tax_sum) tax_sum,  sum( t10.tax_sum1) tax_sum1,  sum( t10.pen_sum) 
  pen_sum,  sum( t10.kom_sum) kom_sum,   max(t10.pay_form) pay_form,   sum( 
  t10.kom_sum2) kom_sum2,   sum( t10.kom3) kom_sum3,   op_group,   ob_code 
  kom_prc,   komisprc3 kom_prc2,   prc3 kom_prc3,   max(t10.ntax_sum3) 
  prc_skd,   decode(t10.is_conj, 1, 'полный', 0, 'частичный') is_full,   sum( 
  t10.tax_sum3) tax_sum3,   sum( t10.strah_sb) tax_sum4,  sum( t10.bank_sum) 
  fact_sum,   sum( Taxak_Sum)  rasc_sum,  max(getmaincode(t10.summ_1)) ag, 
  max(getmaincode(t10.summ_2)) psl, max(t10.inetshop_onum) inum, org_full 
  corp_code , '' sale_date ,max(getmaincode(t10.asb_id)) asb,
  max(t10.inetshop_code) isc,max(t10.PAS_DOCNUM) PAS_DOCNUM,max(t10.PARM) 
  PARM,max(t10.exch) exch,max(t10.to_id) to_id,max(t10.exch_type) exch_type,
  max(t10.office_id) office_id,max(t10.office_book_id) office_book_id,sum( 
  t10.sbor_post)  sbor_post ,substr(EXTRACT(XMLAGG(xmlelement("V",
  decode(t10.surface,'S',null,','||GetMainCode(t10.Nrate))) ORDER BY 
  t10.trans_no), 											  '/V/text()').getstringval(),2) ak_code,
  substr(EXTRACT(XMLAGG(xmlelement("V",decode(t10.surface,'S',null,',
  '||t10.org)) ORDER BY t10.trans_no), 											  '/V/text()')
  .getstringval(),2) reis,substr(EXTRACT(XMLAGG(xmlelement("V", 
  decode(t10.surface,'S',null,'/'||to_char(to_date(t10.Rg,'DD.MM.YYYY'),
  'DD.MM.YY'))) ORDER BY t10.trans_no), 											  '/V/text()')
  .getstringval(), 2) FLY_DAT,substr(EXTRACT(XMLAGG(xmlelement("V", 
  decode(t10.surface,'S',null,','||t10.AK_CODE)) ORDER BY t10.trans_no), 
  											  '/V/text()').getstringval(),2) basicfare,
  substr(EXTRACT(XMLAGG(xmlelement("V", decode(t10.surface,'S',null,',
  '||t10.CATEG)) ORDER BY t10.trans_no), 											  '/V/text()')
  .getstringval(),2) cl_br,substr(EXTRACT(XMLAGG(xmlelement("V", 
  decode(t10.surface,'S',null,','||nvl(t10.ak_oper_code,'-'))) ORDER BY 
  t10.trans_no), 											  '/V/text()').getstringval(),2) ak_oper,
  substr(EXTRACT(XMLAGG(xmlelement("V", decode(t10.surface,'S',null,',
  '||t10.fio)) ORDER BY t10.trans_no), 											  '/V/text()')
  .getstringval(),2) cl_obsl,
  max(nvl(p_Np.GetNP(acp_rpt.GetRouteOrVoid(a_opsid => t10.ops_id,a_cashcoef =
  > t10.cashcoef,a_surface => 1),'@route'),t10.fo_full)) route,max(t10.rfic) 
  rfic,substr(EXTRACT(XMLAGG(xmlelement("V", decode(t10.surface,'S',null,',
  '||t10.rfisc)) ORDER BY t10.trans_no), 											  '/V/text()')
  .getstringval(),2) rfisc,max(t10.ref_id) ref_id 
from
 TMP_PRT_ACCLET_10 t10 where is_void = 0 and  nvl(srep_id,0) >= 0 and 
  t10.cashcoef = 1 group by is_conj, fo, nvl(getmaincode(t10.own_id),'') || ' 
  ' || to_char(t10.bso_num) ,nvl(pbso_num, t10.bso_num), 			  t10.ops_id,
  t10.bso_num, t10.saledate, t10.fo_full, pid,CC_SUM, org_full,data, ob_code, 
  komisprc3, prc3,op_group  , ''   having nvl(getmaincode(t10.own_id),'') || 
  ' ' || to_char(t10.bso_num) <> ' ' or 			sum(nvl( t10.fare,0))||sum(nvl( 
  t10.tax_sum,0))||			sum(nvl( t10.tax_sum1,0))||sum(nvl( t10.pen_sum,0))
  ||			sum(nvl( t10.kom_sum,0))||sum(nvl( t10.tax_sum3,0))||			sum(nvl( 
  t10.strah_sb,0))||sum(nvl( t10.bank_sum,0))||			sum(nvl( Taxak_Sum,0)) <> 
  '000000000' order by t10.bso_num