eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: AMS.AMS_CPAG_QUESTIONS_B#

Object Details

Object Name:	AMS_CPAG_QUESTIONS_B#
Object Type:	VIEW
Owner:	AMS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACTIVE_STATUS	VARCHAR2	(30)	Yes
QUESTION_ID	NUMBER		Yes
QUESTION_TYPE	VARCHAR2	(30)	Yes
CONTENT_ITEM_ID	NUMBER		Yes
HTML_PARAM_NAME	VARCHAR2	(100)	Yes
MANDATORY_FLAG	VARCHAR2	(1)	Yes
WEIGHT_DIM_ID	NUMBER
DISPLAY_FIELD_TYPE	VARCHAR2	(30)	Yes
DISPLAY_SEQUENCE_NO	NUMBER		Yes
CUSTOM_JAVASCRIPT_CODE	VARCHAR2	(4000)
PROFILE_FIELD_ID	NUMBER
ANSWER_TYPE	VARCHAR2	(30)	Yes
ANSWER_LOOKUP_TYPE	VARCHAR2	(30)
ANSWER_LOOKUP_VIEW_NAME	VARCHAR2	(30)
KNOWN_ANSWER_ACTION	VARCHAR2	(30)
INITIAL_VALUE_TYPE	VARCHAR2	(30)
INITIAL_VALUE_FIELD_ID	NUMBER
INITIAL_VALUE_QUESTION_ID	NUMBER
MULTILINE_FLAG	VARCHAR2	(1)
INPUT_MASK	VARCHAR2	(30)
CHAR_WIDTH	NUMBER
MAX_CHARS	NUMBER
HEIGHT	NUMBER
LAYOUT	VARCHAR2	(30)
NO_OF_COLUMNS	NUMBER
MIN_ANSWERS	NUMBER
MAX_ANSWERS	NUMBER
SHOW_TIME_FIELD	VARCHAR2	(1)
TIME_FORMAT	VARCHAR2	(30)
TIMEZONE_ID	NUMBER
FILE_UPLOAD_BUTTON_TYPE	VARCHAR2	(30)
FILE_UPLOAD_BUTTON_IMAGE	VARCHAR2	(240)
FILE_UPLOAD_EXTENSIONS	VARCHAR2	(100)
FILE_UPLOAD_FIELD_WIDTH	NUMBER
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
SECURITY_GROUP_ID	NUMBER
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACTIVE_STATUS
,      QUESTION_ID
,      QUESTION_TYPE
,      CONTENT_ITEM_ID
,      HTML_PARAM_NAME
,      MANDATORY_FLAG
,      WEIGHT_DIM_ID
,      DISPLAY_FIELD_TYPE
,      DISPLAY_SEQUENCE_NO
,      CUSTOM_JAVASCRIPT_CODE
,      PROFILE_FIELD_ID
,      ANSWER_TYPE
,      ANSWER_LOOKUP_TYPE
,      ANSWER_LOOKUP_VIEW_NAME
,      KNOWN_ANSWER_ACTION
,      INITIAL_VALUE_TYPE
,      INITIAL_VALUE_FIELD_ID
,      INITIAL_VALUE_QUESTION_ID
,      MULTILINE_FLAG
,      INPUT_MASK
,      CHAR_WIDTH
,      MAX_CHARS
,      HEIGHT
,      LAYOUT
,      NO_OF_COLUMNS
,      MIN_ANSWERS
,      MAX_ANSWERS
,      SHOW_TIME_FIELD
,      TIME_FORMAT
,      TIMEZONE_ID
,      FILE_UPLOAD_BUTTON_TYPE
,      FILE_UPLOAD_BUTTON_IMAGE
,      FILE_UPLOAD_EXTENSIONS
,      FILE_UPLOAD_FIELD_WIDTH
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM AMS.AMS_CPAG_QUESTIONS_B#;

Dependencies

[top of page]

AMS.AMS_CPAG_QUESTIONS_B# references the following:

AMS: AMS_CPAG_QUESTIONS_B

AMS.AMS_CPAG_QUESTIONS_B# is referenced by following:

APPS: AMS_CPAG_QUESTIONS_B