DBA Data[Home] [Help] [Dependency Information]

TABLE: CCT.CCT_IVR_SERVICES

Object Details
Object Name: CCT_IVR_SERVICES
Object Type: TABLE
Owner: CCT
FND Design Data: TableCCT.CCT_IVR_SERVICES
Subobject Name:
Status: VALID


IVR 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.
IVRDATAPURGETIME NUMBER (4)
IVR Data Purge Time.
IVRDATASEPARATOR VARCHAR2 (1)
IVR Data Separator
IVRRECVDATASIZE NUMBER (4)
IVR Receive Data Size
IVRHASHKEYPOS NUMBER (4)
IVR Hash Key Position
IVRHASHKEYSIZE NUMBER (4)
IVR Hash Key Size
IVRTRANSLOGFILEPATH VARCHAR2 (132)
IVR Transfer Log File Path.
IVRBACKUPPATH VARCHAR2 (132)
IVR Backup Path
IVRMESSAGEKEYPOS NUMBER (5)
IVR Message Key Position.
IVRRUNTCPIPFLAG NUMBER (1)
IVR Run TCP/IP Flag.
IVRLISTENPORT NUMBER (5)
IVR Listener Port.
IVRRECVTHREADNUM NUMBER (2)
IVR RECV Thread Number
RUNWITHMONITOR NUMBER (1)
Run With IVR Monitor.
IVRMAX NUMBER (2)
IVR Max
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT IVRSERVERNAME
,      IVRDATAPURGETIME
,      IVRDATASEPARATOR
,      IVRRECVDATASIZE
,      IVRHASHKEYPOS
,      IVRHASHKEYSIZE
,      IVRTRANSLOGFILEPATH
,      IVRBACKUPPATH
,      IVRMESSAGEKEYPOS
,      IVRRUNTCPIPFLAG
,      IVRLISTENPORT
,      IVRRECVTHREADNUM
,      RUNWITHMONITOR
,      IVRMAX
,      SECURITY_GROUP_ID
FROM CCT.CCT_IVR_SERVICES;

Dependencies

[top of page]

CCT.CCT_IVR_SERVICES does not reference any database object

CCT.CCT_IVR_SERVICES is referenced by following:

SchemaAPPS
SynonymCCT_IVR_SERVICES