Количество ЗемУч сельхозназначений меньше 2га

Условия
Земучастки сельхозназнач;
Площадь меньше 2га(20000кв.м)
ДатаРег после 2002г

Объекты

SELECT
O.CAD_NUM||O.OBJ_NUM "КадУслНо"
,(CASE
    WHEN o.TSQ_UNITS=10 THEN O.TOTAL_SQ
    WHEN o.TSQ_UNITS=20 THEN O.TOTAL_SQ*10000 
  END) "Площадь_КвМ"
,ADR_PRN_DESC "Адрес"
,o.CON_DESC "Описание"
,DECODE(o.DEPT_ID,o.DEPT_ID,(SELECT dept.SHORT_NAME FROM RP_DEPTS dept WHERE dept.ID=o.DEPT_ID)) "Отдел"
,DECODE(rps.TYPE_CODE,rps.TYPE_CODE,(SELECT TO_CHAR(rpv.NAME) FROM RE_PURPOSE_VOC rpv WHERE rpv.CODE=rps.TYPE_CODE)) "Назначение"
,rps.DIF_PURPOSE "НазначДоп"  
FROM 
RE_OBJECTS o
,RE_PURPOSES rps

WHERE
o.ID=rps.re_id

AND rps.TYPE_CODE LIKE '11____'

AND (CASE
    WHEN o.TSQ_UNITS=10 THEN O.TOTAL_SQ
    WHEN o.TSQ_UNITS=20 THEN O.TOTAL_SQ*10000 
  END)<20001

AND (SELECT COUNT(r.ID) FROM RT_RIGHTS r WHERE o.ID=r.re_id AND r.s_date>'01.01.2002')>0  

Сводная

SELECT
DECODE(o.DEPT_ID,o.DEPT_ID,(SELECT dept.SHORT_NAME FROM RP_DEPTS dept WHERE dept.ID=o.DEPT_ID)) "Отдел"
,DECODE(rps.TYPE_CODE,rps.TYPE_CODE,(SELECT TO_CHAR(rpv.NAME) FROM RE_PURPOSE_VOC rpv WHERE rpv.CODE=rps.TYPE_CODE)) "Назначение"
,rps.DIF_PURPOSE "НазначДоп"  
,count (o.id) "Колво"

FROM 
RE_OBJECTS o
,RE_PURPOSES rps

WHERE
o.ID=rps.re_id

AND rps.TYPE_CODE LIKE '11____'

AND (CASE
    WHEN o.TSQ_UNITS=10 THEN O.TOTAL_SQ
    WHEN o.TSQ_UNITS=20 THEN O.TOTAL_SQ*10000 
  END)<20001

AND (SELECT COUNT(r.ID) FROM RT_RIGHTS r WHERE o.ID=r.re_id AND r.s_date>'01.01.2002')>0  
group by o.DEPT_ID,rps.TYPE_CODE,rps.DIF_PURPOSE

Статистика верификации по земле

select 
he.DESCR "Описаниеошибки"
,he.ADDRESS "Адрес"
,he.ADDITIONAL  "ДопСв"
--,he.ERR_DESC "ОписОшибки"
,he.CHANGE_TEXT "ПредлИзм"
,decode(he.TYPE_ID,he.TYPE_ID,(select RV.NAME from HEP_ERRORS_TYPE_VOC rv where rv.id=he.TYPE_ID)) "ТипОшиб"

,he.DECISION "РешРегстр"
,he.DEPT_ID  "Предст"
,he.VALUE  "ПравЗнач"

from
HEP_ERRORS he
,re_objects o
where
o.id=he.re_id
and o.r_type=1
and HE.PROT_ID=198294000

select 
decode(he.TYPE_ID,he.TYPE_ID,(select RV.NAME from HEP_ERRORS_TYPE_VOC rv where rv.id=he.TYPE_ID)) "ТипОшиб"
,count (he.id) "КолВо"
from
HEP_ERRORS he
,re_objects o
where
o.id=he.re_id
and o.r_type=1
and HE.PROT_ID= 198294000
group by he.TYPE_ID

8Форма за счет заемных средств

select
--count(ap.id) "КолВоКУВД"
AP.NO
,decode(r.TYPE_CODE,r.TYPE_CODE,(select RV.NAME from rt_rights_voc rv where rv.code=r.type_code)) "ТипПрава"
,(select wm_concat(' '||(SELECT bv.NAME FROM BRG_BARGAINS_VOC bv WHERE bv.CODE=b.TYPE_CODE)) from brg_bargains b where b.id=r.brg_id) "Сделка"
from
app_applications ap
,app_switch aps
,app_rt art
,rt_rights r
where
AP.ID=APS.APP_ID
and ap.id=art.app_id
and r.id=art.rt_id

and r_type=2
and r.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')