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]

TABLE: IEO.IEO_CP_SVC_LISTS_ALL

Object Details

Object Name:	IEO_CP_SVC_LISTS_ALL
Object Type:	TABLE
Owner:	IEO
FND Design Data:	IEO.IEO_CP_SVC_LISTS_ALL
Subobject Name:
Status:	VALID

Calling lists supported by CP services

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CP_SVC_LIST_ID	NUMBER		Yes	Primary key column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO field
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)		Standard WHO column
LIST_NAME	VARCHAR2	(30)	Yes	List name
LIST_SRV_NAME	VARCHAR2	(30)	Yes	List service in which this list is defined
SREF_TYPE	VARCHAR2	(5)	Yes	"S"
CALENDAR_FILE	VARCHAR2	(30)		Filename or other locator for list-specific calendar/scheduling file
CAL_ALG_TYPE	VARCHAR2	(10)	Yes	Always "SCHEDULE"
ORG_ID	NUMBER	(15)	Yes	Multi-org support
LIST_RELEASE_STR	VARCHAR2	(1000)		Boolean logic that permits records to be released from this list
QUEUE_FIRST_ENTRY	NUMBER	(9)		Pointer to first record of this list in .QLD
QUEUE_LAST_ENTRY	NUMBER	(9)		Pointer to last record of this list in .QLD
QUEUE_SCORE	NUMBER	(9)		Total score for this list (applies only to Scoring release strategies)
QUEUE_SCORE_CNT	NUMBER	(9)		Count of entries contributing to QUEUE_SCORE (applies only to Scoring)
QUEUE_CODE	NUMBER	(9)		Unique numeric identifier for this list in this service
QUEUE_PRIORITY	NUMBER	(9)		Release priority for this list (1-100)
QUEUE_STATUS	VARCHAR2	(5)		"N" = new, "D" = deleted, "X" = deletion in process, "Y" = other
QUEUE_TYPE	VARCHAR2	(5)		"O" = always open
RELEASE_STRATEGY	NUMBER	(9)		1 = Quantum, 2 = Quota, 3 = Avg Score, 4 = Total Score
RELEASE_ARRAY_CNT	NUMBER	(9)		Number of minutes' of release statistical data available (1-60)
RELEASE_STOP_FLAG	VARCHAR2	(5)		Obsolete
REMAIN_QUOTA	NUMBER	(9)		Remaining quota in this time period (only applies to Quota release strategy)
RANDOMIZE_FLAG	VARCHAR2	(5)		Obsolete
RECYCLE_METHOD	VARCHAR2	(30)		Obsolete
SHORT_DESCRIPTION	VARCHAR2	(30)		Obsolete
SORT_KEY	NUMBER	(9)		Obsolete
CREATE_DT_TM	DATE			Obsolete
CALL_TYPE_CODE	NUMBER	(9)		Obsolete
CTRL_LENGTH	NUMBER	(9)		Length of LIST_RELEASE_STR
DIALING_METHOD	VARCHAR2	(20)		Obsolete
STOP_DT_TM	DATE			Obsolete
SELECTION_CRITERIA	VARCHAR2	(1000)		Obsolete
SORT_ORDER_MAP	VARCHAR2	(1000)		Obsolete
SELECTION_PRIORITY	NUMBER	(9)		Selection (load) priority for this list (1-32K)
SCORE_RESET	NUMBER	(9)		Base score reset value (applies only to Scoring)
SORT_FIELD	VARCHAR2	(240)		Columns by which list is to be sorted
SELECT_STRING_LEN	NUMBER	(9)		Length of LIST_SELECT_STR
TOTAL_RECORDS	NUMBER	(9)		Count of records in this list
NUM_SORT_KEYS	NUMBER	(9)		Number of columns used for record sorting
ORIGIN_OF_LIST	VARCHAR2	(30)		Obsolete
VIEW_LIST_Y_N	VARCHAR2	(5)		Obsolete
AUTO_REFRESH	NUMBER	(9)		Obsolete
LONG_DESCRIPTION	VARCHAR2	(1000)		Obsolete
LIST_SORT_ORDER	VARCHAR2	(1000)		Obsolete
PRD_EXHAUST	NUMBER	(9)		Obsolete
QUANTUM	NUMBER	(9)		Quantum of records to be released during one timeslice for this list
QUOTA	NUMBER	(9)		Number of records permitted to be released from this list under Quota release strategy
QUOTA_RESET	NUMBER	(9)		Time interval after which quota is to be reset (in minutes) (applies only to Quota release strategy)
DEFLT_RECYCLE_LIST	VARCHAR2	(32)		List to which records from this list should be recycled, absent more specific info
TIMESTAMP_FLAG	VARCHAR2	(5)		"Y"(es) if timestamps on records in this list are to be honored
DIALING_TYPE	NUMBER	(9)		5 = Preview, 45 = Predictive
DT_PRD_EXHAUST	DATE			Predicted exhaustion date/time of this list
DIALING_OPTIONS	VARCHAR2	(128)		Options string transmitted to Predictive along with any record from this list
EXHAUST_AVAIL_FLAG	VARCHAR2	(5)		Release records from this list, regardless of timestamp, if no other lists have releasable records
LIST_SELECT_STR	VARCHAR2	(1000)		Boolean logic that qualifies records for inclusion in this list
LIST_MGR_LIST_Y_N	VARCHAR2	(5)		"Y"(es) if list is to be processed by Campaign Plus
LIST_STATUS	VARCHAR2	(5)		"O"(pen) or "C"(losed)
LIST_TYPE	VARCHAR2	(30)		Campaign to which this list belongs
INDEX_SLOTS	NUMBER	(9)		Obsolete
TIMESTAMP_ACTUAL	VARCHAR2	(5)		"Y"(es) if list contains timestamped records
SECURITY_GROUP_ID	NUMBER	(15)		Used in hosted environments
OBJECT_VERSION_NUMBER	NUMBER			Standard column used by HTML utilities.

Query Text

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


SELECT CP_SVC_LIST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LIST_NAME
,      LIST_SRV_NAME
,      SREF_TYPE
,      CALENDAR_FILE
,      CAL_ALG_TYPE
,      ORG_ID
,      LIST_RELEASE_STR
,      QUEUE_FIRST_ENTRY
,      QUEUE_LAST_ENTRY
,      QUEUE_SCORE
,      QUEUE_SCORE_CNT
,      QUEUE_CODE
,      QUEUE_PRIORITY
,      QUEUE_STATUS
,      QUEUE_TYPE
,      RELEASE_STRATEGY
,      RELEASE_ARRAY_CNT
,      RELEASE_STOP_FLAG
,      REMAIN_QUOTA
,      RANDOMIZE_FLAG
,      RECYCLE_METHOD
,      SHORT_DESCRIPTION
,      SORT_KEY
,      CREATE_DT_TM
,      CALL_TYPE_CODE
,      CTRL_LENGTH
,      DIALING_METHOD
,      STOP_DT_TM
,      SELECTION_CRITERIA
,      SORT_ORDER_MAP
,      SELECTION_PRIORITY
,      SCORE_RESET
,      SORT_FIELD
,      SELECT_STRING_LEN
,      TOTAL_RECORDS
,      NUM_SORT_KEYS
,      ORIGIN_OF_LIST
,      VIEW_LIST_Y_N
,      AUTO_REFRESH
,      LONG_DESCRIPTION
,      LIST_SORT_ORDER
,      PRD_EXHAUST
,      QUANTUM
,      QUOTA
,      QUOTA_RESET
,      DEFLT_RECYCLE_LIST
,      TIMESTAMP_FLAG
,      DIALING_TYPE
,      DT_PRD_EXHAUST
,      DIALING_OPTIONS
,      EXHAUST_AVAIL_FLAG
,      LIST_SELECT_STR
,      LIST_MGR_LIST_Y_N
,      LIST_STATUS
,      LIST_TYPE
,      INDEX_SLOTS
,      TIMESTAMP_ACTUAL
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM IEO.IEO_CP_SVC_LISTS_ALL;

Dependencies

[top of page]

IEO.IEO_CP_SVC_LISTS_ALL does not reference any database object

IEO.IEO_CP_SVC_LISTS_ALL is referenced by following:

IEO: IEO_CP_SVC_LISTS_ALL#