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.