Жилые дома белоярского сельсовета

select
  O.CAD_NUM||O.OBJ_NUM "КадУслНо"
  ,o.name "Объект"
  ,O.ADR_DESC "Адрес"
  ,(case
     when o.TSQ_UNITS=10 then O.TOTAL_SQ
     when o.TSQ_UNITS=20 then O.TOTAL_SQ*10000
   end) "Площадь" 
  ,r.reg_no "РегНо"
  ,r.s_date "ДатаРег"
  ,decode(r.TYPE_CODE,r.TYPE_CODE,(select RV.NAME from rt_rights_voc rv where rv.code=r.type_code)) "ВидПрава"

from
  re_objects o
  ,rt_rights r
  ,re_purposes rps
where
  o.id = r.re_id
  and R.R_GROUP = 'П'
  and o.id=RPS.RE_ID
  
  and RPS.TYPE_CODE like '21%'
  
  and r.id in (
  select min(rr.id) from RT_RIGHTS rr where  o.id = rr.re_id
  )
  
  and
  ( lower(O.ADR_DESC) like '%кайбалы%'
    or  lower(O.ADR_DESC) like '%белый%яр%' 
  ) 
  
  and R.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')