Query for getting supplier contact with the user account status

Summary:

I need to fetch the contact detail of the supplier like first name, last name, Administrative Contact, status, phone, fax, email along with supplier portal user account through oracle fusion tables. However I cannot able to retrieve the status of the suppliers user account status and also the administrative flag

Can anyone help me in developing the query for retrieving all the above attributes

Content (please ensure you mask any confidential information):

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

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