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_DEPLYMENTS_V

Object Details

Object Name:	IES_SVY_DEPLYMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IES.IES_SVY_DEPLYMENTS_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_DEPLYMENTS_ALL

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SURVEY_DEPLOYMENT_ID	NUMBER		Yes	Unique ID for this view
DEPLOYMENT_NAME	VARCHAR2	(240)		Name of the deployment
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_CYCLE_ID	NUMBER		Yes	foreign key to IES_SVY_CYCLES_V
DSCRIPT_ID	NUMBER	(15)		Foreign key to IES_DEPLOYES_SCRIPTS
MEDIA_TYPE_CODE	VARCHAR2	(30)	Yes	Type of Media code from FND_LOOKUP
DEPLOY_DATE	DATE			Date thedeployment will be active
RESPONSE_END_DATE	DATE			Date on which deployment will be closed for responses
DEPLOYMENT_STATUS_CODE	VARCHAR2	(30)		Status of the deployment
IS_EMPLOYEE_LIST	VARCHAR2	(30)		Flag to indicate if the list is employee based
LIST_HEADER_ID	NUMBER			Unique identifier for List Header (foreign key to AMS_LIST_HEADERS_ALL)
TEMPLATE_ID	NUMBER			Unique identifier for template used in Invitation (foreign key to
REMINDER_TEMPLATE_ID	NUMBER			Unique identifier for template used for reminder (foreign key to
MAX_RESPONSES_PER_PERSON	NUMBER	(10)		Maximum number of times a person can take a survey
MIN_RESPONSES_FOR_CLOSE	NUMBER			Minimum number of responses required before a survey is deemed to be successful
EMAIL_SUBJECT_HEADING	VARCHAR2	(240)		Subject heading on email invitations sent to take the survey
CONCURRENT_REQ_ID	NUMBER			Unique Identifier provided by concurrent manager when batch job is scheduled
FULFILLMENT_REQ_ID	NUMBER			Unique Identifier provided by the fulfillment engine when batch job is accepted in
ORG_ID	NUMBER	(32)		Organization ID
F_DELETEDFLAG	VARCHAR2	(1)		Used by AOM for soft delete
DEPLOYMENT_TYPE_CODE	VARCHAR2	(30)		Type of Deployment, Standard, Targeted.

Query Text

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


SELECT SURVEY_DEPLOYMENT_ID
,      DEPLOYMENT_NAME
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SURVEY_CYCLE_ID
,      DSCRIPT_ID
,      MEDIA_TYPE_CODE
,      DEPLOY_DATE
,      RESPONSE_END_DATE
,      DEPLOYMENT_STATUS_CODE
,      IS_EMPLOYEE_LIST
,      LIST_HEADER_ID
,      TEMPLATE_ID
,      REMINDER_TEMPLATE_ID
,      MAX_RESPONSES_PER_PERSON
,      MIN_RESPONSES_FOR_CLOSE
,      EMAIL_SUBJECT_HEADING
,      CONCURRENT_REQ_ID
,      FULFILLMENT_REQ_ID
,      ORG_ID
,      F_DELETEDFLAG
,      DEPLOYMENT_TYPE_CODE
FROM APPS.IES_SVY_DEPLYMENTS_V;

Dependencies

[top of page]

APPS.IES_SVY_DEPLYMENTS_V references the following:

APPS: IES_SVY_DEPLYMENTS_ALL

APPS.IES_SVY_DEPLYMENTS_V is referenced by following:

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