Generating a indented BOM list report.
I'm trying to generate a report with the indented list of a BOM. In Oracle 10 we had fields to build the structure based on a starting node and then just following the IDs, but i FUSION on these two tables i'm truggling to find a thread to just follow and build the cycle query:
Perhaps I need to use another middle table? Just use the item id? Any tip would be welcome.