Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Generating a indented BOM list report. — Cloud Customer Connect
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
25
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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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