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.
