Hello here's my SQL based on a dedicated menu (B.TRRLTYPE='100') :
SELECT A.TMTASKID,A.TMTASKNM,A.TMLNGTASK,A.TMOBNM,A.TMVER,B.TRPRSSEQ
,C.TMTASKNM,C.TMLNGTASK,C.TMOBNM,C.TMVER,D.TRPRSSEQ --2 NIV
,E.TMTASKNM,E.TMLNGTASK,E.TMOBNM,E.TMVER,F.TRPRSSEQ --3 NIV
,G.TMTASKNM,G.TMLNGTASK,G.TMOBNM,G.TMVER,H.TRPRSSEQ --4 NIV
,I.TMTASKNM,I.TMLNGTASK,I.TMOBNM,I.TMVER,J.TRPRSSEQ --5 NIV
,K.TMTASKNM,K.TMLNGTASK,K.TMOBNM,K.TMVER,L.TRPRSSEQ --6 NIV
,M.TMTASKNM,M.TMLNGTASK,M.TMOBNM,M.TMVER,N.TRPRSSEQ --7 NIV
,O.TMTASKNM,O.TMLNGTASK,O.TMOBNM,O.TMVER,P.TRPRSSEQ --8 NIV
,Q.TMTASKNM,Q.TMLNGTASK,Q.TMOBNM,Q.TMVER,R.TRPRSSEQ --9 NIV
,S.TMTASKNM,S.TMLNGTASK,S.TMOBNM,S.TMVER,T.TRPRSSEQ --10 NIV
,U.TMTASKNM,U.TMLNGTASK,U.TMOBNM,U.TMVER,V.TRPRSSEQ --11 NIV
,W.TMTASKNM,W.TMLNGTASK,W.TMOBNM,W.TMVER,X.TRPRSSEQ --12 NIV
FROM PRODCTL.F9000 A,PRODCTL.F9001 B
LEFT JOIN PRODCTL.F9000 C ON C.TMTASKID=B.TRCHILDTSK
LEFT JOIN PRODCTL.F9001 D ON D.TRPARNTTSK=C.TMTASKID
LEFT JOIN PRODCTL.F9000 E ON E.TMTASKID=D.TRCHILDTSK
LEFT JOIN PRODCTL.F9001 F ON F.TRPARNTTSK=E.TMTASKID
LEFT JOIN PRODCTL.F9000 G ON G.TMTASKID=F.TRCHILDTSK
LEFT JOIN PRODCTL.F9001 H ON H.TRPARNTTSK=G.TMTASKID
LEFT JOIN PRODCTL.F9000 I ON I.TMTASKID=H.TRCHILDTSK
LEFT JOIN PRODCTL.F9001 J ON J.TRPARNTTSK=I.TMTASKID
LEFT JOIN PRODCTL.F9000 K ON K.TMTASKID=J.TRCHILDTSK
LEFT JOIN PRODCTL.F9001 L ON L.TRPARNTTSK=K.TMTASKID
LEFT JOIN PRODCTL.F9000 M ON M.TMTASKID=L.TRCHILDTSK
LEFT JOIN PRODCTL.F9001 N ON N.TRPARNTTSK=M.TMTASKID
LEFT JOIN PRODCTL.F9000 O ON O.TMTASKID=N.TRCHILDTSK
LEFT JOIN PRODCTL.F9001 P ON P.TRPARNTTSK=O.TMTASKID
LEFT JOIN PRODCTL.F9000 Q ON Q.TMTASKID=P.TRCHILDTSK
LEFT JOIN PRODCTL.F9001 R ON R.TRPARNTTSK=Q.TMTASKID
LEFT JOIN PRODCTL.F9000 S ON S.TMTASKID=R.TRCHILDTSK
LEFT JOIN PRODCTL.F9001 T ON T.TRPARNTTSK=S.TMTASKID
LEFT JOIN PRODCTL.F9000 U ON U.TMTASKID=T.TRCHILDTSK
LEFT JOIN PRODCTL.F9001 V ON V.TRPARNTTSK=U.TMTASKID
LEFT JOIN PRODCTL.F9000 W ON W.TMTASKID=V.TRCHILDTSK
LEFT JOIN PRODCTL.F9001 X ON X.TRPARNTTSK=W.TMTASKID
WHERE A.TMTASKID=B.TRPARNTTSK AND B.TRRLTYPE=A.TMTASKID AND B.TRRLTYPE='100'--AND X.TRPRSSEQ>1
ORDER BY B.TRPRSSEQ,D.TRPRSSEQ,F.TRPRSSEQ,H.TRPRSSEQ,J.TRPRSSEQ,L.TRPRSSEQ,N.TRPRSSEQ,P.TRPRSSEQ,R.TRPRSSEQ,T.TRPRSSEQ,V.TRPRSSEQ,X.TRPRSSEQ
Regards and have fun