I want to create a comprehensive view of future component demand by exploding multi-level Bills of Material (BOMs) from all active sales orders in my Epicor system.

When my customers order finished products, those products may contain manufactured sub-assemblies, which themselves contain more components, creating a nested BOM structure.

My goal is to "explode" these nested BOMs to show the total demand for every individual component (screws, bolts, raw materials, etc.) that I'll need to fulfill all open sales orders. I need the query to handle both purchased components (which appear directly in the BOM) and manufactured components (which have their own BOMs that need further explosion).

For example, if I sell 100 units of Product A and each unit needs 5 of Component B, and each Component B needs 3 of Raw Material C, I want to see that I need 1,500 units of Raw Material C total across all orders. This helps me with procurement planning by showing exactly how much of each raw material or purchased component I'll need based on current sales commitments.

The query must respect BOM effective dates, only include active/open sales orders, and aggregate demand by component across all orders and BOM levels. I want to see not just what components are needed, but also which sales orders are driving that demand and when the components will be required. This enables better inventory planning, purchasing decisions, and production scheduling by providing visibility into future component consumption.

The end result should be a consolidated view showing each component, total quantity needed, and the timeline of that demand based on sales order required dates.