DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IES_SUSPENDED_TRANS_V

Object Details
Object Name: IES_SUSPENDED_TRANS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


View to list all suspended transactions


[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes Transaction Id for a suspended transaction
DSCRIPT_ID NUMBER
Yes Script Id of suspended transaction
DSCRIPT_NAME VARCHAR2 (256) Yes Script name of suspended transaction
DSCRIPT_LANGUAGE VARCHAR2 (30) Yes Script language of suspended transaction
SURVEY_CAMPAIGN_ID NUMBER

Survey Campaign Id of suspended transaction. This is for transactions run from Survey Runtime.
SURVEY_DEPLOYMENT_ID NUMBER

Survey Deployment Id of suspended transaction. This is for transactions run from Survey Runtime.
RESPONSE_ID NUMBER

Column to associate the suspended transaction with the survey response that generated it.
FND_USER_NAME VARCHAR2 (100) Yes Suspended transaction's agent name
SUSPEND_TIME DATE

Time transaction was suspended
NUM_SEGMENTS NUMBER

Total number of segments for a transaction
Query Text

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


SELECT TRANSACTION_ID
,      DSCRIPT_ID
,      DSCRIPT_NAME
,      DSCRIPT_LANGUAGE
,      SURVEY_CAMPAIGN_ID
,      SURVEY_DEPLOYMENT_ID
,      RESPONSE_ID
,      FND_USER_NAME
,      SUSPEND_TIME
,      NUM_SEGMENTS
FROM APPS.IES_SUSPENDED_TRANS_V;

Dependencies

[top of page]

APPS.IES_SUSPENDED_TRANS_V references the following:

SchemaAPPS
SynonymFND_LANGUAGES
SynonymFND_USER
SynonymIES_DEPLOYED_SCRIPTS
SynonymIES_SVY_CYCLES_ALL
SynonymIES_SVY_DEPLYMENTS_ALL
SynonymIES_SVY_RESPONSE_ENTRIES
SynonymIES_SVY_SURVEYS_ALL
SynonymIES_TRANSACTIONS
SynonymIES_TRANS_SEGMENTS
ViewIES_TRANS_SEGMENTS_COUNT_V

APPS.IES_SUSPENDED_TRANS_V is not referenced by any database object