select
  t1.<some fields>, t2.<some fields>, <etc.>
from
  table1 t1
    left outer join
  table2 t2
    on t1.pk = t2.fk
    left outer join
  table3 t3
    on t3.pk = t2.fk
   <etc. много(~10) таблиц>
where ( param1 is null
        or
        ( param1 is not null and t2.param1 like '%'||param1||'%' )
       )
  and ( param2 is null
        or
        ( param2 is not null and nvl(t2.param2, t3.param2) like '%'||param2||'%' )
       )
  and ( param3 is null
        or
        ( param3 is not null and t3.param3 like '%'||param3||'%' )
       )
  <etc. много(~15) параметров>

select
  t1.<some fields>, t2.<some fields>, <etc.>
from
  table1 t1
    left outer join
  table2 t2
    on t1.pk = t2.fk
    left outer join
  table3 t3
    on t3.pk = t2.fk
   <etc. много(~10) таблиц>
where  t3.param3 like '%'||param3||'%'