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_PORTRECORDS

Object Details

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

IVR Monitor Port Records table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
EXTENSION	VARCHAR2	(5)	Yes	Extension Number.
PORTTABLENAME	VARCHAR2	(32)	Yes	Port Table Name.
IVRSERVERNAME	VARCHAR2	(32)	Yes	IVR Server DCE Name.
MONSERVERNAME	VARCHAR2	(32)	Yes	IVR Monitor Server DCE Name.
PORTNAME	VARCHAR2	(10)		Port Name
PORTSTATUS	NUMBER	(2)		Port Status
PBXNAME	VARCHAR2	(30)		PBX Name
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT EXTENSION
,      PORTTABLENAME
,      IVRSERVERNAME
,      MONSERVERNAME
,      PORTNAME
,      PORTSTATUS
,      PBXNAME
,      SECURITY_GROUP_ID
FROM CCT.CCT_IVR_MON_PORTRECORDS;

Dependencies

[top of page]

CCT.CCT_IVR_MON_PORTRECORDS does not reference any database object

CCT.CCT_IVR_MON_PORTRECORDS is referenced by following:

APPS: CCT_IVR_MON_PORTRECORDS