merge into a
using (select b.quote_oid,
b.net_amout,
row_number() over(partition by b.quote_oid order by line_num) rn
from b
where b.status <> 40) t
on (a.id = t.quote_oid and t.rn = 1)
when matched then
update set a. net_amount = t.net_amout;
update a
set net_amount =
(select net_amount
from b
where b.quote_oid = a.oid
and status <> 40
and line_num = (select min(line_num)
from b c
where c.quoto_oid = a.oid
and status <> 40))
