VIEW: APPS.OTA_UTEST_QUESTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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