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_VDU_INFO

Object Details

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

VDU configuration info

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
VDU_INFO_ID	NUMBER	(15)	Yes	VDU Identifier, Primary key
CREATED_BY	NUMBER	(15)	Yes	Standard WHO field
CREATION_DATE	DATE		Yes	Standard WHO field
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO field
LAST_UPDATE_DATE	DATE		Yes	Standard WHO field
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO field
PBX_NAME	VARCHAR2	(30)	Yes	PBX this VDU belongs to
SREF_TYPE	VARCHAR2	(5)	Yes	Always 'S'
VDU_NAME	VARCHAR2	(30)		Name of the VDU
DIALER_PORT	VARCHAR2	(30)		Dialer port for this VDU
DIAL_PROFILE_NAME	VARCHAR2	(30)		Dial profile name
DIALER_STATUS	VARCHAR2	(5)		Availability status of the VDU
DIALER_TYPE	VARCHAR2	(5)		Dialer Type
EXTENSION	VARCHAR2	(12)		VDU extension number
EXT_QUALIFIER	VARCHAR2	(12)		Switch specific enabler qualifier
IO_TRACE_FLAG	VARCHAR2	(5)		Turns vdu's io tracing on or off
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 VDU_INFO_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PBX_NAME
,      SREF_TYPE
,      VDU_NAME
,      DIALER_PORT
,      DIAL_PROFILE_NAME
,      DIALER_STATUS
,      DIALER_TYPE
,      EXTENSION
,      EXT_QUALIFIER
,      IO_TRACE_FLAG
,      ACTUAL_PBX_NAME
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM IEO.IEO_VDU_INFO;

Dependencies

[top of page]

IEO.IEO_VDU_INFO does not reference any database object

IEO.IEO_VDU_INFO is referenced by following:

IEO: IEO_VDU_INFO#