POQ_QUAL_AREA_ALL_QUESTIONS_V

Details

• Schema: FUSION

• Object owner: POQ

• Object type: VIEW

Columns

Name
QUAL_AREA_QUESTION_ID OBJECT_VERSION_NUMBER QUAL_AREA_ID QUESTION_ID DISPLAY_SEQUENCE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN ROOT_QUESTION_ID CHILD_QUESTION_ID BRANCH_LEVEL MAPPED_TO_PREREQ_QUESTION_ID WEIGHT KNOCKOUT_SCORE

Query

SQL_Statement

SELECT QAQ.QUAL_AREA_QUESTION_ID, QAQ.OBJECT_VERSION_NUMBER, QAQ.QUAL_AREA_ID, QAQ.QUESTION_ID, QAQ.DISPLAY_SEQUENCE, QAQ.CREATION_DATE, QAQ.CREATED_BY, QAQ.LAST_UPDATE_DATE, QAQ.LAST_UPDATED_BY, QAQ.LAST_UPDATE_LOGIN, QUESSTRUCT.ROOT_QUESTION_ID, QUESSTRUCT.QUESTION_ID CHILD_QUESTION_ID, QUESSTRUCT.BRANCH_LEVEL, QUESSTRUCT.MAPPED_TO_PREREQ_QUESTION_ID, QAQ.WEIGHT, QAQ.KNOCKOUT_SCORE FROM POQ_QUESTION_STRUCTURE_V QUESSTRUCT, POQ_QUAL_AREA_QUESTIONS QAQ WHERE QAQ.QUESTION_ID = QUESSTRUCT.ROOT_QUESTION_ID