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 - IEB Tables and Views

TABLE - IEB.IEB_AGENT_INDEXES
TABLE - IEB.IEB_AGENT_MAPS
TABLE - IEB.IEB_INB_SVC_COVERAGES
TABLE - IEB.IEB_MEDIA_TASK_SOURCES
TABLE - IEB.IEB_MMS_SERVERS
TABLE - IEB.IEB_OUTB_SVC_COVERAGES
TABLE - IEB.IEB_SERVICE_PLANS
TABLE - IEB.IEB_SVC_CAT_TEMPS_B
TABLE - IEB.IEB_SVC_CAT_TEMPS_TL
TABLE - IEB.IEB_SVC_VIRTUAL_QUEUES
TABLE - IEB.IEB_WBST_WB_SC_RULES
TABLE - IEB.IEB_WB_SERVERS
TABLE - IEB.IEB_WB_SKILL_TRANS
TABLE - IEB.IEB_WB_SVC_CATS
TABLE - IEB.IEB_WB_SVC_CAT_RULES
TABLE - IEB.IEB_WB_SVRS_MMS_SVRS
TABLE - IEB.IEB_WB_WORK_ITEMS
VIEW - APPS.IEB_SVC_CAT_CLASSIFICATIONS_V
VIEW - APPS.IEB_SVC_CAT_TEMPLATES

Table: IEB_AGENT_INDEXES

Description: Mapping of Agent IDs with internal bit map indexes, for IEB server internal use only.
Primary Key: IEB_AGENT_INDEXES_PK
  1. AGENT_ID
  2. WBSVR_WBSVR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_AGENT_INDEXES.WBSVR_WBSVR_ID IEB_WB_SERVERS

[top of page]

IEB.IEB_AGENT_INDEXES does not reference any database object

IEB.IEB_AGENT_INDEXES is referenced by following:

IEB
VIEW - IEB_AGENT_INDEXES#

[top of page]

Table: IEB_AGENT_MAPS

Description: Indexes of member agents for virtual queues.
Primary Key: IEB_AGENT_MAPS_PK
  1. AGTMAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_AGENT_MAPS.SVCVQ_SVCVQ_ID IEB_SVC_VIRTUAL_QUEUES

[top of page]

IEB.IEB_AGENT_MAPS does not reference any database object

IEB.IEB_AGENT_MAPS is referenced by following:

IEB
VIEW - IEB_AGENT_MAPS#

[top of page]

Table: IEB_INB_SVC_COVERAGES

Description: Service goals of coverage periods within inbound service plans.
Primary Key: IEB_INB_SVC_COVERAGES_PK
  1. ISVCCOV_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_INB_SVC_COVERAGES.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS

[top of page]

IEB.IEB_INB_SVC_COVERAGES does not reference any database object

IEB.IEB_INB_SVC_COVERAGES is referenced by following:

IEB
VIEW - IEB_INB_SVC_COVERAGES#

[top of page]

Table: IEB_MEDIA_TASK_SOURCES

Description: Media sources of Media Manager Servers. (Obsolete table)
Primary Key: IEB_MEDIA_TASK_SOURCES_PK
  1. MTS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_MEDIA_TASK_SOURCES.MMSSVR_MMSSVR_ID IEB_MMS_SERVERS

[top of page]

IEB.IEB_MEDIA_TASK_SOURCES does not reference any database object

IEB.IEB_MEDIA_TASK_SOURCES is referenced by following:

IEB
VIEW - IEB_MEDIA_TASK_SOURCES#

[top of page]

Table: IEB_MMS_SERVERS

Description: Summary of media server information. This is an obsolete table, replaced by IEO server location schema.
Primary Key: IEB_MMS_SERVERS_PK
  1. MMSSVR_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_MEDIA_TASK_SOURCES.MMSSVR_MMSSVR_ID IEB_MMS_SERVERS
IEB_WB_SVRS_MMS_SVRS.MMSSVR_MMSSVR_ID IEB_MMS_SERVERS

[top of page]

IEB.IEB_MMS_SERVERS does not reference any database object

IEB.IEB_MMS_SERVERS is referenced by following:

IEB
VIEW - IEB_MMS_SERVERS#

[top of page]

Table: IEB_OUTB_SVC_COVERAGES

Description: Service goals of coverage periods of outbound service plans.
Primary Key: IEB_OUTB_SVC_COVERAGES_PK
  1. OSVCCOV_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_OUTB_SVC_COVERAGES.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS

[top of page]

IEB.IEB_OUTB_SVC_COVERAGES does not reference any database object

IEB.IEB_OUTB_SVC_COVERAGES is referenced by following:

IEB
VIEW - IEB_OUTB_SVC_COVERAGES#

[top of page]

Table: IEB_SERVICE_PLANS

Description: Summary information of service plans.
Primary Key: IEB_SERVICE_PLANS_PK
  1. SVCPLN_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_INB_SVC_COVERAGES.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS
IEB_OUTB_SVC_COVERAGES.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS
IEB_SVC_CAT_TEMPS_B.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS
IEB_WB_SVC_CATS.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS

[top of page]

IEB.IEB_SERVICE_PLANS does not reference any database object

IEB.IEB_SERVICE_PLANS is referenced by following:

IEB
VIEW - IEB_SERVICE_PLANS#

[top of page]

Table: IEB_SVC_CAT_TEMPS_B

Description: Templates for Top Level Service Categories
Primary Key: IEB_SVC_CAT_TEMPS_B_PK
  1. WBSC_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_SVC_CAT_TEMPS_B.PARENT_ID IEB_SVC_CAT_TEMPS_B
IEB_SVC_CAT_TEMPS_B.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_SVC_CAT_TEMPS_B.PARENT_ID IEB_SVC_CAT_TEMPS_B
IEB_SVC_CAT_TEMPS_TL.WBSC_ID IEB_SVC_CAT_TEMPS_B

[top of page]

IEB.IEB_SVC_CAT_TEMPS_B does not reference any database object

IEB.IEB_SVC_CAT_TEMPS_B is referenced by following:

IEB
VIEW - IEB_SVC_CAT_TEMPS_B#

[top of page]

Table: IEB_SVC_CAT_TEMPS_TL

Description: Translated Service Category Name
Primary Key: IEB_SCTEMPTL_PK
  1. WBSC_ID
  2. LANGUAGE
Primary Key: IEB_SCTEMPTL_UK
  1. LANGUAGE
  2. SERVICE_CATEGORY_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_SVC_CAT_TEMPS_TL.WBSC_ID IEB_SVC_CAT_TEMPS_B

[top of page]

IEB.IEB_SVC_CAT_TEMPS_TL does not reference any database object

IEB.IEB_SVC_CAT_TEMPS_TL is referenced by following:

IEB
VIEW - IEB_SVC_CAT_TEMPS_TL#

[top of page]

Table: IEB_SVC_VIRTUAL_QUEUES

Description: Summary information of virtal queues, i.e., dynamic agent groups, for IEB server internal use.
Primary Key: IEB_SVC_VIRTUAL_QUEUES_PK
  1. SVCVQ_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_SVC_VIRTUAL_QUEUES.WBSC_WBSC_ID IEB_WB_SVC_CATS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_AGENT_MAPS.SVCVQ_SVCVQ_ID IEB_SVC_VIRTUAL_QUEUES
IEB_WB_WORK_ITEMS.SVCVQ_SVCVQ_ID IEB_SVC_VIRTUAL_QUEUES

[top of page]

IEB.IEB_SVC_VIRTUAL_QUEUES does not reference any database object

IEB.IEB_SVC_VIRTUAL_QUEUES is referenced by following:

IEB
VIEW - IEB_SVC_VIRTUAL_QUEUES#

[top of page]

Table: IEB_WBST_WB_SC_RULES

Description: Intersection table that defines the M to M relations between service category selection rules and skill requirements.
Primary Key: IEB_WBST_WB_SC_RULES_PK
  1. WBSKTR_WBSKTR_ID
  2. WBSCRULE_WBSCRULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_WBST_WB_SC_RULES.WBSCRULE_WBSCRULE_ID IEB_WB_SVC_CAT_RULES
IEB_WBST_WB_SC_RULES.WBSKTR_WBSKTR_ID IEB_WB_SKILL_TRANS

[top of page]

IEB.IEB_WBST_WB_SC_RULES does not reference any database object

IEB.IEB_WBST_WB_SC_RULES is referenced by following:

IEB
VIEW - IEB_WBST_WB_SC_RULES#

[top of page]

Table: IEB_WB_SERVERS

Description: Summary Information of IEB servers.
Primary Key: IEB_WB_SERVERS_NM_UK
  1. WB_SERVER_NAME
Primary Key: IEB_WB_SERVERS_PK
  1. WBSVR_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_AGENT_INDEXES.WBSVR_WBSVR_ID IEB_WB_SERVERS
IEB_WB_SVC_CATS.WBSVR_WBSVR_ID IEB_WB_SERVERS
IEB_WB_SVRS_MMS_SVRS.WBSVR_WBSVR_ID IEB_WB_SERVERS

[top of page]

IEB.IEB_WB_SERVERS does not reference any database object

IEB.IEB_WB_SERVERS is referenced by following:

IEB
VIEW - IEB_WB_SERVERS#

[top of page]

Table: IEB_WB_SKILL_TRANS

Description: Definition of skill requirements for service category selection rules.
Primary Key: IEB_WB_SKILL_TRANS_PK
  1. WBSKTR_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_WBST_WB_SC_RULES.WBSKTR_WBSKTR_ID IEB_WB_SKILL_TRANS

[top of page]

IEB.IEB_WB_SKILL_TRANS does not reference any database object

IEB.IEB_WB_SKILL_TRANS is referenced by following:

IEB
VIEW - IEB_WB_SKILL_TRANS#

[top of page]

Table: IEB_WB_SVC_CATS

Description: Summary Information of service categories.
Primary Key: IEB_WB_SVC_CATS_PK
  1. WBSC_ID
Primary Key: WBSC_UK
  1. SERVICE_CATEGORY_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_WB_SVC_CATS.PARENT_ID IEB_WB_SVC_CATS
IEB_WB_SVC_CATS.SVCPLN_SVCPLN_ID IEB_SERVICE_PLANS
IEB_WB_SVC_CATS.WBSVR_WBSVR_ID IEB_WB_SERVERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_SVC_VIRTUAL_QUEUES.WBSC_WBSC_ID IEB_WB_SVC_CATS
IEB_WB_SVC_CATS.PARENT_ID IEB_WB_SVC_CATS
IEB_WB_SVC_CAT_RULES.WBSC_WBSC_ID IEB_WB_SVC_CATS

[top of page]

IEB.IEB_WB_SVC_CATS does not reference any database object

IEB.IEB_WB_SVC_CATS is referenced by following:

IEB
VIEW - IEB_WB_SVC_CATS#

[top of page]

Table: IEB_WB_SVC_CAT_RULES

Description: Rules for selecting inbound media tasks into service categories.
Primary Key: IEB_WB_SVC_CAT_RULES_PK
  1. WBSCRULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_WB_SVC_CAT_RULES.WBSC_WBSC_ID IEB_WB_SVC_CATS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IEB_WBST_WB_SC_RULES.WBSCRULE_WBSCRULE_ID IEB_WB_SVC_CAT_RULES

[top of page]

IEB.IEB_WB_SVC_CAT_RULES does not reference any database object

IEB.IEB_WB_SVC_CAT_RULES is referenced by following:

IEB
VIEW - IEB_WB_SVC_CAT_RULES#

[top of page]

Table: IEB_WB_SVRS_MMS_SVRS

Description: Intersection table between Media Manager Servers and IEB servers. (Obsolete).
Primary Key: IEB_WB_SVRS_MMS_SVRS_PK
  1. WBMMS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_WB_SVRS_MMS_SVRS.MMSSVR_MMSSVR_ID IEB_MMS_SERVERS
IEB_WB_SVRS_MMS_SVRS.WBSVR_WBSVR_ID IEB_WB_SERVERS

[top of page]

IEB.IEB_WB_SVRS_MMS_SVRS does not reference any database object

IEB.IEB_WB_SVRS_MMS_SVRS is referenced by following:

IEB
VIEW - IEB_WB_SVRS_MMS_SVRS#

[top of page]

Table: IEB_WB_WORK_ITEMS

Description: Media work items.
Primary Key: IEB_WB_WORK_ITEMS_PK
  1. WITM_ID
Primary Key: IEB_WB_WORK_ITEM_UK
  1. WORK_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IEB_WB_WORK_ITEMS.SVCVQ_SVCVQ_ID IEB_SVC_VIRTUAL_QUEUES

[top of page]

IEB.IEB_WB_WORK_ITEMS does not reference any database object

IEB.IEB_WB_WORK_ITEMS is referenced by following:

IEB
VIEW - IEB_WB_WORK_ITEMS#

[top of page]

View: IEB_SVC_CAT_CLASSIFICATIONS_V

[top of page]

APPS.IEB_SVC_CAT_CLASSIFICATIONS_V references the following:

APPS
SYNONYM - IEB_WB_SERVERS
SYNONYM - IEB_WB_SVC_CATS
SYNONYM - IEB_WB_SVC_CAT_RULES

APPS.IEB_SVC_CAT_CLASSIFICATIONS_V is not referenced by any database object

[top of page]

View: IEB_SVC_CAT_TEMPLATES

[top of page]

APPS.IEB_SVC_CAT_TEMPLATES references the following:

APPS
SYNONYM - IEB_SVC_CAT_TEMPS_B
SYNONYM - IEB_SVC_CAT_TEMPS_TL

APPS.IEB_SVC_CAT_TEMPLATES is not referenced by any database object

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