POQ_QUESTIONS

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 CREATION_SOURCE OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

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

CREATION_SOURCE

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.CREATION_SOURCE, 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')

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.CREATION_SOURCE,

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')