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: CCT.CCT_AGENT_PREFERRED_DEVICES

Object Details

Object Name:	CCT_AGENT_PREFERRED_DEVICES
Object Type:	TABLE
Owner:	CCT
Subobject Name:
Status:	VALID

Stores the list of Preferred Communication devices for an agent

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
AGENT_PREFERRED_DEVICE_ID	NUMBER	(15)	Yes	Unique ID for the table
AGENT_ID	NUMBER	(15)		Foreign Key to CCT_AGENT_RT_STATS table
DEVICE_ID	NUMBER	(15)		If Device_Type is Teleset_ID, this field stores the teleset_ID
DEVICE_NUMBER	VARCHAR2	(64)		If Device Type is PERSONAL, this field stores the Canonical Phone Number
DEVICE_NAME	VARCHAR2	(64)		User defined name for the device
DEVICE_TYPE	VARCHAR2	(32)		Type of Device (PERSONAL/TELESET/SIP) Foreign Key to FND_LOOKUP_TYPE CCT_DEVICE_TYPES
DEFAULT_DEVICE	VARCHAR2	(1)		Is this device the default device for an agent (Y/N)
SERVER_GROUP_ID	VARCHAR2	(1)		Foreign Key to IEO_SVR_GROUPS , stored for optimization purposes
F_DELETED_FLAG	VARCHAR2	(1)		Delete Flag (N/D)
CREATED_BY	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
FND_USER_ID	NUMBER	(15)		FND User Id

Query Text

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


SELECT AGENT_PREFERRED_DEVICE_ID
,      AGENT_ID
,      DEVICE_ID
,      DEVICE_NUMBER
,      DEVICE_NAME
,      DEVICE_TYPE
,      DEFAULT_DEVICE
,      SERVER_GROUP_ID
,      F_DELETED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      FND_USER_ID
FROM CCT.CCT_AGENT_PREFERRED_DEVICES;

Dependencies

[top of page]

CCT.CCT_AGENT_PREFERRED_DEVICES does not reference any database object

CCT.CCT_AGENT_PREFERRED_DEVICES is referenced by following:

APPS: CCT_AGENT_PREFERRED_DEVICES