@LizaAleman I would do this the same way as the link below using GetRowsPlant.
Part should work like that, but you have an inner join to JobProd and I think even buy direct material will be an outer join to JobMtl on jobNum, AsmSeq and MtlSeq.
If the material is not buy direct then it is doable, but more complex to match the suggestion to the job material(s)