Субъекты, обе стороны по сделкам к-п

SELECT
b.S_DATE "ДатаСд"
,b.reg_no "РегНоСд"
,(SELECT wm_concat(o.ADR_PRN_DESC)  
  FROM RT_RIGHTS r, RE_OBJECTS o 
  WHERE r.brg_id=b.ID AND o.ID=r.re_id AND r.TYPE_CODE=204
) "Адрес"
,(SELECT wm_concat(Rt.ent_desc(r.ID))  
  FROM RT_RIGHTS r
  WHERE r.brg_id=b.ID AND r.TYPE_CODE=204
) "Покупатель"
,(SELECT wm_concat(Rt.ent_desc(rr.ID))  
  FROM RT_RIGHTS r, RT_RS rtrs, RT_RIGHTS rr
  WHERE r.brg_id=b.ID AND r.TYPE_CODE=204 AND rtrs.RS_ID=r.ID AND rtrs.RT_ID=rr.ID
) "Продавец"
,(SELECT wm_concat(Rt.DOC_DESC(rr.ID,'S'))  
  FROM RT_RIGHTS r, RT_RS rtrs, RT_RIGHTS rr
  WHERE r.brg_id=b.ID AND r.TYPE_CODE=204 AND rtrs.RS_ID=r.ID AND rtrs.RT_ID=rr.ID
) "Документ"
FROM
BRG_BARGAINS b
WHERE
b.TYPE_CODE=1
AND B.S_DATE BETWEEN TO_DATE ('&start#', 'dd.mm.yyyy') AND TO_DATE ('&end#', 'dd.mm.yyyy')