You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Generating a indented BOM list report.

Received Response
85
Views
4
Comments
edited Aug 25, 2020 3:18PM in Reporting and Analytics for SCM 4 comments

Content

Hey there,

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:

EGP_STRUCTURES_B

EGP_COMPONENTS_B

Perhaps I need to use another middle table? Just use the item id? Any tip would be welcome.

Thanks!

Version

Fusion 20C
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!