[Home] [Help] [Dependency Information]
Object Name: | IEC_G_REP_CAMPAIGN_REC_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | IEC |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEC_G_REP_CMP_REC_DETAILS_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
LIST_HEADER_ID
LIST_SUBSET_ID CAMPAIGN_SCHEDULE_ID |
IEC_G_REP_CMP_REC_DETAILS_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | LAST_UPDATE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAMPAIGN_REC_DETAIL_ID | NUMBER | (15) | Yes | Unique identifier. |
CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
CREATION_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
CAMPAIGN_SCHEDULE_ID | NUMBER | (15) | Yes | Identifies the campaign schedule defined in AMS_CAMPAIGN_SCHDULES_B. |
LIST_HEADER_ID | NUMBER | (15) | Yes | Identifies the list header defined in AMS_LIST_HEADERS_ALL. |
LIST_SUBSET_ID | NUMBER | (15) | Yes | Identifies the list header defined in IEC_G_LIST_SUBSETS. |
RECORD_TYPE | NUMBER | (1) | Yes | Record Type. 1 indicates record stores Campaign Schedule information, 2 for List information, and 3 for Subset information. |
DIALING_METHOD | VARCHAR2 | (30) | Identifies the dialing method: manual, preview, progressive, or predictive. | |
RECORD_LOADED | NUMBER | (9) | Number of records loaded since the current campaign schedule started executing. | |
RECORD_CALLED | NUMBER | (9) | Number of records called since the current campaign schedule started executing. | |
RECORD_REMOVED | NUMBER | (9) | Number of records removed since the current campaign schedule started executing. | |
RECORD_REMAINING | NUMBER | (9) | Number of records remaining since the current campaign schedule started executing. | |
RECORD_UNAVAILABLE | NUMBER | (9) | Number of records that are currently unavailable. | |
RECORD_AVAILABLE | NUMBER | (9) | Number of records that are currently available. | |
PRED_EXHAUST | DATE | Estimated time before list entries run out. | ||
QUOTA_CURRENT | NUMBER | (9) | Dyanimic quota. | |
QUOTA_OBJ | NUMBER | (9) | Objective quota. | |
RECORD_CALLED_AND_REMOVED | NUMBER | (9) | ||
RECORD_CALLED_AND_REMOVED_COPY | NUMBER | (9) | ||
LAST_COPY_TIME | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Standard who column. | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments. |
Cut, paste (and edit) the following text to query this object:
SELECT CAMPAIGN_REC_DETAIL_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CAMPAIGN_SCHEDULE_ID
, LIST_HEADER_ID
, LIST_SUBSET_ID
, RECORD_TYPE
, DIALING_METHOD
, RECORD_LOADED
, RECORD_CALLED
, RECORD_REMOVED
, RECORD_REMAINING
, RECORD_UNAVAILABLE
, RECORD_AVAILABLE
, PRED_EXHAUST
, QUOTA_CURRENT
, QUOTA_OBJ
, RECORD_CALLED_AND_REMOVED
, RECORD_CALLED_AND_REMOVED_COPY
, LAST_COPY_TIME
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
FROM IEC.IEC_G_REP_CAMPAIGN_REC_DETAILS;
IEC.IEC_G_REP_CAMPAIGN_REC_DETAILS does not reference any database object
IEC.IEC_G_REP_CAMPAIGN_REC_DETAILS is referenced by following:
|
|
|