# Build BOM in Query

**URL:** <https://www.epiusers.help/t/build-bom-in-query/78014>\
**Category:** Epicor ERP 10\
**Tags:** baq\
**Created:** [April 26, 2021, 12:51pm UTC](https://www.epiusers.help/t/build-bom-in-query/78014 "2021-04-26T12:51:39Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\
**Post date:** [April 26, 2021, 2:17pm UTC](https://www.epiusers.help/t/build-bom-in-query/78014/5 "2021-04-26T14:17:07Z")

</div>

Take a look at this thread.

> [@Looking for SQL SP or Code to list full BOM for a part](https://www.epiusers.help/t/looking-for-sql-sp-or-code-to-list-full-bom-for-a-part/38193/11):
>
> Here is a new base query we use. It has held up for about a year now. You may need to adjust the query a bit for your environment. with [BOMReviewParent] as (select (Part.ShortChar10) as [Calculated\_Customer], (PartRev.PartNum) as [Calculated\_TopPart], (PartRev.RevisionNum) as [Calculated\_TopPartRev], (part.PartNum) as [Calculated\_ParentPartNum], (PartRev.RevisionNum) as [Calculated\_ParentRevNum], (part.PartNum) as [Calculated\_ChildPartNum], (PartRev.RevisionNum) as [Calculated\_Ch…

---

_[View the full topic](https://www.epiusers.help/t/build-bom-in-query/78014)._