HWR_SRVY_QSTN_HLPR_VL

Details

• Schema: FUSION

• Object owner: HWR

• Object type: VIEW

Columns

Name
SUBSCRIBER_ID QUESTIONNAIRE_ID QUESTIONNAIRE_VERSION QUESTION_ID QUESTION_VERSION ANSWER_ID QUESTION_TYPE ANSWER_TEXT QUESTIONS_HELPER_ATTR_1 QUESTIONS_HELPER_ATTR_2 QUESTIONS_HELPER_ATTR_3 QUESTIONS_HELPER_ATTR_4 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.SUBSCRIBER_ID, B.QUESTIONNAIRE_ID, B.QUESTIONNAIRE_VERSION, B.QUESTION_ID, B.QUESTION_VERSION, B.ANSWER_ID, B.QUESTION_TYPE, T.ANSWER_TEXT, B.QUESTIONS_HELPER_ATTR_1, B.QUESTIONS_HELPER_ATTR_2, B.QUESTIONS_HELPER_ATTR_3, B.QUESTIONS_HELPER_ATTR_4, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM HWR_SRVY_QSTN_HLPR_B B, HWR_SRVY_QSTN_HLPR_TL T WHERE B.SUBSCRIBER_ID = T.SUBSCRIBER_ID AND B.QUESTIONNAIRE_ID = T.QUESTIONNAIRE_ID AND B.QUESTIONNAIRE_VERSION = T.QUESTIONNAIRE_VERSION AND B.QUESTION_ID = T.QUESTION_ID AND B.QUESTION_VERSION = T.QUESTION_VERSION AND B.ANSWER_ID = T.ANSWER_ID AND T.LANGUAGE = USERENV('LANG')