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_IVR_MON_SERVICES

Object Details

Object Name:	CCT_IVR_MON_SERVICES
Object Type:	TABLE
Owner:	CCT
FND Design Data:	CCT.CCT_IVR_MON_SERVICES
Subobject Name:
Status:	VALID

IVR Monitor Services table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
IVRSERVERNAME	VARCHAR2	(32)	Yes	IVR Server DCE Name.
MONSERVERNAME	VARCHAR2	(32)	Yes	IVR Monitor Server DCE Name.
CTILOGICALID	VARCHAR2	(128)		CTI Link Logical Id DCE.
CTINETWORKTYPE	VARCHAR2	(128)		CTI Link Network Type
CTISERVERNAME	VARCHAR2	(128)		CTI Server Name
MONTCPIPDLLNAME	VARCHAR2	(32)		IVR MonitorTCP/IP DLL Name
MONCTIDLLNAME	VARCHAR2	(32)		IVR Monitor CTI DLL Name.
MONAPPHOSTNAME	VARCHAR2	(128)		IVR Monitor Application Host Name.
MONPORTTABLENAME	VARCHAR2	(32)		IVR Monitor Port Table Name.
MONACTIVETHRESHOLD	NUMBER	(4)		IVR Monitor Active Threshold.
MONAPPPORT	NUMBER	(4)		IVR Monitor Application Port
MONHOSTNAMELEN	NUMBER	(5)		IVR Monitor Host Name Length
MONHOSTNAMEDATAPOS	NUMBER	(5)		IVR Monitor Host Name Data Position.
MONPORTDATAPOS	NUMBER	(5)		IVR Monitor Port Data Position.
MONKEYDATASIZE	NUMBER	(5)		IVR Monitor Key Data Size.
MONRECVDATASIZE	NUMBER	(4)		IVR Monitor Receive Data Size
MONLISTENPORT	NUMBER	(5)		IVR Monitor listener Port.
MONPERIODICALCLEANUPTIME	NUMBER	(5)		IVR Monitor Periodical Cleanup Time
MONRECVDATATHREAD	NUMBER	(5)		IVR Monitor Receive Data Thread.
MONRETDATAFLAG	NUMBER	(4)		IVR Monitor Return Data Flag.
MONRETDATAPOS	NUMBER	(5)		IVR Monitor Return Data Position.
MONRETDATASIZE	NUMBER	(5)		IVR Monitor Return Data Size.
MONTOTALPORT	NUMBER	(5)		IVR Monitor Total Port
MONTRANSLOWTHRESHOLD	NUMBER	(4)		IVR Monitor Trans Low Threshold.
MONTRANSHIGHTHRESHOLD	NUMBER	(4)		IVR Monitor Trans High Threshold.
MONFINISHTHRESHOLD	NUMBER	(4)		IVR Monitor Finish Threshold.
MONMAXMESSAGEDELAY	NUMBER	(4)		IVR Monitor Max Message Delay.
MONVERSAPBXTYPE	NUMBER	(2)		IVR Monitor Versa PBX Type.
MONPBXTYPE	VARCHAR2	(32)		IVR Monitor PBX Type.
MONPORTLEN	NUMBER	(5)		IVR Monitor Port Length.
MONMSGCLTIME	NUMBER	(5)		IVR Monitor MSGCL Time.
MONCONSTIME	NUMBER	(4)		IVR Monitor Cons Time.
MONRESTARTTIME	NUMBER	(4)		IVR Monitor Restart Time.
MONRETRYLIMIT	NUMBER	(5)		MON Retry Limit.
MAXIVR	NUMBER	(5)		MAX IVR.
USEUUID	NUMBER	(1)		USEUUID.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT IVRSERVERNAME
,      MONSERVERNAME
,      CTILOGICALID
,      CTINETWORKTYPE
,      CTISERVERNAME
,      MONTCPIPDLLNAME
,      MONCTIDLLNAME
,      MONAPPHOSTNAME
,      MONPORTTABLENAME
,      MONACTIVETHRESHOLD
,      MONAPPPORT
,      MONHOSTNAMELEN
,      MONHOSTNAMEDATAPOS
,      MONPORTDATAPOS
,      MONKEYDATASIZE
,      MONRECVDATASIZE
,      MONLISTENPORT
,      MONPERIODICALCLEANUPTIME
,      MONRECVDATATHREAD
,      MONRETDATAFLAG
,      MONRETDATAPOS
,      MONRETDATASIZE
,      MONTOTALPORT
,      MONTRANSLOWTHRESHOLD
,      MONTRANSHIGHTHRESHOLD
,      MONFINISHTHRESHOLD
,      MONMAXMESSAGEDELAY
,      MONVERSAPBXTYPE
,      MONPBXTYPE
,      MONPORTLEN
,      MONMSGCLTIME
,      MONCONSTIME
,      MONRESTARTTIME
,      MONRETRYLIMIT
,      MAXIVR
,      USEUUID
,      SECURITY_GROUP_ID
FROM CCT.CCT_IVR_MON_SERVICES;

Dependencies

[top of page]

CCT.CCT_IVR_MON_SERVICES does not reference any database object

CCT.CCT_IVR_MON_SERVICES is referenced by following:

APPS: CCT_IVR_MON_SERVICES