POQ_QUESTIONS_VL

Details

• Schema: FUSION

• Object owner: POQ

• Object type: VIEW

Columns

Name

QUESTION_ID QUESTION_TEXT QUESTION_HINT PREFERRED_RESPONSE_TEXT ORIGINAL_QUESTION_ID REVISION_NUMBER QUESTION_NAME QUESTION_LEVEL RESPONDER_TYPE SUPPLIER_ATTRIBUTE_FLAG QUESTION_TYPE QUESTION_STATUS MAPPED_TO_PREREQ_QUESTION_FLAG MAPPED_TO_PREREQ_QUESTION_ID OWNER_ID DISPLAY_PREFERRED_RESP_FLAG LATEST_REVISION_FLAG CRITICAL_QUESTION_FLAG RESPONSE_REQUIRED_FLAG ALLOW_RESP_COMMENT_FLAG SUBJECT_CODE STDS_ORG_CODE SUPPLIER_ATTRIBUTE_CODE RESPONSE_TYPE ATTACHMENT_ALLOWED_CODE PREFERRED_RESPONSE_DATE PREFERRED_RESPONSE_DATETIME PREFERRED_RESPONSE_NUMBER SCORING_METHOD MAXIMUM_SCORE SCORE_FOR_NO_RESPONSE SCORING_APPROACH ACTIVATION_DATE QUESTION_SURVEY_FLAG QUESTION_USAGE_CODE OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.QUESTION_ID, T.QUESTION_TEXT, T.QUESTION_HINT, T.PREFERRED_RESPONSE_TEXT, B.ORIGINAL_QUESTION_ID, B.REVISION_NUMBER, B.QUESTION_NAME, B.QUESTION_LEVEL, B.RESPONDER_TYPE, B.SUPPLIER_ATTRIBUTE_FLAG, B.QUESTION_TYPE, B.QUESTION_STATUS, B.MAPPED_TO_PREREQ_QUESTION_FLAG, B.MAPPED_TO_PREREQ_QUESTION_ID, B.OWNER_ID, B.DISPLAY_PREFERRED_RESP_FLAG, B.LATEST_REVISION_FLAG, B.CRITICAL_QUESTION_FLAG, B.RESPONSE_REQUIRED_FLAG, B.ALLOW_RESP_COMMENT_FLAG, B.SUBJECT_CODE, B.STDS_ORG_CODE, B.SUPPLIER_ATTRIBUTE_CODE, B.RESPONSE_TYPE, B.ATTACHMENT_ALLOWED_CODE, B.PREFERRED_RESPONSE_DATE, B.PREFERRED_RESPONSE_DATETIME, B.PREFERRED_RESPONSE_NUMBER, B.SCORING_METHOD, B.MAXIMUM_SCORE, B.SCORE_FOR_NO_RESPONSE, B.SCORING_APPROACH, B.ACTIVATION_DATE, B.QUESTION_SURVEY_FLAG, B.QUESTION_USAGE_CODE, B.OBJECT_VERSION_NUMBER, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM POQ_QUESTIONS_B B, POQ_QUESTIONS_TL T WHERE T.QUESTION_ID = B.QUESTION_ID AND T.LANGUAGE = USERENV('LANG')