POQ_QUAL_AREA_ALL_QUESTIONS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: POQ
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 |
問合せ
| 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 |