Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page.
X
We would like to create bom reports directly from our oracle server and I am only starting with sql queries . Does anyone know how to query for a bom (latest iteration) from a top level number ?
This would give you an initial idea: Extract partnumber, revision and description. But even if you're going to build a "single-level" BOM, query would be quite complex. Not to mention multi-level BOMs.
