Product: | OTA - Learning Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OTA_UTEST_QUESTIONS_V |
SELECT UTQ.USER_TEST_QUESTION_ID
, UTQ.OBJECT_TYPE_FLAG
, UTQ.ATTEMPT_ID
, UTR.USER_TEST_RESPONSE_ID
, RVALUE.CORRECT_FLAG
, UTQ.SKIPPED_FLAG
, UTR.RESPONSE_VALUE_ID
, UTR.QUESTION_ID
, UTR.TEXT
, UTR.RESPONSE_TYPE_ID
, UTR.ANSWERED_FLAG
, UTQ.SUGGESTED_POINTS
, UTQ.POINTS_AWARDED
, RTYPE.TYPE_FLAG
, RTYPE.CORRECT_FEEDBACK
, RTYPE.WRONG_FEEDBACK
, RVALUE.TEXT
, Q.TEXT
, SECTION_CORRECT_FEEDBACK
, SECTION_WRONG_FEEDBACK
, TEST_CORRECT_FEEDBACK
, TEST_WRONG_FEEDBACK
, FEEDBACK_TYPE_FLAG
, SECTION_DESCRIPTION
, UTQ.PARENT_ID
, SECTION_NAME
, MANDATORY_FLAG
, Q.ALLOW_HTML_FLAG
, MARKED_FOR_REVIEW_FLAG
FROM OTA_UTEST_QUESTIONS UTQ
, OTA_UTEST_RESPONSES UTR
, OTA_RESPONSE_TYPES RTYPE
, OTA_RESPONSE_VALUES RVALUE
, OTA_QUESTIONS Q
, ( SELECT UTQ.USER_TEST_QUESTION_ID
, UTQ.OBJECT_TYPE_FLAG
, UTQ.ATTEMPT_ID
, SECTION.CORRECT_FEEDBACK SECTION_CORRECT_FEEDBACK
, SECTION.WRONG_FEEDBACK SECTION_WRONG_FEEDBACK
, TEST.CORRECT_FEEDBACK TEST_CORRECT_FEEDBACK
, TEST.WRONG_FEEDBACK TEST_WRONG_FEEDBACK
, TEST.FEEDBACK_TYPE_FLAG
, SECTION.NAME SECTION_NAME
, SECTION.DESCRIPTION SECTION_DESCRIPTION
, SECTION.MANDATORY_FLAG
, SECTION.TEST_SECTION_ID SECTION_ID
FROM OTA_UTEST_QUESTIONS UTQ
, OTA_TEST_SECTIONS SECTION
, OTA_TESTS TEST
WHERE OBJECT_TYPE_FLAG = 'S'
AND UTQ.OBJECT_ID = SECTION.TEST_SECTION_ID
AND SECTION.TEST_ID = TEST.TEST_ID ) UTSEC
WHERE UTQ.OBJECT_TYPE_FLAG = 'Q'
AND UTQ.USER_TEST_QUESTION_ID = UTR.USER_TEST_QUESTION_ID
AND UTQ.PARENT_ID = UTSEC.USER_TEST_QUESTION_ID
AND UTR.QUESTION_ID = Q.QUESTION_ID
AND UTR.RESPONSE_VALUE_ID = RVALUE.RESPONSE_VALUE_ID
AND UTR.RESPONSE_TYPE_ID = RTYPE.RESPONSE_TYPE_ID