Oracle Fusion Supplier Qualification Questions and Response Details Query

SELECT

pos.segment1 supplier_number,

poqq.question_name,

poq_resp_value.acc_response_text

poq_resp_value.response_value_num,

poq_resp_value.response_value_text

FROM poq_repos_survey_resp_values poq_resp_value,

poq_repos_survey_responses poq_resp_survey,

poq_questions poqq,

poz_suppliers pos

WHERE 1=1

        and poq_resp_value.repos_survey_response_id=poq_resp_survey.repos_survey_response_id

and poq_resp_survey.supplier_id=pos.vendor_id

and poqq.question_id=poq_resp_survey.question_id