create table matriz_h ( 
    matriz_key                     number constraint matriz_h_matriz_key_pk primary key, 
    matriz_key_f                   number, 
    label                          varchar2(100) not null, 
    lvl                            number not null 
) 

create table totales ( 
    matriz_key                     number not null, 
    period_key                     number, 
    paa                            number 
) 

insert into matriz_h values (1, null,'1', 1)

insert into matriz_h values (2, 1,'1.1', 2)

insert into matriz_h values (3, 2, '1.1.1', 3)

insert into matriz_h values (4, 3, '1.1.1.1', 4)

insert into matriz_h values (5, 4, '1.1.1.1.1', 5)

insert into matriz_h values (6, 4, '1.1.1.1.2', 5)

insert into matriz_h values (7, 4, '1.1.1.1.3', 5)

insert into matriz_h values (8, 4, '1.1.1.1.4', 5)

insert into matriz_h values (9, 3, '1.1.1.2', 4)

insert into matriz_h values (10, 9, '1.1.1.2.1', 5)

insert into matriz_h values (11, 9, '1.1.1.2.2', 5)

insert into matriz_h values (12, 9, '1.1.1.2.3', 5)

insert into matriz_h values (13, 9, '1.1.1.2.4', 5)

insert into matriz_h values (14, 3, '1.1.2', 3)

insert into matriz_h values (15, 14, '1.1.2.1', 4)

insert into matriz_h values (16, 15, '1.1.2.1.1', 5)

insert into matriz_h values (17, 15, '1.1.2.1.2', 5)

insert into matriz_h values (18, 15, '1.1.2.1.3', 5)

commit

insert into totales values (5, 1, 10)

insert into totales values (7, 1, 50)

insert into totales values (8, 1, 40)

insert into totales values (9, 1, 20)

insert into totales values (11, 1, 35)

insert into totales values (13, 1, 45)

insert into totales values (15, 1, 35)

insert into totales values (16, 1, 100)

insert into totales values (17, 1, 20)

insert into totales values (18, 1, 20)

commit

insert into matriz_h values (19, null,'2', 1)

insert into matriz_h values (20, 19,'2.1', 2)

insert into matriz_h values (21, 20,'2.1.1', 3)

insert into matriz_h values (22, 21,'2.1.1.1', 4)

insert into matriz_h values (23, 22,'2.1.1.1.1', 5)

insert into matriz_h values (24, 22,'2.1.1.1.2', 5)

insert into matriz_h values (25, 22,'2.1.1.1.3', 5)

insert into matriz_h values (26, 20,'2.1.2', 3)

insert into matriz_h values (27, 26,'2.1.2.1', 4)

insert into matriz_h values (28, 27,'2.1.2.1.1', 5)

insert into matriz_h values (29, 27,'2.1.2.1.2', 5)

insert into totales values (23, 1, 30)

insert into totales values (25, 1, 70)

insert into totales values (27, 1, 55)

insert into totales values (28, 1, 65)

insert into totales values (28, 1, 75)

commit