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_LIST_ENTRIES_V

Object Details

Object Name:	IES_SVY_LIST_ENTRIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IES.IES_SVY_LIST_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_LIST_ENTRIES table

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SURVEY_LIST_ENTRY_ID	NUMBER		Yes	Unique Identifier for Survey list entry
DSCRIPT_ID	NUMBER	(15)		Foreign key to IES_DEPLOYED_SCRIPTS
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
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
SURVEY_DEPLOYMENT_ID	NUMBER		Yes	Foreign key on IES_SVY_DEPLYMENTS_V
LIST_ENTRY_ID	NUMBER		Yes	Foreign key to IES_AMS_LIST_ENTRIES_V
RESPONDENT_ID	NUMBER		Yes	Randomly generated key for each Respondent on list
SURVEY_SENT_DATE	DATE			Date on which survey was sent
NO_OF_RESPONSES_RECD	NUMBER	(10)		Number of responses received
ERROR_CODE	VARCHAR2	(30)		Error code if a response was not recieved
F_DELETEDFLAG	VARCHAR2	(1)		Used by AOM for soft delete

Query Text

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


SELECT SURVEY_LIST_ENTRY_ID
,      DSCRIPT_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SURVEY_DEPLOYMENT_ID
,      LIST_ENTRY_ID
,      RESPONDENT_ID
,      SURVEY_SENT_DATE
,      NO_OF_RESPONSES_RECD
,      ERROR_CODE
,      F_DELETEDFLAG
FROM APPS.IES_SVY_LIST_ENTRIES_V;

Dependencies

[top of page]

APPS.IES_SVY_LIST_ENTRIES_V references the following:

APPS: IES_SVY_LIST_ENTRIES

APPS.IES_SVY_LIST_ENTRIES_V is referenced by following:

APPS: IES_SURVEY_SUMMARY - show dependent code; IES_SVY_CREATE_INIT_RECORDS - show dependent code