View: OTA_TEST_SECTIONS_V

Product:	OTA - Learning Management
Description:
Implementation/DBA Data:	APPS.OTA_TEST_SECTIONS_V

View Text

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

Columns