КУВД без принятых решений но с правами

select
(select ap.NO from app_applications ap where ap.id=ape.app_id) "КУВД"
,ape.*
from
app_re ape
where
APE.r_type is null
and APE.APP_ID in (
select APR.APP_ID
from app_rt apr
where APR.APP_ID = APE.APP_ID
)