create table try_int
  (
   int_id number primary key,
   fk_ln_no number,  
   int_amount number,
   int_date date
  );

create table try_trans
  (
  trans_id number primary key,
  fk_ln_no number,
  trans_type number,
  trans_amout number,
  trans_date date
  );

insert all
  INTO try_int values (1, 100, 0, to_date('01-01-2000','dd-mm-yyyy'))
  INTO try_int values (2, 100, 0, to_date('01-01-2000','dd-mm-yyyy'))
  INTO try_int values (3, 100, 5055, to_date('01-01-2000','dd-mm-yyyy'))
  INTO try_int values (4, 100, 0, to_date('01-01-2001','dd-mm-yyyy'))
  INTO try_int values (5, 100, 0, to_date('01-01-2001','dd-mm-yyyy'))
  INTO try_int values (6, 100, 4320, to_date('01-01-2001','dd-mm-yyyy'))
  INTO try_int values (7, 200, 0, to_date('01-01-2001','dd-mm-yyyy'))
  INTO try_int values (8, 200, 8690, to_date('01-01-2001','dd-mm-yyyy'))
  into try_trans values (101, 100,2, 300000, to_date('01-01-2000','dd-mm-yyyy'))
  into try_trans values (102, 100,2, 320000, to_date('01-01-2000','dd-mm-yyyy'))
  into try_trans values (103, 100,7, 340000, to_date('01-01-2000','dd-mm-yyyy'))
  into try_trans values (104, 100,6, 300000, to_date('01-01-2000','dd-mm-yyyy'))
  into try_trans values (105, 100,7, 100000, to_date('01-01-2001','dd-mm-yyyy'))
  into try_trans values (106, 100,6, 100000, to_date('01-01-2001','dd-mm-yyyy'))
  into try_trans values (109, 100,2, 100000, to_date('01-01-2001','dd-mm-yyyy'))
  into try_trans values (124, 100,6, 100000, to_date('01-01-2001','dd-mm-yyyy'))
  into try_trans values (600, 200,6, 200000, to_date('01-01-2001','dd-mm-yyyy'))
  into try_trans values (606, 200,7, 200000, to_date('01-01-2001','dd-mm-yyyy'))
  into try_trans values (609, 200,2, 200000, to_date('01-01-2001','dd-mm-yyyy'))
select * from dual;

alter table try_int add fk_source_tran number references try_trans;

MERGE into (select rank() over ( PARTITION by fk_ln_no, int_DATE order by int_id) ordr, 
                 try_int.*
             from try_int
            ) a
       using (select rank() over ( PARTITION by fk_ln_no, trans_DATE order by trans_type, trans_id) ordr,
                   try_trans.*
               from try_trans
               where trans_type in (2,6,7)
              ) b
        on (a.fk_ln_no = b.fk_ln_no 
            and a.ordr = b.ordr 
            and a.int_DATE= b.trans_DATE)
WHEN MATCHED THEN UPDATE SET a.fk_source_tran =b.trans_id;

SQL> MERGE into (select rank() over ( PARTITION by fk_ln_no, int_DATE order by int_id) ordr,
  2                   try_int.*
  3               from try_int
  4              ) a
  5         using (select rank() over ( PARTITION by fk_ln_no, trans_DATE order by trans_type, trans_id) ordr,
  6                     try_trans.*
  7                 from try_trans
  8                 where trans_type in (2,6,7)
  9                ) b
 10          on (a.fk_ln_no = b.fk_ln_no
 11              and a.ordr = b.ordr
 12              and a.int_DATE= b.trans_DATE)
 13  WHEN MATCHED THEN UPDATE SET a.fk_source_tran =b.trans_id;
MERGE into (select rank() over ( PARTITION by fk_ln_no, int_DATE order by int_id) ordr,
           *
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view