VIEW: APPS.OTA_TEST_SECTIONS_V

Source

View Text - Preformatted

SELECT utq.USER_TEST_QUESTION_ID ,utq.OBJECT_TYPE_FLAG ,utq.ATTEMPT_ID , section.CORRECT_FEEDBACK , section.WRONG_FEEDBACK , test.CORRECT_FEEDBACK ,test.WRONG_FEEDBACK , test.FEEDBACK_TYPE_FLAG ,section.NAME ,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

View Text - HTML Formatted

SELECT UTQ.USER_TEST_QUESTION_ID
, UTQ.OBJECT_TYPE_FLAG
, UTQ.ATTEMPT_ID
, SECTION.CORRECT_FEEDBACK
, SECTION.WRONG_FEEDBACK
, TEST.CORRECT_FEEDBACK
, TEST.WRONG_FEEDBACK
, TEST.FEEDBACK_TYPE_FLAG
, SECTION.NAME
, 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