CTE BAQ to drill up through PartDtl

Has anyone developed a Baq to drill up through the PartDtl table to see the final Requirement record for parts manufactured within an assembly.

For example, if we have a bill of materials with 4 levels - I want to be able to show the Sales Order is due on x date against all the manufactured Jobs for the sub assemblies where sub assemblies are all separate Jobs on a Make To Stock basis.

Roberto

I have for JobProd, SerialMatch - not for PartDtl. Wasnt too hard, took 20min.