К-П за 2010 год

SELECT 
b.REG_NO "РегНо"
--,r.REG_NO "РегНоRT"     
,(SELECT bv.NAME FROM BRG_BARGAINS_VOC bv WHERE bv.CODE=b.TYPE_CODE) "ТипСделки"
,r.S_DATE "ДатаРег"     
,O.TOTAL_SQ "Площадь"   
,r.RE_PRICE "Цена"
,B.PRICE "Цена2"      
,o.ADR_DESC "Адрес"     
,o.CON_DESC "ОписОбъекта"
,b.CONDITION "ОписСделки"
,d.NAME
,Rt.ent_desc(r.ID) "покупатель"
,(SELECT wm_concat(Rt.ent_desc(rr.ID))  
  FROM  
    RT_RS rtrs, RT_RIGHTS rr
  WHERE 
    rtrs.RS_ID=r.ID 
    AND rtrs.RT_ID=rr.ID
) "Продавец"
FROM
BRG_BARGAINS b
,RT_RIGHTS r
,RE_OBJECTS o
,doc_foundations d
WHERE

r.BRG_ID=b.ID
AND o.ID=r.RE_ID
AND d.ID=B.DOC_ID

AND R.S_DATE BETWEEN TO_DATE ('&start#', 'dd.mm.yyyy') AND TO_DATE ('&end#', 'dd.mm.yyyy')

and b.TYPE_CODE=1 --купля-продажа
and R.TYPE_CODE = 204-- Участие в сделке
and form_8.re_type_form(r.re_id) = 232--231-нежилое;232-жилое ;1-ЗУ 
ORDER BY b.REG_NO