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_DLG_RESPONS_B

Object Details

Object Name:	AMS_CPAG_DLG_RESPONS_B
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_CPAG_DLG_RESPONS_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_DLG_RESPONS_B_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	RESPONSE_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	This column is used for optimistic locking.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
RESPONSE_ITEM_ID	NUMBER		Yes	This is the Primary Key.
DIALOG_ID	NUMBER		Yes	Foreign Key to the Dialogs table. This response item is associated with this Dialog.
DIALOG_RUN_ID	NUMBER		Yes	This response is associated with this Dialog Run.
DIALOG_RUN_STEP_ID	NUMBER		Yes	This response is associated with this Dialog Run Step.
ANSWERING_PARTY_ID	NUMBER		Yes	Party ID of the Customer who is responding to this question.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
ANSWERING_PARTY_STATUS	VARCHAR2	(30)	Yes	Status of the Customer who is responding to the Questionnaire. Customer could be Identified, or Authentocated, or Anonymous.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
QUESTION_ID	NUMBER		Yes	This response item is for this question.
ANSWER_ID	NUMBER		Yes	Foreign key to the Answers Base table. This response item is same as this answer.
ANSWER_LOOKUP_CODE	VARCHAR2	(30)		Lookup Code associated with the Answer if the Answer is Lookup Based.
UPLOAD_FILE_ID	NUMBER			This field will hold the fild ID of the uploaded file when Customer uploads a file as part of the Questionnaire.
WEIGHT	NUMBER			Weight associated with the Answer.
NEW_USER_FLAG	VARCHAR2	(1)		Indicates whether this Customer was created as a New User in this Dialog/Marketing Questionnaire.

Query Text

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


SELECT OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      RESPONSE_ITEM_ID
,      DIALOG_ID
,      DIALOG_RUN_ID
,      DIALOG_RUN_STEP_ID
,      ANSWERING_PARTY_ID
,      CREATED_BY
,      ANSWERING_PARTY_STATUS
,      SECURITY_GROUP_ID
,      LAST_UPDATE_LOGIN
,      QUESTION_ID
,      ANSWER_ID
,      ANSWER_LOOKUP_CODE
,      UPLOAD_FILE_ID
,      WEIGHT
,      NEW_USER_FLAG
FROM AMS.AMS_CPAG_DLG_RESPONS_B;

Dependencies

[top of page]

AMS.AMS_CPAG_DLG_RESPONS_B does not reference any database object

AMS.AMS_CPAG_DLG_RESPONS_B is referenced by following:

AMS: AMS_CPAG_DLG_RESPONS_B#