Отбор внутри вьюшки

Примеры для отбора внутри вьюшки

and t.docdate <= nvl(f.DATETO, t.docdate)

and nvl(T.ADDR_USER, B.AUTHID) = B.AUTHID
and T.ADDR_USER is null or T.ADDR_USER = B.AUTHID

and lpad(t.docnumb, 10) <= lpad(nvl(f.NUMTO, t.docnumb), 10)
and ( nvl(sp.sbalunit, 'sbalunit') = nvl(nvl(f.BALUNIT,sp.sbalunit), 'sbalunit') or
f.BALUNIT = '()' and sp.sbalunit is null or
strinlike(sp.sbalunit, replace(f.BALUNIT,'*','%'),';','()')!=0 )

and (nvl(t.execdate, 777) = nvl(nvl(f.the_year, t.execdate), 777)
or f.THE_YEAR = -1)

and d.bunit_mnemo like f_d_sfield_isnull (replace (replace(
(select str_val from V_R_USERS_PARAMS_PAIDSERVICES
where authid = user and unitcode = 'PayServceFilter' and paramcode = 'spbe'), '?', '_'), '*', '%'))

and (case
when f.NOTEOP = 1 and sp.deop_date is null then
1
when f.NOTEOP = 0 and
sp.deop_date >= nvl(f.EOP_DATE1, sp.deop_date) and sp.deop_date <= nvl(f.EOP_DATE2, sp.deop_date) then
1
when f.NOTEOP is null then
1
else
0
end) = 1

select 'ddd' from dual
where
(case
when 1 = 1 then
1
when 2 = 2 then
1
when null is null then
1
else
0
end) = 1
--Вывод:ddd. Если все условия ложные, то ничего не выводит