Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - IEO Tables and Views

TABLE - IEO.IEO_ACD_QUEUE_INFO
TABLE - IEO.IEO_ALGORITHMS_ALL
TABLE - IEO.IEO_ALGORITHM_NAMES_ALL
TABLE - IEO.IEO_CAMPAIGNS_ALL
TABLE - IEO.IEO_CP_LIST_STATS_ALL
TABLE - IEO.IEO_CP_PHONETYPE_MSG_XRS_ALL
TABLE - IEO.IEO_CP_SERVICES_ALL
TABLE - IEO.IEO_CP_STOP_LIST
TABLE - IEO.IEO_CP_SVC_FIELDS_ALL
TABLE - IEO.IEO_CP_SVC_LISTS_ALL
TABLE - IEO.IEO_LIST_CAMP_XRS_ALL
TABLE - IEO.IEO_PBX_INFO
TABLE - IEO.IEO_PREDSERVICES_ALL
TABLE - IEO.IEO_SVR_COMPS
TABLE - IEO.IEO_SVR_COMP_DEFS
TABLE - IEO.IEO_SVR_GROUPS
TABLE - IEO.IEO_SVR_PARAMS
TABLE - IEO.IEO_SVR_PROTOCOL_MAP
TABLE - IEO.IEO_SVR_RT_INFO
TABLE - IEO.IEO_SVR_SERVERS
TABLE - IEO.IEO_SVR_TYPES_B
TABLE - IEO.IEO_SVR_TYPES_TL
TABLE - IEO.IEO_SVR_VALUES
TABLE - IEO.IEO_SYSTEM_CAMPS_ALL
TABLE - IEO.IEO_SYST_CP_SVCS_ALL
TABLE - IEO.IEO_VDU_INFO
TABLE - IEO.IEO_VOICE_MSGS_ALL
VIEW - APPS.IEO_LOOKUPS
VIEW - APPS.IEO_SVR_TYPES_VL

Table: IEO_ACD_QUEUE_INFO

Description: ACD Queue setup data
Primary Key: ACD_PK
  1. ACD_QUEUE_INFO_ID
Primary Key: ACD_UK
  1. ACD_QUEUE_NAME
  2. PBX_NAME
  3. SREF_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_ACD_QUEUE_INFO.SREF_TYPE
IEO_ACD_QUEUE_INFO.PBX_NAME 		IEO_PBX_INFO

[top of page]

IEO.IEO_ACD_QUEUE_INFO does not reference any database object

IEO.IEO_ACD_QUEUE_INFO is referenced by following:

APPS
SYNONYM - IEO_ACD_QUEUE_INFO

[top of page]

Table: IEO_ALGORITHMS_ALL

Description: Advanced outbound algorithms table
Primary Key: IEO_ALGORITHMS_ALL_PK
  1. ALGORITHM_ID
Primary Key: IEO_ALGORITHMS_ALL_UK
  1. LINE_NUMBER
  2. NAME
  3. TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_ALGORITHMS_ALL.NAME
IEO_ALGORITHMS_ALL.TYPE 		IEO_ALGORITHM_NAMES_ALL

[top of page]

IEO.IEO_ALGORITHMS_ALL does not reference any database object

IEO.IEO_ALGORITHMS_ALL is referenced by following:

APPS
SYNONYM - IEO_ALGORITHMS_ALL

[top of page]

Table: IEO_ALGORITHM_NAMES_ALL

Description: Name for Advanced outbound Calendar and Recycle algorithms
Primary Key: IA_PK
  1. ALGORITHM_NAME_ID
Primary Key: IA_UK
  1. NAME
  2. TYPE
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_CP_SERVICES_ALL.CALENDAR_FILE
IEO_CP_SERVICES_ALL.CAL_ALG_TYPE 		IEO_ALGORITHM_NAMES_ALL
IEO_CP_SERVICES_ALL.RECYCLING_METHOD
IEO_CP_SERVICES_ALL.RCY_ALG_TYPE 		IEO_ALGORITHM_NAMES_ALL
IEO_ALGORITHMS_ALL.NAME
IEO_ALGORITHMS_ALL.TYPE 		IEO_ALGORITHM_NAMES_ALL
IEO_CP_SVC_LISTS_ALL.CALENDAR_FILE
IEO_CP_SVC_LISTS_ALL.CAL_ALG_TYPE 		IEO_ALGORITHM_NAMES_ALL

[top of page]

IEO.IEO_ALGORITHM_NAMES_ALL does not reference any database object

IEO.IEO_ALGORITHM_NAMES_ALL is referenced by following:

APPS
SYNONYM - IEO_ALGORITHM_NAMES_ALL

[top of page]

Table: IEO_CAMPAIGNS_ALL

Description: Campaign Plus campaigns
Primary Key: CAM_PK
  1. CAMPAIGN_ID
Primary Key: CAM_UK
  1. REF_TYPE
  2. REF_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_CAMPAIGNS_ALL.LIST_SRV_NAME IEO_CP_SERVICES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_LIST_CAMP_XRS_ALL.REF_TYPE
IEO_LIST_CAMP_XRS_ALL.REF_NAME 		IEO_CAMPAIGNS_ALL

[top of page]

IEO.IEO_CAMPAIGNS_ALL does not reference any database object

IEO.IEO_CAMPAIGNS_ALL is referenced by following:

APPS
SYNONYM - IEO_CAMPAIGNS_ALL

[top of page]

Table: IEO_CP_LIST_STATS_ALL

Description: Release statistics for records from CP lists
Primary Key: LS1_UK
  1. ORG_ID
  2. LIST_NAME
  3. LIST_SRV_NAME
Primary Key: LST_PK
  1. CP_LIST_STAT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_CP_LIST_STATS_ALL.LIST_NAME
IEO_CP_LIST_STATS_ALL.LIST_SRV_NAME
IEO_CP_LIST_STATS_ALL.SREF_TYPE 		IEO_CP_SVC_LISTS_ALL

[top of page]

IEO.IEO_CP_LIST_STATS_ALL does not reference any database object

IEO.IEO_CP_LIST_STATS_ALL is referenced by following:

APPS
SYNONYM - IEO_CP_LIST_STATS_ALL

[top of page]

Table: IEO_CP_PHONETYPE_MSG_XRS_ALL

Description: Phone Type and Message ID cross reference table
Primary Key: IEO_CP_PHONETYPE_MSG_XRS_A_PK
  1. CP_PHONETYPE_MSG_ID
Primary Key: IEO_CP_PHONETYPE_MSG_XRS_A_UK
  1. LIST_SRV_NAME
  2. SREF_TYPE
  3. PHONE_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_CP_PHONETYPE_MSG_XRS_ALL.LIST_SRV_NAME IEO_CP_SERVICES_ALL
IEO_CP_PHONETYPE_MSG_XRS_ALL.MESSAGEID_ANS_MACHINE IEO_VOICE_MSGS_ALL
IEO_CP_PHONETYPE_MSG_XRS_ALL.MESSAGEID_FRONT_HOLD IEO_VOICE_MSGS_ALL

[top of page]

IEO.IEO_CP_PHONETYPE_MSG_XRS_ALL does not reference any database object

IEO.IEO_CP_PHONETYPE_MSG_XRS_ALL is referenced by following:

APPS
SYNONYM - IEO_CP_PHONETYPE_MSG_XRS_ALL

[top of page]

Table: IEO_CP_SERVICES_ALL

Description: Setup/configuration for all Campaign Plus services on this system
Primary Key: CPS_UK
  1. LIST_SRV_NAME
Primary Key: LIST_PK
  1. CP_SERVICE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_CP_SERVICES_ALL.CAMPAIGN_LIST_ID AMS_LIST_HEADERS_ALL
IEO_CP_SERVICES_ALL.CALENDAR_FILE
IEO_CP_SERVICES_ALL.CAL_ALG_TYPE 		IEO_ALGORITHM_NAMES_ALL
IEO_CP_SERVICES_ALL.RECYCLING_METHOD
IEO_CP_SERVICES_ALL.RCY_ALG_TYPE 		IEO_ALGORITHM_NAMES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_CAMPAIGNS_ALL.LIST_SRV_NAME IEO_CP_SERVICES_ALL
IEO_CP_PHONETYPE_MSG_XRS_ALL.LIST_SRV_NAME IEO_CP_SERVICES_ALL
IEO_CP_SVC_FIELDS_ALL.LIST_SRV_NAME IEO_CP_SERVICES_ALL
IEO_CP_SVC_LISTS_ALL.LIST_SRV_NAME IEO_CP_SERVICES_ALL

[top of page]

IEO.IEO_CP_SERVICES_ALL does not reference any database object

IEO.IEO_CP_SERVICES_ALL is referenced by following:

APPS
SYNONYM - IEO_CP_SERVICES_ALL

[top of page]

Table: IEO_CP_STOP_LIST

Description: People who should not be called
Primary Key: CSL_PK
  1. CP_STOP_LIST_ID

[top of page]

IEO.IEO_CP_STOP_LIST does not reference any database object

IEO.IEO_CP_STOP_LIST is referenced by following:

APPS
SYNONYM - IEO_CP_STOP_LIST

[top of page]

Table: IEO_CP_SVC_FIELDS_ALL

Description: Fields (user-defined and name fields) implemented in each CP service
Primary Key: FLD_PK
  1. CP_SVC_FIELD_ID
Primary Key: LSF_UK
  1. FIELD_NAME
  2. ORG_ID
  3. LIST_SRV_NAME
  4. SREF_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_CP_SVC_FIELDS_ALL.LIST_SRV_NAME IEO_CP_SERVICES_ALL

[top of page]

IEO.IEO_CP_SVC_FIELDS_ALL does not reference any database object

IEO.IEO_CP_SVC_FIELDS_ALL is referenced by following:

APPS
SYNONYM - IEO_CP_SVC_FIELDS_ALL

[top of page]

Table: IEO_CP_SVC_LISTS_ALL

Description: Calling lists supported by CP services
Primary Key: LSL_PK
  1. CP_SVC_LIST_ID
Primary Key: LSL_UK
  1. LIST_NAME
  2. LIST_SRV_NAME
  3. SREF_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_CP_SVC_LISTS_ALL.CALENDAR_FILE
IEO_CP_SVC_LISTS_ALL.CAL_ALG_TYPE 		IEO_ALGORITHM_NAMES_ALL
IEO_CP_SVC_LISTS_ALL.LIST_SRV_NAME IEO_CP_SERVICES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_LIST_CAMP_XRS_ALL.IL_CP_SVC_LIST_ID IEO_CP_SVC_LISTS_ALL
IEO_LIST_CAMP_XRS_ALL.LIST_NAME
IEO_LIST_CAMP_XRS_ALL.LIST_SRV_NAME
IEO_LIST_CAMP_XRS_ALL.SREF_TYPE 		IEO_CP_SVC_LISTS_ALL
IEO_CP_LIST_STATS_ALL.LIST_NAME
IEO_CP_LIST_STATS_ALL.LIST_SRV_NAME
IEO_CP_LIST_STATS_ALL.SREF_TYPE 		IEO_CP_SVC_LISTS_ALL

[top of page]

IEO.IEO_CP_SVC_LISTS_ALL does not reference any database object

IEO.IEO_CP_SVC_LISTS_ALL is referenced by following:

APPS
SYNONYM - IEO_CP_SVC_LISTS_ALL

[top of page]

Table: IEO_LIST_CAMP_XRS_ALL

Description: List and Campaign Cross Refreence Table
Primary Key: IL_PK
  1. LIST_CAMP_XR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_LIST_CAMP_XRS_ALL.REF_TYPE
IEO_LIST_CAMP_XRS_ALL.REF_NAME 		IEO_CAMPAIGNS_ALL
IEO_LIST_CAMP_XRS_ALL.IL_CP_SVC_LIST_ID IEO_CP_SVC_LISTS_ALL
IEO_LIST_CAMP_XRS_ALL.LIST_NAME
IEO_LIST_CAMP_XRS_ALL.LIST_SRV_NAME
IEO_LIST_CAMP_XRS_ALL.SREF_TYPE 		IEO_CP_SVC_LISTS_ALL

[top of page]

IEO.IEO_LIST_CAMP_XRS_ALL does not reference any database object

IEO.IEO_LIST_CAMP_XRS_ALL is referenced by following:

APPS
SYNONYM - IEO_LIST_CAMP_XRS_ALL

[top of page]

Table: IEO_PBX_INFO

Description: PBX configuration info
Primary Key: PBX_PK
  1. PBX_INFO_ID
Primary Key: PBX_UK
  1. SREF_TYPE
  2. PBX_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_PBX_INFO.PRED_SRV_NAME
IEO_PBX_INFO.SREF_TYPE 		IEO_PREDSERVICES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_ACD_QUEUE_INFO.SREF_TYPE
IEO_ACD_QUEUE_INFO.PBX_NAME 		IEO_PBX_INFO
IEO_VDU_INFO.SREF_TYPE
IEO_VDU_INFO.PBX_NAME 		IEO_PBX_INFO

[top of page]

IEO.IEO_PBX_INFO does not reference any database object

IEO.IEO_PBX_INFO is referenced by following:

APPS
SYNONYM - IEO_PBX_INFO

[top of page]

Table: IEO_PREDSERVICES_ALL

Description: Configuration for Predictive services
Primary Key: PREDICTIVE_PK
  1. PREDSERVICE_ID
Primary Key: PSV_UK
  1. PRED_SRV_NAME
  2. SREF_TYPE
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_PBX_INFO.PRED_SRV_NAME
IEO_PBX_INFO.SREF_TYPE 		IEO_PREDSERVICES_ALL

[top of page]

IEO.IEO_PREDSERVICES_ALL does not reference any database object

IEO.IEO_PREDSERVICES_ALL is referenced by following:

APPS
SYNONYM - IEO_PREDSERVICES_ALL

[top of page]

Table: IEO_SVR_COMPS

Description: Server Components.
Primary Key: IEO_SVR_COMPS_PK
  1. COMP_ID
Primary Key: IEO_SVR_COMPS_UK1
  1. SERVER_ID
  2. COMP_DEF_ID
  3. COMP_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_SVR_COMPS.SERVER_ID IEO_SVR_SERVERS
IEO_SVR_COMPS.COMP_DEF_ID IEO_SVR_COMP_DEFS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_SVR_PROTOCOL_MAP.COMP_ID IEO_SVR_COMPS

[top of page]

IEO.IEO_SVR_COMPS does not reference any database object

IEO.IEO_SVR_COMPS is referenced by following:

APPS
SYNONYM - IEO_SVR_COMPS

[top of page]

Table: IEO_SVR_COMP_DEFS

Description: Server Component Definitions.
Primary Key: IEO_SVR_COMP_DEFS_PK
  1. COMP_DEF_ID
Primary Key: IEO_SVR_COMP_DEFS_UK1
  1. COMP_DEF_NAME
  2. COMP_DEF_VERSION
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_SVR_COMP_DEFS.SERVER_TYPE_ID IEO_SVR_TYPES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_SVR_COMPS.COMP_DEF_ID IEO_SVR_COMP_DEFS

[top of page]

IEO.IEO_SVR_COMP_DEFS does not reference any database object

IEO.IEO_SVR_COMP_DEFS is referenced by following:

APPS
SYNONYM - IEO_SVR_COMP_DEFS

[top of page]

Table: IEO_SVR_GROUPS

Description: Server Groups.
Primary Key: IEO_SVR_GROUPS_PK
  1. SERVER_GROUP_ID
Primary Key: IEO_SVR_GROUPS_UK1
  1. GROUP_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_SVR_GROUPS.GROUP_GROUP_ID IEO_SVR_GROUPS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_SVR_GROUPS.GROUP_GROUP_ID IEO_SVR_GROUPS
IEO_SVR_SERVERS.MEMBER_SVR_GROUP_ID IEO_SVR_GROUPS
IEO_SVR_SERVERS.USING_SVR_GROUP_ID IEO_SVR_GROUPS

[top of page]

IEO.IEO_SVR_GROUPS does not reference any database object

IEO.IEO_SVR_GROUPS is referenced by following:

APPS
SYNONYM - IEO_SVR_GROUPS

[top of page]

Table: IEO_SVR_PARAMS

Description: Server Parameters.
Primary Key: IEO_SVR_PARAMS_PK
  1. PARAM_ID
Primary Key: IEO_SVR_PARAMS_UK1
  1. TYPE_ID
  2. PARAM_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_SVR_PARAMS.TYPE_ID IEO_SVR_TYPES_B
IEO_SVR_PARAMS.OBJECT_CODE JTF_OBJECTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_SVR_VALUES.PARAM_ID IEO_SVR_PARAMS

[top of page]

IEO.IEO_SVR_PARAMS does not reference any database object

IEO.IEO_SVR_PARAMS is referenced by following:

APPS
SYNONYM - IEO_SVR_PARAMS

[top of page]

Table: IEO_SVR_PROTOCOL_MAP

Description: Server Protocol Maps.
Primary Key: IEO_SVR_PROTOCOL_MAP_PK
  1. COMP_ID
  2. WIRE_PROTOCOL
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_SVR_PROTOCOL_MAP.COMP_ID IEO_SVR_COMPS

[top of page]

IEO.IEO_SVR_PROTOCOL_MAP does not reference any database object

IEO.IEO_SVR_PROTOCOL_MAP is referenced by following:

APPS
SYNONYM - IEO_SVR_PROTOCOL_MAP

[top of page]

Table: IEO_SVR_RT_INFO

Description: Real time information about servers.
Primary Key: IEO_SVR_RT_INFO_PK
  1. SERVER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_SVR_RT_INFO.SERVER_ID IEO_SVR_SERVERS

[top of page]

IEO.IEO_SVR_RT_INFO does not reference any database object

IEO.IEO_SVR_RT_INFO is referenced by following:

APPS
SYNONYM - IEO_SVR_RT_INFO

[top of page]

Table: IEO_SVR_SERVERS

Description: Servers.
Primary Key: IEO_SVR_SERVERS_PK
  1. SERVER_ID
Primary Key: IEO_SVR_SERVERS_UK1
  1. TYPE_ID
  2. SERVER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_SVR_SERVERS.MEMBER_SVR_GROUP_ID IEO_SVR_GROUPS
IEO_SVR_SERVERS.USING_SVR_GROUP_ID IEO_SVR_GROUPS
IEO_SVR_SERVERS.TYPE_ID IEO_SVR_TYPES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_SVR_COMPS.SERVER_ID IEO_SVR_SERVERS
IEO_SVR_RT_INFO.SERVER_ID IEO_SVR_SERVERS
IEO_SVR_VALUES.SERVER_ID IEO_SVR_SERVERS

[top of page]

IEO.IEO_SVR_SERVERS does not reference any database object

IEO.IEO_SVR_SERVERS is referenced by following:

APPS
SYNONYM - IEO_SVR_SERVERS

[top of page]

Table: IEO_SVR_TYPES_B

Description: Server Types (base table).
Primary Key: IEO_SVR_TYPES_B_PK
  1. TYPE_ID
Primary Key: IEO_SVR_TYPES_B_UK1
  1. TYPE_UUID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_SVR_COMP_DEFS.SERVER_TYPE_ID IEO_SVR_TYPES_B
IEO_SVR_PARAMS.TYPE_ID IEO_SVR_TYPES_B
IEO_SVR_SERVERS.TYPE_ID IEO_SVR_TYPES_B
IEO_SVR_TYPES_TL.TYPE_ID IEO_SVR_TYPES_B
IEU_UWQ_SVR_MPS_PLUGINS.SVR_TYPE_ID IEO_SVR_TYPES_B

[top of page]

IEO.IEO_SVR_TYPES_B does not reference any database object

IEO.IEO_SVR_TYPES_B is referenced by following:

APPS
SYNONYM - IEO_SVR_TYPES_B

[top of page]

Table: IEO_SVR_TYPES_TL

Description: Server Types (translation table).
Primary Key: IEO_SVR_TYPES_TL_PK
  1. TYPE_ID
  2. LANGUAGE
Primary Key: IEO_SVR_TYPES_TL_UK1
  1. LANGUAGE
  2. TYPE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_SVR_TYPES_TL.TYPE_ID IEO_SVR_TYPES_B

[top of page]

IEO.IEO_SVR_TYPES_TL does not reference any database object

IEO.IEO_SVR_TYPES_TL is referenced by following:

APPS
SYNONYM - IEO_SVR_TYPES_TL

[top of page]

Table: IEO_SVR_VALUES

Description: Server Values.
Primary Key: IEO_SVR_VALUES_PK
  1. VALUE_ID
Primary Key: IEO_SVR_VALUES_UK1
  1. VALUE_INDEX
  2. PARAM_ID
  3. SERVER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_SVR_VALUES.SERVER_ID IEO_SVR_SERVERS
IEO_SVR_VALUES.PARAM_ID IEO_SVR_PARAMS

[top of page]

IEO.IEO_SVR_VALUES does not reference any database object

IEO.IEO_SVR_VALUES is referenced by following:

APPS
SYNONYM - IEO_SVR_VALUES

[top of page]

Table: IEO_SYSTEM_CAMPS_ALL

Description: Centralized Gateway to IEO_CAMPAIGNS_ALL, which may be distributed
Primary Key: SYSCAMP_PK
  1. SYSTEM_CAMP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_SYSTEM_CAMPS_ALL.LIST_SRV_NAME
IEO_SYSTEM_CAMPS_ALL.SREF_TYPE 		IEO_SYST_CP_SVCS_ALL

[top of page]

IEO.IEO_SYSTEM_CAMPS_ALL does not reference any database object

IEO.IEO_SYSTEM_CAMPS_ALL is referenced by following:

APPS
SYNONYM - IEO_SYSTEM_CAMPS_ALL

[top of page]

Table: IEO_SYST_CP_SVCS_ALL

Description: Centralized gateway to IEO_LIST_SERVICES which may be distributed
Primary Key: SCP_UK
  1. LIST_SRV_NAME
  2. SREF_TYPE
Primary Key: SYSTEMLIST_PK
  1. SYST_CP_SVC_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_SYSTEM_CAMPS_ALL.LIST_SRV_NAME
IEO_SYSTEM_CAMPS_ALL.SREF_TYPE 		IEO_SYST_CP_SVCS_ALL

[top of page]

IEO.IEO_SYST_CP_SVCS_ALL does not reference any database object

IEO.IEO_SYST_CP_SVCS_ALL is referenced by following:

APPS
SYNONYM - IEO_SYST_CP_SVCS_ALL

[top of page]

Table: IEO_VDU_INFO

Description: VDU configuration info
Primary Key: VDU_PK
  1. VDU_INFO_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEO_VDU_INFO.SREF_TYPE
IEO_VDU_INFO.PBX_NAME 		IEO_PBX_INFO

[top of page]

IEO.IEO_VDU_INFO does not reference any database object

IEO.IEO_VDU_INFO is referenced by following:

APPS
SYNONYM - IEO_VDU_INFO

[top of page]

Table: IEO_VOICE_MSGS_ALL

Description: Currently-defined voice messages available to be played to callee
Primary Key: VMSG_PK
  1. VOICE_MSG_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEO_CP_PHONETYPE_MSG_XRS_ALL.MESSAGEID_ANS_MACHINE IEO_VOICE_MSGS_ALL
IEO_CP_PHONETYPE_MSG_XRS_ALL.MESSAGEID_FRONT_HOLD IEO_VOICE_MSGS_ALL

[top of page]

IEO.IEO_VOICE_MSGS_ALL does not reference any database object

IEO.IEO_VOICE_MSGS_ALL is referenced by following:

APPS
SYNONYM - IEO_VOICE_MSGS_ALL

[top of page]

View: IEO_LOOKUPS

[top of page]

APPS.IEO_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES

APPS.IEO_LOOKUPS is not referenced by any database object

[top of page]

View: IEO_SVR_TYPES_VL

[top of page]

APPS.IEO_SVR_TYPES_VL references the following:

APPS
SYNONYM - IEO_SVR_TYPES_B
SYNONYM - IEO_SVR_TYPES_TL

APPS.IEO_SVR_TYPES_VL is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract