Here is a post in a thread that goes pretty deeply into examples where CTE is trying to do job bill of material type stuff. See if there are some examples in any of those threads that might help you get something working.
~If you want to recursively traverse the BOM you may need a CTE query?~ - Kinetic 202X - Epicor User Help Forum (epiusers.help)
1 Like