Лесные участки

SELECT
O.CAD_NUM "КадНо"
,O.OBJ_NUM "УслНо"
,o.PREV_CAD_NUM "ПредНо"
,Re.CON_DESC(o.ID) "ОписОбъекта"
,O.ADR_PRN_DESC "АдресОбъекта"
,R.REG_NO "ПравоРегНо"
,R.S_DATE "ДатаПр"
,Ent.CON_DESC(en_r.ID)"СубъектПр"
,RS.REG_NO "ОгрРегНо"
,RS.S_DATE "ДатаОгр"
,Ent.CON_DESC(en_rs.ID)"СубъектОгр"
,Doc.con_desc(d.ID) "Докум"
FROM
RE_OBJECTS o
,RE_PURPOSES rps
,RT_RIGHTS r
,ENT_ENTITIES en_r
,RT_ENT rt_en_r
,RT_RS rtrs
,RT_RIGHTS rs
,ENT_ENTITIES en_rs
,RT_ENT rt_en_rs
,DOC_REL dr
,DOC_FOUNDATIONS d
WHERE

RPS.RE_ID = o.ID
AND O.E_DATE IS NULL
AND R.RE_ID=o.ID
AND R.E_DATE IS NULL
AND rt_en_r.rt_id = r.ID
AND rt_en_r.ent_id=en_r.ID

AND rtrs.rt_id=r.ID
AND rs.ID=RTRS.RS_ID
AND RS.E_DATE IS NULL
AND rt_en_rs.rt_id = rs.ID
AND rt_en_rs.ent_id=en_rs.ID

AND dr.re_s_id=o.ID
AND dr.doc_id=d.ID

AND (LOWER(o.NAME) LIKE '%лесн%учас%'
     OR (
      LOWER(o.NAME) LIKE '%зем%учас%' 
     AND rps.TYPE_CODE LIKE '15%' 
        )
    )
 
ORDER BY o.ID

Убрал документы, добавил тип права и тип ограничения

SELECT
O.CAD_NUM "КадНо"
,O.OBJ_NUM "УслНо"
,o.PREV_CAD_NUM "ПредНо"
,Re.CON_DESC(o.ID) "ОписОбъекта"
,O.ADR_PRN_DESC "АдресОбъекта"
,R.REG_NO "ПравоРегНо"
,(SELECT rtv.NAME FROM RT_RIGHTS_VOC rtv WHERE rtv.CODE=r.TYPE_CODE) "ТипПрава"
,R.S_DATE "ДатаПр"
,Ent.CON_DESC(en_r.ID)"СубъектПр"
,RS.REG_NO "ОгрРегНо"
,(SELECT rtv.NAME FROM RT_RIGHTS_VOC rtv WHERE rtv.CODE=rs.TYPE_CODE) "ТипОгр"
,RS.S_DATE "ДатаОгр"
,Ent.CON_DESC(en_rs.ID)"СубъектОгр"
FROM
RE_OBJECTS o
,RE_PURPOSES rps
,RT_RIGHTS r
,ENT_ENTITIES en_r
,RT_ENT rt_en_r
,RT_RS rtrs
,RT_RIGHTS rs
,ENT_ENTITIES en_rs
,RT_ENT rt_en_rs
WHERE
 
RPS.RE_ID = o.ID
AND O.E_DATE IS NULL
AND R.RE_ID=o.ID
AND R.E_DATE IS NULL
AND rt_en_r.rt_id = r.ID
AND rt_en_r.ent_id=en_r.ID
 
AND rtrs.rt_id=r.ID
AND rs.ID=RTRS.RS_ID
AND RS.E_DATE IS NULL
AND rt_en_rs.rt_id = rs.ID
AND rt_en_rs.ent_id=en_rs.ID
 
AND (LOWER(o.NAME) LIKE '%лесн%учас%'
     OR (
      LOWER(o.NAME) LIKE '%зем%учас%'
     AND rps.TYPE_CODE LIKE '15%'
        )
    )
  
ORDER BY o.ID

Список регдействий

SELECT
O.CAD_NUM "КадНо"
,O.OBJ_NUM "УслНо"
,o.PREV_CAD_NUM "ПредНо"
,Re.CON_DESC(o.ID) "ОписОбъекта"
,O.ADR_PRN_DESC "АдресОбъекта"
,R.REG_NO "РегНо"
,(SELECT rtv.NAME FROM RT_RIGHTS_VOC rtv WHERE rtv.CODE=r.TYPE_CODE) "Регдействие"
,R.S_DATE "ДатаПр"
,Ent.CON_DESC(en_r.ID)"СубъектПр"
FROM
RE_OBJECTS o
,RE_PURPOSES rps
,RT_RIGHTS r
,ENT_ENTITIES en_r
,RT_ENT rt_en_r
WHERE
 
RPS.RE_ID = o.ID
AND O.E_DATE IS NULL
AND R.RE_ID=o.ID
AND R.E_DATE IS NULL
AND rt_en_r.rt_id = r.ID
AND rt_en_r.ent_id=en_r.ID
 
AND (LOWER(o.NAME) LIKE '%лесн%учас%'
     OR (
      LOWER(o.NAME) LIKE '%зем%учас%'
     AND rps.TYPE_CODE LIKE '15%'
        )
    )
ORDER BY o.ID