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]

VIEW: IEO.IEO_PBX_INFO#

Object Details

Object Name:	IEO_PBX_INFO#
Object Type:	VIEW
Owner:	IEO
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PBX_INFO_ID	NUMBER		Yes
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
SREF_TYPE	VARCHAR2	(5)
PBX_NAME	VARCHAR2	(30)
PRED_SRV_NAME	VARCHAR2	(30)
PBX_TYPE	VARCHAR2	(5)
REGISTRATION_FLAG	VARCHAR2	(5)
CTI_ENABLER	VARCHAR2	(16)
CTI_ENABLED_Y_N	VARCHAR2	(5)
ACTIVE_Y_N	VARCHAR2	(5)
CTI_SERVER_NAME	VARCHAR2	(30)
PHONE_PROF_NAME	VARCHAR2	(30)
CTI_NETWORK_NAME	VARCHAR2	(16)
CMPLT_TRANS_FLAG	VARCHAR2	(5)
CTI_INIT	VARCHAR2	(5)
DEFAULT_Y_N	VARCHAR2	(5)
LOC_CALL_DATA_FILE	VARCHAR2	(128)
ACD_QUEUE_FLAG	VARCHAR2	(5)
SPEC_TRAN_FLAG1	VARCHAR2	(20)
SPEC_TRAN_FLAG2	VARCHAR2	(20)
SPEC_TRAN_FLAG3	VARCHAR2	(20)
SPEC_TRAN_FLAG4	VARCHAR2	(20)
TRANS_MIN_WT_TM	NUMBER	(9)
TRANS_MAX_WT_TM	NUMBER	(9)
ANS_TRANS_FLAG	VARCHAR2	(5)
TRANS_ANSMIN_WT_TM	NUMBER	(9)
TRANS_ANSMAX_WT_TM	NUMBER	(9)
INIT_TRANS_WAIT	NUMBER	(9)
DIALER_Q_DOWN_TM	NUMBER	(9)
VOICE_DETECT_MODE	VARCHAR2	(5)
DIAL_DELAY_TIME	NUMBER	(9)
ACTUAL_PBX_NAME	VARCHAR2	(30)
SECURITY_GROUP_ID	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER

Query Text

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


SELECT PBX_INFO_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SREF_TYPE
,      PBX_NAME
,      PRED_SRV_NAME
,      PBX_TYPE
,      REGISTRATION_FLAG
,      CTI_ENABLER
,      CTI_ENABLED_Y_N
,      ACTIVE_Y_N
,      CTI_SERVER_NAME
,      PHONE_PROF_NAME
,      CTI_NETWORK_NAME
,      CMPLT_TRANS_FLAG
,      CTI_INIT
,      DEFAULT_Y_N
,      LOC_CALL_DATA_FILE
,      ACD_QUEUE_FLAG
,      SPEC_TRAN_FLAG1
,      SPEC_TRAN_FLAG2
,      SPEC_TRAN_FLAG3
,      SPEC_TRAN_FLAG4
,      TRANS_MIN_WT_TM
,      TRANS_MAX_WT_TM
,      ANS_TRANS_FLAG
,      TRANS_ANSMIN_WT_TM
,      TRANS_ANSMAX_WT_TM
,      INIT_TRANS_WAIT
,      DIALER_Q_DOWN_TM
,      VOICE_DETECT_MODE
,      DIAL_DELAY_TIME
,      ACTUAL_PBX_NAME
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM IEO.IEO_PBX_INFO#;

Dependencies

[top of page]

IEO.IEO_PBX_INFO# references the following:

IEO: IEO_PBX_INFO

IEO.IEO_PBX_INFO# is referenced by following:

APPS: IEO_PBX_INFO