EPP Report that includes Supplier Name

We have created a custom report for EPP that allows the contract team to monitor expiration dates for EPP contracts. The users would like to add the Supplier Name. There is only Vendor_ID in the SCH_EPP_HEADERS table, not the name. How do I update the SQL for the correct table, join to pull the Supplier Name?

Thank you!