POQ_QUES_ACC_RESPONSES_VL

Details

• Schema: FUSION

• Object owner: POQ

• Object type: VIEW

Columns

Name

ACC_RESPONSE_ID RESPONSE_TEXT QUESTION_ID DISPLAY_SEQUENCE PREFERRED_RESPONSE_FLAG ATTACHMENT_ALLOWED_CODE MAPPED_TO_PREREQ_ACC_RESP_ID ATTRIBUTE_ID ATTRIBUTE_CODE ATTRIBUTE_CODE2 CATEGORY_ID CATEGORY_NAME PARENT_CATEGORY_ID PURCHASING_CAT_FLAG ORIGINAL_ACC_RESPONSE_ID EXCLUDE_SCORING_FLAG SCORE CRITICAL_RESPONSE_FLAG OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.ACC_RESPONSE_ID, T.RESPONSE_TEXT, B.QUESTION_ID, B.DISPLAY_SEQUENCE, B.PREFERRED_RESPONSE_FLAG, B.ATTACHMENT_ALLOWED_CODE, B.MAPPED_TO_PREREQ_ACC_RESP_ID, B.ATTRIBUTE_ID, B.ATTRIBUTE_CODE, B.ATTRIBUTE_CODE2, B.CATEGORY_ID, B.CATEGORY_NAME, B.PARENT_CATEGORY_ID, B.PURCHASING_CAT_FLAG, B.ORIGINAL_ACC_RESPONSE_ID, B.EXCLUDE_SCORING_FLAG, B.SCORE, B.CRITICAL_RESPONSE_FLAG, B.OBJECT_VERSION_NUMBER, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN FROM POQ_QUES_ACC_RESPONSES_B B, POQ_QUES_ACC_RESPONSES_TL T where T.ACC_RESPONSE_ID = B.ACC_RESPONSE_ID AND T.LANGUAGE = USERENV('LANG')