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

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:

Comments

ACD Queue setup data

Columns

[top of page]

IEO.IEO_ACD_QUEUE_INFO does not reference any database object

IEO.IEO_ACD_QUEUE_INFO is referenced by following:

IEO

VIEW - IEO_ACD_QUEUE_INFO#

[top of page]

Table: IEO_ALGORITHMS_ALL

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:

Comments

Advanced outbound algorithms table

Columns

[top of page]

IEO.IEO_ALGORITHMS_ALL does not reference any database object

IEO.IEO_ALGORITHMS_ALL is referenced by following:

IEO

VIEW - IEO_ALGORITHMS_ALL#

[top of page]

Table: IEO_ALGORITHM_NAMES_ALL

Primary Key: IA_PK

1. ALGORITHM_NAME_ID

Primary Key: IA_UK

1. NAME
2. TYPE

Foreign Keys to this table:

Comments

Name for Advanced outbound Calendar and Recycle Algorithms

Columns

[top of page]

IEO.IEO_ALGORITHM_NAMES_ALL does not reference any database object

IEO.IEO_ALGORITHM_NAMES_ALL is referenced by following:

IEO

VIEW - IEO_ALGORITHM_NAMES_ALL#

[top of page]

Table: IEO_CAMPAIGNS_ALL

Primary Key: CAM_PK

1. CAMPAIGN_ID

Primary Key: CAM_UK

1. REF_TYPE
2. REF_NAME

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Campaign Plus campaigns

Columns

[top of page]

IEO.IEO_CAMPAIGNS_ALL does not reference any database object

IEO.IEO_CAMPAIGNS_ALL is referenced by following:

IEO

VIEW - IEO_CAMPAIGNS_ALL#

[top of page]

Table: IEO_CP_LIST_STATS_ALL

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:

Comments

Release statistics for records from CP Lists

Columns

[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:

IEO

VIEW - IEO_CP_LIST_STATS_ALL#

[top of page]

Table: IEO_CP_PHONETYPE_MSG_XRS_ALL

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:

Comments

Phone Type and Message ID cross reference table

Columns

[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:

IEO

VIEW - IEO_CP_PHONETYPE_MSG_XRS_ALL#

[top of page]

Table: IEO_CP_SERVICES_ALL

Primary Key: CPS_UK

1. LIST_SRV_NAME

Primary Key: LIST_PK

1. CP_SERVICE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Setup/configuration for all Campaign Plus services on this system

Columns

[top of page]

IEO.IEO_CP_SERVICES_ALL does not reference any database object

IEO.IEO_CP_SERVICES_ALL is referenced by following:

IEO

VIEW - IEO_CP_SERVICES_ALL#

[top of page]

Table: IEO_CP_STOP_LIST

Primary Key: CSL_PK

1. CP_STOP_LIST_ID

Comments

People who should not be called

Columns

[top of page]

IEO.IEO_CP_STOP_LIST does not reference any database object

IEO.IEO_CP_STOP_LIST is referenced by following:

IEO

VIEW - IEO_CP_STOP_LIST#

[top of page]

Table: IEO_CP_SVC_FIELDS_ALL

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:

Comments

Fields (user defined and name fields) implemented in each CP service

Columns

[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:

IEO

VIEW - IEO_CP_SVC_FIELDS_ALL#

[top of page]

Table: IEO_CP_SVC_LISTS_ALL

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 Keys to this table:

Comments

Calling lists supported by CP services

Columns

[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:

IEO

VIEW - IEO_CP_SVC_LISTS_ALL#

[top of page]

Table: IEO_LIST_CAMP_XRS_ALL

Primary Key: IL_PK

1. LIST_CAMP_XR_ID

Foreign Keys from this table:

Comments

List and Campaign cross reference table

Columns

[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:

IEO

VIEW - IEO_LIST_CAMP_XRS_ALL#

[top of page]

Table: IEO_PBX_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 Keys to this table:

Comments

PBX configuration info

Columns

[top of page]

IEO.IEO_PBX_INFO does not reference any database object

IEO.IEO_PBX_INFO is referenced by following:

IEO

VIEW - IEO_PBX_INFO#

[top of page]

Table: IEO_PREDSERVICES_ALL

Primary Key: PREDICTIVE_PK

1. PREDSERVICE_ID

Primary Key: PSV_UK

1. PRED_SRV_NAME
2. SREF_TYPE

Foreign Keys to this table:

Comments

Configuration for Predictive services

Columns

[top of page]

IEO.IEO_PREDSERVICES_ALL does not reference any database object

IEO.IEO_PREDSERVICES_ALL is referenced by following:

IEO

VIEW - IEO_PREDSERVICES_ALL#

[top of page]

Table: IEO_SVR_COMPS

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 Keys to this table:

Comments

Server Components. This table is written to at run-time by the servers to publish components (object instances) that are available. This is the object publication mechanism.
No WHO columns here... this is run-time data used for publication mechanism.

Indexes

Columns

[top of page]

IEO.IEO_SVR_COMPS does not reference any database object

IEO.IEO_SVR_COMPS is referenced by following:

IEO

VIEW - IEO_SVR_COMPS#

[top of page]

Table: IEO_SVR_COMP_DEFS

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 Keys to this table:

Comments

Server Component Definitions. This table is SEEDED to define the types of objects servers can publish. This acts as a simple interface repository.

Indexes

Columns

[top of page]

IEO.IEO_SVR_COMP_DEFS does not reference any database object

IEO.IEO_SVR_COMP_DEFS is referenced by following:

IEO

VIEW - IEO_SVR_COMP_DEFS#

[top of page]

Table: IEO_SVR_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 Keys to this table:

Comments

Server Groups group servers or other server groups. Server groups are used to associate users with a group of servers (i.e. in a call center) or to associate other entities in a similar manner.

Indexes

Columns

[top of page]

IEO.IEO_SVR_GROUPS does not reference any database object

IEO.IEO_SVR_GROUPS is referenced by following:

IEO

VIEW - IEO_SVR_GROUPS#

[top of page]

Table: IEO_SVR_PARAMS

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 Keys to this table:

Comments

Server Parameters identify parameters that can be associated with a particular type of server. This is technique provides the opportunity to have a more distributed way to administer server parameters, settings, etc.

Indexes

Columns

[top of page]

IEO.IEO_SVR_PARAMS does not reference any database object

IEO.IEO_SVR_PARAMS is referenced by following:

IEO

VIEW - IEO_SVR_PARAMS#

[top of page]

Table: IEO_SVR_PROTOCOL_MAP

Primary Key: IEO_SVR_PROTOCOL_MAP_PK

1. COMP_ID
2. WIRE_PROTOCOL

Foreign Keys from this table:

Comments

Server Protocol Maps identify protocols that are supported by certain components.

Indexes

Columns

[top of page]

IEO.IEO_SVR_PROTOCOL_MAP does not reference any database object

IEO.IEO_SVR_PROTOCOL_MAP is referenced by following:

IEO

VIEW - IEO_SVR_PROTOCOL_MAP#

[top of page]

Table: IEO_SVR_RT_INFO

Primary Key: IEO_SVR_RT_INFO_PK

1. SERVER_ID

Foreign Keys from this table:

Comments

Real-time information about servers is used for load-balancing, reconnection logic, etc. It includes server status (i.e., running or not), load factors, etc.
No WHO columns here... this is real-time data used only by the servers.

Indexes

Columns

[top of page]

IEO.IEO_SVR_RT_INFO does not reference any database object

IEO.IEO_SVR_RT_INFO is referenced by following:

IEO

VIEW - IEO_SVR_RT_INFO#

[top of page]

Table: IEO_SVR_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 Keys to this table:

Comments

Servers identify an instance of a particular type of server, and can be associated with a server groups.

Indexes

Columns

[top of page]

IEO.IEO_SVR_SERVERS does not reference any database object

IEO.IEO_SVR_SERVERS is referenced by following:

IEO

VIEW - IEO_SVR_SERVERS#

[top of page]

Table: IEO_SVR_TYPES_B

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:

Comments

A server type classifies a particular type of server.
The base table contains the basic information about a server type entity.

Indexes

Columns

[top of page]

IEO.IEO_SVR_TYPES_B does not reference any database object

IEO.IEO_SVR_TYPES_B is referenced by following:

IEO

VIEW - IEO_SVR_TYPES_B#

[top of page]

Table: IEO_SVR_TYPES_TL

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:

Comments

A server type classifies a particular type of server.
The translation table contains the translated information about a server type entity.

Indexes

Columns

[top of page]

IEO.IEO_SVR_TYPES_TL does not reference any database object

IEO.IEO_SVR_TYPES_TL is referenced by following:

IEO

VIEW - IEO_SVR_TYPES_TL#

[top of page]

Table: IEO_SVR_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:

Comments

Server Values contains the actual values for a particular instance of a server. The parameters identify thepossible set of parameters for a particular server type, and the values represent the values of those parameters for a particular instnce of a server.

Indexes

Columns

[top of page]

IEO.IEO_SVR_VALUES does not reference any database object

IEO.IEO_SVR_VALUES is referenced by following:

IEO

VIEW - IEO_SVR_VALUES#

[top of page]

Table: IEO_SYSTEM_CAMPS_ALL

Primary Key: SYSCAMP_PK

1. SYSTEM_CAMP_ID

Foreign Keys from this table:

Comments

ISSUE
=====
All Campaign tables will have to replaced by marketing campaign tables

Columns

[top of page]

IEO.IEO_SYSTEM_CAMPS_ALL does not reference any database object

IEO.IEO_SYSTEM_CAMPS_ALL is referenced by following:

IEO

VIEW - IEO_SYSTEM_CAMPS_ALL#

[top of page]

Table: IEO_SYST_CP_SVCS_ALL

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:

Comments

Centralized gateway to IEO_LIST_SERVICES which may be distributed

Columns

[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:

IEO

VIEW - IEO_SYST_CP_SVCS_ALL#

[top of page]

Table: IEO_VDU_INFO

Primary Key: VDU_PK

1. VDU_INFO_ID

Foreign Keys from this table:

Comments

VDU configuration info

Columns

[top of page]

IEO.IEO_VDU_INFO does not reference any database object

IEO.IEO_VDU_INFO is referenced by following:

IEO

VIEW - IEO_VDU_INFO#

[top of page]

Table: IEO_VOICE_MSGS_ALL

Primary Key: VMSG_PK

1. VOICE_MSG_ID

Foreign Keys to this table:

Comments

Currently defined voice messages available to be played to callee

Columns

[top of page]

IEO.IEO_VOICE_MSGS_ALL does not reference any database object

IEO.IEO_VOICE_MSGS_ALL is referenced by following:

IEO

VIEW - IEO_VOICE_MSGS_ALL#

[top of page]

View: IEO_LOOKUPS

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns

[top of page]

APPS

SYNONYM - FND_LOOKUP_VALUES

APPS.IEO_LOOKUPS is not referenced by any database object

[top of page]

View: IEO_SVR_TYPES_VL

Comments

View Type

MultiLingual view (a language resolved view of the data.)

This view represents translated server types, and is used to display the server type LOV in the server locator form.

Columns

[top of page]

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]