[Home] [Help] [Dependency Information]
Object Name: | OTA_UTEST_QUESTIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OTA.OTA_UTEST_QUESTIONS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_TEST_QUESTION_ID | NUMBER | (15) | Yes | |
OBJECT_TYPE_FLAG | VARCHAR2 | (1) | Yes | |
ATTEMPT_ID | NUMBER | (15) | Yes | |
USER_TEST_RESPONSE_ID | NUMBER | (15) | Yes | |
CORRECT_FLAG | VARCHAR2 | (1) | Yes | |
SKIPPED_FLAG | VARCHAR2 | (1) | Yes | |
RESPONSE_VALUE_ID | NUMBER | (15) | Yes | |
QUESTION_ID | NUMBER | (15) | Yes | |
USER_RESPONSE_TEXT | VARCHAR2 | (4000) | ||
RESPONSE_TYPE_ID | NUMBER | (15) | Yes | |
ANSWERED_FLAG | VARCHAR2 | (1) | Yes | |
QUESTION_SUGGESTED_POINTS | NUMBER | (15) | ||
POINTS_AWARDED | NUMBER | (9) | ||
RESPONSE_TYPE | VARCHAR2 | (1) | Yes | |
CORRECT_FEEDBACK | VARCHAR2 | (4000) | ||
WRONG_FEEDBACK | VARCHAR2 | (4000) | ||
RESPONSE_VALUE_TEXT | VARCHAR2 | (4000) | Yes | |
QUESTION_TEXT | VARCHAR2 | (4000) | Yes | |
SECTION_CORRECT_FEEDBACK | VARCHAR2 | (4000) | ||
SECTION_WRONG_FEEDBACK | VARCHAR2 | (4000) | ||
TEST_CORRECT_FEEDBACK | VARCHAR2 | (4000) | ||
TEST_WRONG_FEEDBACK | VARCHAR2 | (4000) | ||
FEEDBACK_TYPE_FLAG | VARCHAR2 | (1) | Yes | |
SECTION_DESCRIPTION | VARCHAR2 | (4000) | ||
PARENT_ID | NUMBER | (9) | ||
SECTION_NAME | VARCHAR2 | (240) | Yes | |
MANDATORY_FLAG | VARCHAR2 | (1) | Yes | |
ALLOW_HTML_FLAG | VARCHAR2 | (1) | Yes | |
MARKED_FOR_REVIEW_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT USER_TEST_QUESTION_ID
, OBJECT_TYPE_FLAG
, ATTEMPT_ID
, USER_TEST_RESPONSE_ID
, CORRECT_FLAG
, SKIPPED_FLAG
, RESPONSE_VALUE_ID
, QUESTION_ID
, USER_RESPONSE_TEXT
, RESPONSE_TYPE_ID
, ANSWERED_FLAG
, QUESTION_SUGGESTED_POINTS
, POINTS_AWARDED
, RESPONSE_TYPE
, CORRECT_FEEDBACK
, WRONG_FEEDBACK
, RESPONSE_VALUE_TEXT
, QUESTION_TEXT
, SECTION_CORRECT_FEEDBACK
, SECTION_WRONG_FEEDBACK
, TEST_CORRECT_FEEDBACK
, TEST_WRONG_FEEDBACK
, FEEDBACK_TYPE_FLAG
, SECTION_DESCRIPTION
, PARENT_ID
, SECTION_NAME
, MANDATORY_FLAG
, ALLOW_HTML_FLAG
, MARKED_FOR_REVIEW_FLAG
FROM APPS.OTA_UTEST_QUESTIONS_V;
|
|
|