There's a table: PS\_POSITION\_TBL

```none
position_nbr      reports_to              descr        
 038              143                     DIRECTOR 
 0418             143                     ADVISOR                        
 114              143                     DG                              
 346              114                     Manager                        
 202              114                     Lead 

```

The idea we want to build a hierarchy in above

case 1: 038 ,0418 and 114 reports to 143

case 2: 346 and 202 reports to 114 

so highest level is level1 which is 143 then 038,0418,114 are level 2 as they report to level 1 then 346 and 202 are level 3 and they fall under
level 3 bucket and they report to level 2 

These can go up to level 8 (MAX)

What I need is a query to get data in the below format in Oracle:

```none
level1  level2   level3  level4 level5 level6 level7 level8      descr
 143                                                             CEO            
           038                                                   DIRECTOR        
           0418                                                  ADVISOR         
           114                                                   DG              
                    346                                          Manager         
                    202                                          Lead    

```