Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

with q as
( select 1 id, 0 parent_id, 'NumDoc' name, '63' value from dual
    union all 
  select 2,0,'Groups',null from dual 
    union all
  select 4,3,'Group','ALM' from dual 
    union all
  select 5,3,'Vals',null  from dual 
    union all
  select 7,6,'ValCode','USD' from dual 
    union all
  select 10,9,'ValCode','CHF' from dual 
    union all
  select 11,3,'Group','TLD' from dual  
    union all
  select 12,3,'Vals',null from dual  
    union all
  select 14,13,'ValCode','USD' from dual         
    union all
  select 17,16,'ValCode','RUB' from dual          
)
select q1.value "Numdoc", 
       q2.value "Group", 
       q3.value "Valcode"  
 from (select id, value, lead(id) over (order by id) next_numdoc_id
         from q
        where name='NumDoc') q1
 join (select id, value, lead(id) over (order by id) next_group_id
         from q
        where name='Group') q2
   on q2.id between q1.id and nvl(q1.next_numdoc_id-1,q2.id)      
 join (select id, value
         from q
        where name='ValCode') q3
   on q3.id between q2.id and nvl(q2.next_group_id-1,q3.id)     
 order by q1.value, q2.value, q3.value

Numdoc	Group	Valcode
63	ALM	CHF
63	ALM	USD
63	TLD	RUB
63	TLD	USD