POQ_ALL_SURVEY_RESPONSES

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

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(+)

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(+)