with deps (id , qty) as 
(select 1,100 from dual union all
 select 2,50 from dual union all
 select 3,40 from dual union all
 select 4,10 from dual
),
tables (t_id, t_qty) as 
(select 101,100 from dual union all
 select 102,100 from dual union all
 select 103,40 from dual union all
 select 104,10 from dual
)
select d.id, t.t_id, 
case when d.qty <= t.t_qty then 'ok'
                           else 'no'
end fit_for
from 
(select id, qty, row_number() over (order by qty desc) drn from deps) d
left join
(select t_id, t_qty, row_number() over (order by t_qty desc) trn from tables) t on ( d.drn = t.trn)