[Home] [Help] [Dependency Information]
Object Name: | IEC_G_CAMPAIGNS_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 created to retrieve only campaigns that have been assigned Advanced Outbound.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAMPAIGN_ID | NUMBER | Yes | Unique Identifier. | |
CAMPAIGN_NAME | VARCHAR2 | (240) | Yes | Unique Name for the campaign |
DESCRIPTION | VARCHAR2 | (4000) | Schedule Description. | |
USER_STATUS_ID | NUMBER | Yes | User Status Code. | |
STATUS_CODE | VARCHAR2 | (30) | Yes | System Status Code. |
CALL_CENTER_READY_FLAG | VARCHAR2 | (1) | Call Center reday flag | |
CTI_DISABLED_FLAG | VARCHAR2 | (1) | Flag indicates if CTI is disabled | |
AGENTLESS_FLAG | VARCHAR2 | (1) | Flag for Agentless Campaign | |
AGENTLESS_EXEC_MODE | VARCHAR2 | (15) | Execution Mode for Agentless Campaign | |
NUM_VDU_PORTS | NUMBER | (15) | Number of VDU Ports | |
EXECUTION_STATUS | VARCHAR2 | (240) | Campaign Execution Status | |
ACTIVE_FLAG | VARCHAR2 | (1) | Yes | Flag indicating if the schedule is active. |
SOURCE_CODE | VARCHAR2 | (30) | Yes | Source code for the schedule. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | This column is used for locking purposes | |
OWNER_USER_ID | NUMBER | Yes | Standard who column. | |
LANGUAGE | VARCHAR2 | (4) | Yes | The language the text will mirror. If text is not yet tranlated into LANGUAGE thenany changes to the text in the source language row will be reflected here as well. |
NAME | VARCHAR2 | (120) | User status name from AMS_USER_STATUSES_TL | |
START_DATE_TIME | DATE | Start Date/Time | ||
END_DATE_TIME | DATE | End Date/Time |
Cut, paste (and edit) the following text to query this object:
SELECT CAMPAIGN_ID
, CAMPAIGN_NAME
, DESCRIPTION
, USER_STATUS_ID
, STATUS_CODE
, CALL_CENTER_READY_FLAG
, CTI_DISABLED_FLAG
, AGENTLESS_FLAG
, AGENTLESS_EXEC_MODE
, NUM_VDU_PORTS
, EXECUTION_STATUS
, ACTIVE_FLAG
, SOURCE_CODE
, LAST_UPDATE_DATE
, LAST_UPDATE_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, OWNER_USER_ID
, LANGUAGE
, NAME
, START_DATE_TIME
, END_DATE_TIME
FROM APPS.IEC_G_CAMPAIGNS_V;
|
|
|