Помещения в Абакане

SELECT
o.NAME "Наим"
--,o.ADR_DESC "Адр"
,o.ADR_PRN_DESC "АдрСв"
,r.S_DATE "Дата"
,DECODE(r.TYPE_CODE,r.TYPE_CODE,(SELECT RV.NAME FROM RT_RIGHTS_VOC rv WHERE rv.code=r.type_code)) "ТипПрава"
,r.part "Часть"
--,r.REG_NO "РегНо"
,Ent.con_desc(en.ID) "Правообладатель"
 
FROM
RE_OBJECTS o
,RT_RIGHTS r
,RT_ENT rte
,ENT_ENTITIES en
WHERE
o.ID=r.re_id
AND rte.RT_ID=r.ID
AND rte.ENT_ID = en.ID
AND o.R_TYPE=3 --часть
AND r.R_GROUP = 'П'
AND
  (
      r.e_DATE IS NULL
   OR (
        r.e_date > TO_DATE ('01.01.2011', 'dd.mm.yyyy')
        AND r.s_date < TO_DATE ('01.01.2011', 'dd.mm.yyyy')
      )
  )
AND LOWER(o.NAME) NOT LIKE '%погреб%'
AND LOWER(o.NAME) NOT LIKE '%гараж%'
AND LOWER(o.NAME) NOT LIKE '%подвал%'
AND LOWER(o.ADR_DESC) NOT LIKE '%усть-%'
    
AND LOWER(o.ADR_PRN_DESC) LIKE '%абакан%'
 
ORDER BY o.ADR_DESC

Контроль создания адреса

select
ad.ID
,(SELECT c.RV_ABBREVIATION FROM CG_REF_CODES c WHERE  c.RV_LOW_VALUE= ad.R_LEVEL AND  c.RV_DOMAIN='ADR УРОВЕНЬ АДРЕСА (СПИСОК)')"УрАдр"
,AD.R_LEVEL
,AD.NAME
,RP.EMP_NAME(ad.Inserted_by) "Сотрудник"
,(SELECT  wm_concat(NAME)
      FROM adr_address_voc
START WITH adr_address_voc.ID = ad.ID
CONNECT BY adr_address_voc.ID = PRIOR adr_address_voc.par_id) "Адрес"
from 
adr_address_voc ad
where
ad.inserted BETWEEN TO_DATE ('&start#', 'dd.mm.yyyy') AND TO_DATE ('&end#', 'dd.mm.yyyy')
and AD.R_LEVEL <40
and ad.dept_id is not null