Статистика по заявителям

Заявители КУВД

select
ap.id 
,AP.R_DATE "ДакаКУВД"
,AP.SUBJECT "Цель"
,(select wm_concat(RE.CON_DESC(are.re_id)||';') from app_re are where are.app_id=ap.id) "Объект"
,en.NAME "Субъект"
from
app_applications ap
,app_ent aen
,ent_entities en
where
ap.R_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and AEN.APP_ID=AP.ID
and AEN.ENT_ID=en.ID

Заявители КУВИ

select
qa.id
 
,qa.S_DATE "ДакаКУВИ"
,qa.qu_Desc "Цель"

,en.NAME "Субъект"

from
qu_applications qa
,ent_entities en
where
qa.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and EN.ID=qa.ENT_ID