8Форма за счет заемных средств

select
--count(ap.id) "КолВоКУВД"
AP.NO
,decode(r.TYPE_CODE,r.TYPE_CODE,(select RV.NAME from rt_rights_voc rv where rv.code=r.type_code)) "ТипПрава"
,(select wm_concat(' '||(SELECT bv.NAME FROM BRG_BARGAINS_VOC bv WHERE bv.CODE=b.TYPE_CODE)) from brg_bargains b where b.id=r.brg_id) "Сделка"
from
app_applications ap
,app_switch aps
,app_rt art
,rt_rights r
where
AP.ID=APS.APP_ID
and ap.id=art.app_id
and r.id=art.rt_id

and r_type=2
and r.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')