POQ_QUESTION_STRUCTURE_V
Details
-
Schema: FUSION
-
Object owner: POQ
-
Object type: VIEW
Columns
Name |
---|
ROOT_QUESTION_ID QUESTION_ID BRANCH_LEVEL MAPPED_TO_PREREQ_QUESTION_ID |
Query
SQL_Statement |
---|
SELECT DISTINCT CONNECT_BY_ROOT(Q.QUESTION_ID) ROOT_QUESTION_ID, Q.QUESTION_ID, LEVEL BRANCH_LEVEL, Q.MAPPED_TO_PREREQ_QUESTION_ID FROM POQ_QUESTIONS_VL Q, POQ_QUES_ACC_RESPONSES_VL ACC, POQ_QUESTION_BRANCHES BRNCH WHERE Q.QUESTION_ID = ACC.QUESTION_ID(+) AND ACC.ACC_RESPONSE_ID =BRNCH.ACC_RESPONSE_ID(+) CONNECT BY PRIOR BRNCH.BRANCH_TO_QUESTION_ID= Q.QUESTION_ID |