SQL Query to fetch interview feedback question and answer

Summary:

Hi Team,I want to create a report where that will fetch interview feedback questions and answers.

I have created the custom query but it's not giving the expected result, please help me with the tables and mapping. Please take a look at the query.

select distinct
ic.candidate_number,
ppnfv.full_name,
irv.requisition_number,
TO_CHAR(IIFR.EXPIRY_DATE,'DD/MM/YYYY')FEEDBACK_EXPIRY_DATE,
TO_CHAR(IIFR.COMPLETION_DATE,'DD/MM/YYYY')FEEDBACK_COMPLETION_DATE,
IIFR.RATING,
papf1.PERSON_NUMBER Respondent_EMP_NUMBER,
ppnfv1.DISPLAY_NAME Respondent_EMP_NAME,
IIFRD.FEEDBK_RESP_DETAILS_ID,
IIFRD.FEEDBACK_ID,