with t as (
            select 1 n, 79330.05 summ from dual union all
            select 2, 244984.91 from dual union all
            select 3, 53153.55 from dual union all
            select 4, 13813.83 from dual union all
            select 5, 96 from dual union all
            select 6, 1123 from dual union all
            select 7, 70 from dual union all
            select 8, 92008.08 from dual ) ,
     o as (
            select 1 n, 100000 summ from dual union all
            select 2, 100000 from dual union all
            select 3, 55000 from dual union all
            select 4, 55000 from dual union all
            select 5, 55000 from dual union all
            select 6, 55000 from dual union all
            select 7, 64579.42 from dual) 

номер     номер    сумма фактической 
транша	оплаты	оплаты транша
1	1	79 330,05
2	1	20 669,95
2	2	100 000,00
2	3	55 000,00
2	4	55 000,00
2	5	14 314,96
3	5	40 685,04
3	6	12 468,51
4	6	13 813,83
5	6	96
6	6	1 123,00
7	6	70
8	6	27 428,66
8	7	64 579,42