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_ACD_QUEUE_INFO

Object Details

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

ACD Queue setup data

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ACD_QUEUE_INFO_ID	NUMBER	(15)	Yes	ACD queue Identifier
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
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
ACD_QUEUE_NAME	VARCHAR2	(30)	Yes	ACD Queue Name
PBX_NAME	VARCHAR2	(30)	Yes	PBX Name to which this ACD Queue belong
SREF_TYPE	VARCHAR2	(5)	Yes	Reference Type, always 'S'
ACD_QUE_NUM	VARCHAR2	(16)		ACD queue number
ACD_QUE_QUALIFIER	VARCHAR2	(16)		acd queue qualifier
ACD_QUE_FLAG	VARCHAR2	(5)		queue flag
ACD_TYPE	VARCHAR2	(32)		Type of the ACD queue
ACTIVE_Y_N	VARCHAR2	(5)		Indicates whether the ACD is currently active or not
CDN_SPECIFIER	VARCHAR2	(80)		Switch specific value - some swithces (Meridian, for ex) require this
ENABLER_INFO_1	VARCHAR2	(80)		Enabler specific info
ENABLER_INFO_2	VARCHAR2	(80)		Enabler specific info
ENABLER_INFO_3	VARCHAR2	(80)		Enabler specific info
ENABLER_INFO_4	VARCHAR2	(80)		Enabler specific info
RESTART_TIME	NUMBER	(9)		Time interval to restart an ACD queue after shutdown
ACTUAL_PBX_NAME	VARCHAR2	(30)		The actual name of the PBX. Allows a single PBX to be shared among more than one service using the PBX_NAME column value
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 ACD_QUEUE_INFO_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ACD_QUEUE_NAME
,      PBX_NAME
,      SREF_TYPE
,      ACD_QUE_NUM
,      ACD_QUE_QUALIFIER
,      ACD_QUE_FLAG
,      ACD_TYPE
,      ACTIVE_Y_N
,      CDN_SPECIFIER
,      ENABLER_INFO_1
,      ENABLER_INFO_2
,      ENABLER_INFO_3
,      ENABLER_INFO_4
,      RESTART_TIME
,      ACTUAL_PBX_NAME
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM IEO.IEO_ACD_QUEUE_INFO;

Dependencies

[top of page]

IEO.IEO_ACD_QUEUE_INFO does not reference any database object

IEO.IEO_ACD_QUEUE_INFO is referenced by following:

APPS: IEO_ACD_QUEUE_INFO