Oddly enough I had this asked of me today and I found my recursive BOM Explosion BAQ that this site helped me create. And I thought it’s really just the same thing in reverse. So I’m posting this here to help anyone who might find this thread and have some use. I’m also looking to see if I’m missing something important. But it looks to do what you’d expect. Essentially I just reversed the join on the recursive subquery from MtlPartNum = PartNum to PartNum = MtlPartNum. I also filter out inactive top-level BOMs and I filtered to only approved revisions (so you don’t see all the noise of out of date revisions).
DMR_WhereUsedTopLevel.baq (170.5 KB)