passing a sql view with a parameter to acumatica

Is it possible to pass a sql view with an "emtpy" spot to be filled out by a report parameter to acumatica? We wanted to use the mutli level bom for verifying our boms but it is missing information that we need. So I am creating my own as a cte  that uses the recursive statement to blow through the boms and show information for every level. I want to pass this as a view to acumatica. I think it should be done for 1 bom at a time because it would be too exhaustive on the system if it was trying to do all of them at once. How would I set it up so that I can do that? Screen shot of the section im talking about. The goal is to make a report and add it to the side panel of "Bill of Materials" , so that designers can print it out when they build the prototype and compare the Acumatica BOM to what they actually use. This would be a final checkoff before we deem it "Production Ready". I may be over thinking it, but I cant seem to think of a way to pass it over with the "blank" so that the paramater on the report will be the input for the parameter in the CTE. Or should i just pass it over without the "blank" and just make sure its only ever used in a report and or a GI that has a parameter. I also put this statement in AUGSql to double check that the output is the same.