I have been on the search for a while to create a SQL query that will re-produce the same data as the Engineering Part Navigator >> Multilevel tab screen.

I think I am close:

SELECT PART_NO
     , SUB_PART_NO
     , POS
     , QTY
     , LEVEL
FROM ENG_PART_STRUCTURE_TAB EPS
START WITH PART_NO = '<<YOUR TOP LEVEL PART NUMBER>>' 
CONNECT BY PRIOR
SUB_PART_NO = PART_NO
ORDER BY LEVEL, PART_NO, SUB_PART_NO

One interesting thing is the record count from the above query doesn’t match the record count from exporting the data from the Multilevel tab exactly.  I am going to do some compares to see what might be causing this.

If anyone has done this and has input it would be greatly apricated.