[Home] [Help] [Dependency Information]
Object Name: | IES_SUSPENDED_TRANS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View to list all suspended transactions
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 |
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;
APPS.IES_SUSPENDED_TRANS_V is not referenced by any database object
|
|
|