Query Supplier contact name based on Job title

Summary:

Where to extract supplier contact name based on job title

Content (please ensure you mask any confidential information):

I am creating a data model using SQL to report some contract attributes and supplier attributes (see screenshot below). 

Which Oracle table or view stores contract headers, parties, and supplier ID or number?

My goal is to join the data from both contract and supplier side.

Version (include the version you are using, if applicable):

24D

Code Snippet (add any code snippets that support your topic, if applicable):

Need to print the additional data below.