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