I have a working BOM recursive CTE, much like this one, but now I need to be able to input the part number I need the BOM from and have no clue how to do it.

If I put in a where clause right after the first part of the CTE with a specific part number it will give me the results I need but I need to be able to tell the database which part number I need the BOM from easily.

Any ideas on how to achieve this?