Skip to content

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: TableCCT.CCT_IVR_MON_SERVICES
Subobject Name:
Status: VALID


IVR Monitor Services table.


Storage Details
Tablespace: TablespaceAPPS_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:

SchemaCCT
ViewCCT_IVR_MON_SERVICES#