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: APPS.IES_SVY_RESP_ENTRIES_V

Object Details

Object Name:	IES_SVY_RESP_ENTRIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IES.IES_SVY_RESP_ENTRIES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View on IES_SVY_RESPONSE_ENTRIES table

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RESPONSE_ID	NUMBER		Yes	Unique Identifier for each responses received
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number required for HTML interfaces
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
SURVEY_DEPLOYMENT_ID	NUMBER		Yes	Foreign key on IES_SVY_DEPLYMENTS_V
SURVEY_LIST_ENTRY_ID	NUMBER			Foreign key to IES_SVY_LIST_ENTRY
DSCRIPT_ID	NUMBER	(15)		Foreign key to IES_DEPLOYES_SCRIPTS
RESPONSE_STATUS	VARCHAR2	(30)		Status of the response ABANDOBED, ABORTED or COMPLETE
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard who column
TRANSACTION_ID	NUMBER		Yes	Foreign key to IES_TRANSACTIONS
INTERACTION_ID	NUMBER			Interaction ID
RESPONSE_SEQUENCE	NUMBER	(10)		Sequence of responses
RESPONSE_COLLECTED_DATE	DATE			Date on which responses were collected
RESPONSE_MEDIA_TYPE_CODE	VARCHAR2	(30)		Media type on which response was given
PASSTHROUGH_REQUIRED_CODE	VARCHAR2	(30)		Passthrough requirement flag
RESPONSE_EXCLUSION_CODE	VARCHAR2	(30)		Flag to exclude responses from analysis
F_DELETEDFLAG	VARCHAR2	(1)		Used by AOM for soft delete
ABANDONED_FLAG	VARCHAR2	(30)		Flag to indicate if the survey was completed or abandoned before completion

Query Text

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


SELECT RESPONSE_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      SURVEY_DEPLOYMENT_ID
,      SURVEY_LIST_ENTRY_ID
,      DSCRIPT_ID
,      RESPONSE_STATUS
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TRANSACTION_ID
,      INTERACTION_ID
,      RESPONSE_SEQUENCE
,      RESPONSE_COLLECTED_DATE
,      RESPONSE_MEDIA_TYPE_CODE
,      PASSTHROUGH_REQUIRED_CODE
,      RESPONSE_EXCLUSION_CODE
,      F_DELETEDFLAG
,      ABANDONED_FLAG
FROM APPS.IES_SVY_RESP_ENTRIES_V;

Dependencies

[top of page]

APPS.IES_SVY_RESP_ENTRIES_V references the following:

APPS: IES_SVY_RESPONSE_ENTRIES

APPS.IES_SVY_RESP_ENTRIES_V is referenced by following:

APPS: IES_SURVEY_SUMMARY - show dependent code