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]

TABLE: AMS.AMS_CPAG_QUESTIONS_B

Object Details

Object Name:	AMS_CPAG_QUESTIONS_B
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_CPAG_QUESTIONS_B
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_CPAG_QUESTIONS_B_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	QUESTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVE_STATUS	VARCHAR2	(30)	Yes	Status of the Question.
QUESTION_ID	NUMBER		Yes	Primary Key.
QUESTION_TYPE	VARCHAR2	(30)	Yes	Type of the Question.
CONTENT_ITEM_ID	NUMBER		Yes	Content Item Id of the Questions Section to which this Question belongs.
HTML_PARAM_NAME	VARCHAR2	(100)	Yes	HTML Form Parameter name associated with the question.
MANDATORY_FLAG	VARCHAR2	(1)	Yes	Indicates whether the Question is Mandatory.
WEIGHT_DIM_ID	NUMBER			Wighting Dimension associated with the Question.
DISPLAY_FIELD_TYPE	VARCHAR2	(30)	Yes	Display Type for the Answers associated with this question.
DISPLAY_SEQUENCE_NO	NUMBER		Yes	Display Sequence Number that dictates in what order the Question will be placed on a Content Page.
CUSTOM_JAVASCRIPT_CODE	VARCHAR2	(4000)		Users can specify their own Javascript validations.
PROFILE_FIELD_ID	NUMBER			For question based on Profiles, this field holds the Profile Field ID. Foreign key to the Data Source fields table.
ANSWER_TYPE	VARCHAR2	(30)	Yes	Type of Answer expected for this Question.
ANSWER_LOOKUP_TYPE	VARCHAR2	(30)		For Lookup Based Answers, this field holds the associated Lookup Type Code.
ANSWER_LOOKUP_VIEW_NAME	VARCHAR2	(30)		View Name associated with the Lookup Type Code.
KNOWN_ANSWER_ACTION	VARCHAR2	(30)		For profile questions, this field dictates the rules of pre-populating the field with known answer.
INITIAL_VALUE_TYPE	VARCHAR2	(30)		Type of the initial value.
INITIAL_VALUE_FIELD_ID	NUMBER			Profile Field ID associated with the initial value when initial value is based on a Profile Field.
INITIAL_VALUE_QUESTION_ID	NUMBER			When initial value is based on another question on other Content Page, this field holds the Question ID.
MULTILINE_FLAG	VARCHAR2	(1)		Dictates whether Textbox is rendered as Single Line Textbox or Multi line Textarea.
INPUT_MASK	VARCHAR2	(30)		Input Mask for Textbox fields.
CHAR_WIDTH	NUMBER			Character Width for the Textbox field.
MAX_CHARS	NUMBER			Maximim Number of characters allowed in a Textbox field.
HEIGHT	NUMBER			Dropdown Height or Number of rows for Radio Button or Checkbox field.
LAYOUT	VARCHAR2	(30)		Horizontal or Vertical layout for Radio buttons or Checkboxes.
NO_OF_COLUMNS	NUMBER			Number of Columns when Radiobuttons or Checkboxes are to be in Horizontal Layout.
MIN_ANSWERS	NUMBER			Minimum number of answers expected for a List or Checkbox.
MAX_ANSWERS	NUMBER			Maximum number of answers allowed for List of Checkboxes.
SHOW_TIME_FIELD	VARCHAR2	(1)		Indicates whether the time field be shows for Date fields.
TIME_FORMAT	VARCHAR2	(30)		Format for the Time Field.
TIMEZONE_ID	NUMBER			Timezone associated with the time.
FILE_UPLOAD_BUTTON_TYPE	VARCHAR2	(30)		Type for FIle Upload Button.
FILE_UPLOAD_BUTTON_IMAGE	VARCHAR2	(240)		Image For File Upload Button.
FILE_UPLOAD_EXTENSIONS	VARCHAR2	(100)		Extension allowed for Files that are uploaded.
FILE_UPLOAD_FIELD_WIDTH	NUMBER			Width of the file upload field.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	This column is used for optimistic locking.

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 does not reference any database object

AMS.AMS_CPAG_QUESTIONS_B is referenced by following:

APPS: AMS_CPAG_QUESTIONS_B