POQ_ALL_SURVEY_RESPONSES_V
Details
-
Schema: FUSION
-
Object owner: POQ
-
Object type: VIEW
Columns
Name |
---|
RESPONSE_REPOSITORY_ID OBJECT_VERSION_NUMBER QUESTION_ID SUPPLIER_ID SUPPLIER_SITE_ID RESPONSE_SUBMISSION_DATE RESPONSE_COMMENTS ACCEPTANCE_DATE ACCEPTANCE_NOTE ACCEPTED_BY DATA_SOURCE_TYPE DATA_SOURCE_ID INTERNAL_RESPONDENT_ID ORIGINAL_QUESTION_ID REQUEST_ID MERGE_REQUEST_ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN AGGREGATE_RESPONSE_FLAG AGGREGATE_RESPONSE_VALUE QUESTION_RESP_SCORE LATEST_RESP_FLAG JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE REPOS_SURVEY_RESPONSE_ID AGGREGATE_RESPONSES_COUNT |
Query
SQL_Statement |
---|
SELECT poq_response_repository.response_repository_id, poq_response_repository.object_version_number, NULL question_id, NULL supplier_id, NULL supplier_site_id, poq_response_repository.response_submission_date, poq_response_repository.response_comments, poq_response_repository.acceptance_date, poq_response_repository.acceptance_note, poq_response_repository.accepted_by, poq_response_repository.data_source_type, poq_response_repository.data_source_id, poq_response_repository.internal_respondent_id, poq_response_repository.original_question_id, poq_response_repository.request_id, poq_response_repository.merge_request_id, poq_response_repository.creation_date, poq_response_repository.created_by, poq_response_repository.last_update_date, poq_response_repository.last_updated_by, poq_response_repository.last_update_login, poq_response_repository.aggregate_response_flag, decode(acc_response_id, NULL, NULL, - 99, 'Multiple', acc_response_text) aggregate_response_value, NULL question_resp_score, NULL latest_resp_flag, NULL job_definition_name, NULL job_definition_package, NULL repos_survey_response_id, poq_qualifications_pkg.QUES_SURVEY_RESPONSES_COUNT(poq_response_repository.response_repository_id) aggregate_responses_count FROM poq_response_repository, poq_resp_repository_values WHERE poq_response_repository.response_repository_id = poq_resp_repository_values.response_repository_id (+) AND aggregate_response_flag = 'Y' UNION SELECT poq_aggregate_rec_mapping.response_repository_id, poq_repos_survey_responses.object_version_number object_version_number, question_id, supplier_id, supplier_site_id, response_submission_date, response_comments, acceptance_date, acceptance_note, accepted_by, data_source_type, data_source_id, internal_respondent_id, original_question_id, request_id, merge_request_id, poq_repos_survey_responses.creation_date, poq_repos_survey_responses.created_by, poq_repos_survey_responses.last_update_date, poq_repos_survey_responses.last_updated_by, poq_repos_survey_responses.last_update_login, 'N' aggregate_response_flag, NULL aggregate_response_value, question_resp_score, latest_resp_flag, job_definition_name, job_definition_package, repos_survey_response_id, NULL aggregate_responses_count FROM poq_repos_survey_responses, poq_aggregate_rec_mapping WHERE poq_repos_survey_responses.repos_survey_response_id = poq_aggregate_rec_mapping.survey_response_id(+) |