oracle recruiting hiring event, need sql for Interviewer Responses

Summary:

we created events and interviewers shortlisted and give comments. we need to build BI publisher report to show event name, interviewer name, candidate name, shortlisted yes or no, Comments. this data is from the following form.

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):