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

TABLE - IES.IES_AGENTS

TABLE - IES.IES_ANSWERS

TABLE - IES.IES_AUX_SCRIPT_RELATIONSHIPS

TABLE - IES.IES_DATA_TABLES

TABLE - IES.IES_DEPLOYED_SCRIPTS

TABLE - IES.IES_DEV_SCRIPTS

TABLE - IES.IES_JARFILES

TABLE - IES.IES_LOOKUPS

TABLE - IES.IES_LOOKUP_TABLES

TABLE - IES.IES_PANELS

TABLE - IES.IES_PANEL_DATA

TABLE - IES.IES_QUESTIONS

TABLE - IES.IES_QUESTION_DATA

TABLE - IES.IES_SCRIPT_JARFILES

TABLE - IES.IES_SVY_CYCLES_ALL

TABLE - IES.IES_SVY_DEPLYMENTS_ALL

TABLE - IES.IES_SVY_ENTRS_REMIND_HST

TABLE - IES.IES_SVY_HOSTING_PROFILES

TABLE - IES.IES_SVY_LIST_ENTRIES

TABLE - IES.IES_SVY_REMINDERS

TABLE - IES.IES_SVY_REMINDER_HST

TABLE - IES.IES_SVY_RESOURCES

TABLE - IES.IES_SVY_RESPONSES

TABLE - IES.IES_SVY_RESPONSE_ENTRIES

TABLE - IES.IES_SVY_SUMMARY_STATS

TABLE - IES.IES_SVY_SURVEYS_ALL

TABLE - IES.IES_TRANSACTIONS

VIEW - APPS.IES_AMS_LIST_ENTRIES_V

VIEW - APPS.IES_AMS_LIST_HEADERS_V

VIEW - APPS.IES_SVY_CYCLES_V

VIEW - APPS.IES_SVY_DEPLYMENTS_V

VIEW - APPS.IES_SVY_ENTRS_RMD_HST_V

VIEW - APPS.IES_SVY_HOSTING_PROF_V

VIEW - APPS.IES_SVY_JTF_FM_TEMPLATE_V

VIEW - APPS.IES_SVY_LIST_ENTRIES_V

VIEW - APPS.IES_SVY_REMINDERS_V

VIEW - APPS.IES_SVY_REMINDER_HST_V

VIEW - APPS.IES_SVY_RESOURCES_V

VIEW - APPS.IES_SVY_RESP_ENTRIES_V

VIEW - APPS.IES_SVY_SUMMARY_STATS_V

VIEW - APPS.IES_SVY_SURVEYS_V

Table: IES_AGENTS

Primary Key: IES_AGENTS_PK

1. AGENT_ID

Foreign Keys to this table:

Comments

The IES_AGENTS table contains records for all agents who have used and who will use Scripting. Each agent record stores the database login name (string) for the agent. This database login is also used as the agent?s login to Scripting. This information is stored as a string instead of as a reference to a record in the system table to prevent problems with a referenced login being removed from the database.
The agent record also references an agent as stored in the Resource Manager schema. Agent permissions are defined in the Resource Manager schema and will be used for permission-based views. The exact relationships are yet to be determined.

Indexes

Columns

[top of page]

IES.IES_AGENTS does not reference any database object

IES.IES_AGENTS is referenced by following:

IES

VIEW - IES_AGENTS#

[top of page]

Table: IES_ANSWERS

Primary Key: IES_ANSWERS_PK

1. ANSWER_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

The IES_ANSWERS table contains lookup choices as referenced by the IES_LOOKUPS table. An answer references a lookup in the IES_LOOKUPS table and represents a choice for a question and its associated value (ANSWER_VALUE). The actual string to be used is specified in the ANSWER_DISPLAY_VALUE column.

Indexes

Columns

[top of page]

IES.IES_ANSWERS does not reference any database object

IES.IES_ANSWERS is referenced by following:

IES

VIEW - IES_ANSWERS#

[top of page]

Table: IES_AUX_SCRIPT_RELATIONSHIPS

Primary Key: IES_AUX_SCRIPT_RELATIONSHIP_PK

1. SCRIPT_RELATIONSHIP_ID

Foreign Keys from this table:

Comments

The Auxiliary Schema tables of Oracle Scripting are composed of those schema tables which are included as part of the base schema, but whose records are not inserted, updated, deleted, or modified in any way by either the Script Author or by the runtime Engine. These tables are provided as a convenience for applications which wish to extend Scripting data with their own data and in order to have a single schema definition for tables which may be shared by more than one application that needs to extend the data provided by Scripting.

Indexes

Columns

[top of page]

IES.IES_AUX_SCRIPT_RELATIONSHIPS does not reference any database object

IES.IES_AUX_SCRIPT_RELATIONSHIPS is referenced by following:

IES

VIEW - IES_AUX_SCRIPT_RELATIONSHIPS#

[top of page]

Table: IES_DATA_TABLES

Primary Key: IES_DATA_TABLES_PK

1. TABLE_ID

Foreign Keys to this table:

Comments

The IES_DATA_TABLES table lists the names of all tables which are to be used for storing footprinting and question data collected for any script listed in the IES_DEPLOYED_SCRIPTS table. The IES_PANEL_DATA and IES_QUESTION_DATA tables are always listed in the IES_DATA_TABLES table, with TABLE_IDs of 1 and 2.
At the end of an interaction, the Scripting Engine writes the list of panels that were accessed during the script, along with the start and end times for each panel, known as "footprinting" data, to the PANEL_DATA table.
In addition at the end of an interaction, the Scripting Engine writes the list of answers to questions marked "collectable" to the QUESTION DATA table.

Indexes

Columns

[top of page]

IES.IES_DATA_TABLES does not reference any database object

IES.IES_DATA_TABLES is referenced by following:

IES

VIEW - IES_DATA_TABLES#

[top of page]

Table: IES_DEPLOYED_SCRIPTS

Primary Key: IES_DEPLOYED_SCRIPTS_PK

1. DSCRIPT_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table contains all deployed scripts in the form of a binary file stored in the database. Also specifies the table that is used for storing panel timing (footprinting) and answer data collected during the script. The language id is the the key from fnd_languages table.

Indexes

Columns

[top of page]

IES.IES_DEPLOYED_SCRIPTS does not reference any database object

IES.IES_DEPLOYED_SCRIPTS is referenced by following:

IES

VIEW - IES_DEPLOYED_SCRIPTS#

[top of page]

Table: IES_DEV_SCRIPTS

Primary Key: IES_DEV_SCRIPTS_PK

1. DEV_SCRIPT_ID

Comments

This table contains all dev scripts in the form of a binary file stored in the database.

Indexes

Columns

[top of page]

IES.IES_DEV_SCRIPTS does not reference any database object

IES.IES_DEV_SCRIPTS is referenced by following:

IES

VIEW - IES_DEV_SCRIPTS#

[top of page]

Table: IES_JARFILES

Primary Key: IES_JARFILES_PK

1. JARFILE_ID

Foreign Keys to this table:

Comments

The IES_JARFILES table stores all jar files that are used by the scripts deployed in the database. Each record is identified by a unique ID and a unique name. Each record in this table stores a single jar file and may be used by one or more scripts.

Indexes

Columns

[top of page]

IES.IES_JARFILES does not reference any database object

IES.IES_JARFILES is referenced by following:

IES

VIEW - IES_JARFILES#

[top of page]

Table: IES_LOOKUPS

Primary Key: IES_LOOKUPS_PK

1. LOOKUP_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

The IES_LOOKUPS table lists all lookups used by questions in the IES_QUESTIONS table. The lookup choices used by the questions can either be stored in the IES_ANSWERS table or in any table which follows the format specified by .
The IES_LOOKUPS table specifies a LOOKUP_TABLE_ID, which references the IES_LOOKUP_TABLES table, where the names of all lookup tables are stored.
The IES_ANSWERS table is always listed in the IES_LOOKUP_TABLES table with a TABLE_ID of 0 (zero).

Indexes

Columns

[top of page]

IES.IES_LOOKUPS does not reference any database object

IES.IES_LOOKUPS is referenced by following:

IES

VIEW - IES_LOOKUPS#

[top of page]

Table: IES_LOOKUP_TABLES

Primary Key: IES_LOOKUP_TABLES_PK

1. TABLE_ID

Foreign Keys to this table:

Comments

Stores the names of external tables referenced by the IES_LOOKUPS table.

Indexes

Columns

[top of page]

IES.IES_LOOKUP_TABLES does not reference any database object

IES.IES_LOOKUP_TABLES is referenced by following:

IES

VIEW - IES_LOOKUP_TABLES#

[top of page]

Table: IES_PANELS

Primary Key: IES_PANELS_PK

1. PANEL_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

The IES_PANELS table contains all panels in the deployed scripts. Each record in the IES_PANELS table references a script in the IES_DEPLOYED_SCRIPTS table and a panel contained by the script (referenced by name).

Indexes

Columns

[top of page]

IES.IES_PANELS does not reference any database object

IES.IES_PANELS is referenced by following:

IES

VIEW - IES_PANELS#

[top of page]

Table: IES_PANEL_DATA

Primary Key: IES_PANEL_DATA_PK

1. PANEL_DATA_ID

Foreign Keys from this table:

Comments

At the end of an interaction, the Scripting Engine writes the list of panels that were accessed during the script, along with the start and end times for each panel, known as "footprinting" data, to the IES_PANEL_DATA table. Each time that a panel is either added or simply enabled will count as a separate record in the IES_PANEL_DATA table.

Indexes

Columns

[top of page]

IES.IES_PANEL_DATA does not reference any database object

IES.IES_PANEL_DATA is referenced by following:

IES

VIEW - IES_PANEL_DATA#

[top of page]

Table: IES_QUESTIONS

Primary Key: IES_QUESTIONS_PK

1. QUESTION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

The IES_QUESTIONS table contains all questions whose answers will be stored and/or need a dynamic lookup. Each record in the IES_QUESTIONS table references a panel in the IES_PANELS table and a node contained by the script (referenced by name). If the node requires a lookup, the record will reference a lookup in the IES_LOOKUPS table.

Indexes

Columns

[top of page]

IES.IES_QUESTIONS does not reference any database object

IES.IES_QUESTIONS is referenced by following:

IES

VIEW - IES_QUESTIONS#

[top of page]

Table: IES_QUESTION_DATA

Primary Key: IES_QUESTION_DATA_PK

1. QUESTION_DATA_ID

Foreign Keys from this table:

Comments

Each answer collected by the Scripting Engine is stored in the IES_QUESTION_DATA or equivalent table as a individual record. For each record, a unique DATA_ID is generated and the TRANSACTION_ID and QUESTION_ID columns must be filled. If the answer given was associated with a lookup choice, the LOOKUP_ID column will be filled in with a reference to the IES_LOOKUPS table and the ANSWER_ID column will be filled in with a reference to either the IES_ANSWERS table or a separate lookup table. If the answer did not have an associated lookup choice, then the answer given will be stored in the FREEFORM_STRING column as a string.

Indexes

Columns

[top of page]

IES.IES_QUESTION_DATA does not reference any database object

IES.IES_QUESTION_DATA is referenced by following:

IES

VIEW - IES_QUESTION_DATA#

[top of page]

Table: IES_SCRIPT_JARFILES

Primary Key: IES_SCRIPT_JARFILES_PK

1. SCRIPT_JARFILE_ID

Foreign Keys from this table:

Comments

Each record in the IES_SCRIPT_JARFILES table links a jar file in the IES_ JARFILES table with a script. Scripts can share records in the IES_ JARFILES table.
This table serves as a classpath function for JavaCommands that need to be executed in the script. When a JavaCommand is executed in the Engine, the jar files associated with the script are searched for the class to be instantiated.

Indexes

Columns

[top of page]

IES.IES_SCRIPT_JARFILES does not reference any database object

IES.IES_SCRIPT_JARFILES is referenced by following:

IES

VIEW - IES_SCRIPT_JARFILES#

[top of page]

Table: IES_SVY_CYCLES_ALL

Primary Key: IES_SVY_CYCLES_ALL_PK

1. SURVEY_CYCLE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Each cycle has a survey associated with it and contains zero or more deployments.

Indexes

Columns

[top of page]

IES.IES_SVY_CYCLES_ALL does not reference any database object

IES.IES_SVY_CYCLES_ALL is referenced by following:

IES

VIEW - IES_SVY_CYCLES_ALL#

[top of page]

Table: IES_SVY_DEPLYMENTS_ALL

Primary Key: IES_SVY_DEPLYMENTS_ALL_PK

1. SURVEY_DEPLOYMENT_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

A cycle can have multiple deployments. For list based survey each deployment is associated with a list. Therefore a large list can be broken down into
number of small lists. Each of these list can be associated with a deoplyment.

Indexes

Columns

[top of page]

IES.IES_SVY_DEPLYMENTS_ALL does not reference any database object

IES.IES_SVY_DEPLYMENTS_ALL is referenced by following:

IES

VIEW - IES_SVY_DEPLYMENTS_ALL#

[top of page]

Table: IES_SVY_ENTRS_REMIND_HST

Primary Key: IES_SVY_ENTRS_REMIND_HST_PK

1. ENTRY_REMINDER_HST_ID

Foreign Keys from this table:

Comments

This table contains the dates reminders were sent to each individual person in the IES_SVY_LIST_ENTRIES for list based survey. This allows the reminder
history to be kept at the list entry level. For anonymous survey execution this will include all the entries in a list. For non anonymous it'll only send the
reminders to those who haven't responded.

Indexes

Columns

[top of page]

IES.IES_SVY_ENTRS_REMIND_HST does not reference any database object

IES.IES_SVY_ENTRS_REMIND_HST is referenced by following:

IES

VIEW - IES_SVY_ENTRS_REMIND_HST#

[top of page]

Table: IES_SVY_HOSTING_PROFILES

Primary Key: IES_SVY_HOSTING_PROFILES_PK

1. HOSTING_PROFILE_ID

Foreign Keys from this table:

Comments

This table contains survey hosting information. It adds iessvymain.jsp to the web URL to
form the invitation URL for survey e-mail invitation.

Indexes

Columns

[top of page]

IES.IES_SVY_HOSTING_PROFILES does not reference any database object

IES.IES_SVY_HOSTING_PROFILES is referenced by following:

IES

VIEW - IES_SVY_HOSTING_PROFILES#

[top of page]

Table: IES_SVY_LIST_ENTRIES

Primary Key: IES_SVY_LIST_ENTRIES_PK

1. SURVEY_LIST_ENTRY_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

For each entry in the list associated with a list based deployment there is an entry in this table. It also stores a unique ID for that entry which will be used
to track the user in invitation URL. It also tracks the no of times a respondent has taken the survey.

Indexes

Columns

[top of page]

IES.IES_SVY_LIST_ENTRIES does not reference any database object

IES.IES_SVY_LIST_ENTRIES is referenced by following:

IES

VIEW - IES_SVY_LIST_ENTRIES#

[top of page]

Table: IES_SVY_REMINDERS

Primary Key: IES_SVY_REMINDERS_PK

1. SURVEY_REMINDER_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Reminders will be sent only to list based surveys. Reminders will be far apart as per the interval days. Reminders wil be sent only within the survey window
period.

Indexes

Columns

[top of page]

IES.IES_SVY_REMINDERS does not reference any database object

IES.IES_SVY_REMINDERS is referenced by following:

IES

VIEW - IES_SVY_REMINDERS#

[top of page]

Table: IES_SVY_REMINDER_HST

Primary Key: IES_SVY_REMINDER_HST_PK

1. SURVEY_REMINDER_HST_ID

Foreign Keys from this table:

Comments

Based on the setup in IES_SVY_REMINDERS reminders will be sent out automatically via concurrent program. After the reminder is sent out historical
information will be stored in this table

Indexes

Columns

[top of page]

IES.IES_SVY_REMINDER_HST does not reference any database object

IES.IES_SVY_REMINDER_HST is referenced by following:

IES

VIEW - IES_SVY_REMINDER_HST#

[top of page]

Table: IES_SVY_RESOURCES

Primary Key: ISR_PK

1. SURVEY_RESOURCE_ID

Comments

This table contains all the resouces defined to be used as header, error or final pages in the survey. The resources are defined under Resource sub tab in
main Survey tab. When creating a survey, the lookups for Header, Error and Final Pages will be based on a query on this table

Indexes

Columns

[top of page]

IES.IES_SVY_RESOURCES does not reference any database object

IES.IES_SVY_RESOURCES is referenced by following:

IES

VIEW - IES_SVY_RESOURCES#

[top of page]

Table: IES_SVY_RESPONSES

Primary Key: IES_SVY_RESPONSES_PK

1. SURVEY_QUES_ANS_ID
2. SURVEY_CYCLE_ID
3. TRANSACTION_ID

Comments

Columns

[top of page]

IES.IES_SVY_RESPONSES does not reference any database object

IES.IES_SVY_RESPONSES is referenced by following:

IES

VIEW - IES_SVY_RESPONSES#

[top of page]

Table: IES_SVY_RESPONSE_ENTRIES

Primary Key: IES_SVY_RESPONSE_ENTRIES_PK

1. RESPONSE_ID

Foreign Keys from this table:

Comments

This table contains the response details for each individual survey taken. It stores transaction id which ties a person from survey schema to scripting
schema. For list based survey TRANSACTION_ID and SURVEY_LIST_ENTRY_ID ties a person on a list with the responses collected in the scripting
scehma

Indexes

Columns

[top of page]

IES.IES_SVY_RESPONSE_ENTRIES does not reference any database object

IES.IES_SVY_RESPONSE_ENTRIES is referenced by following:

IES

VIEW - IES_SVY_RESPONSE_ENTRIES#

[top of page]

Table: IES_SVY_SUMMARY_STATS

Primary Key: IES_SVY_SUMMARY_STATS_PK

1. SURVEY_ID
2. SURVEY_CYCLE_ID
3. SURVEY_DEPLOYMENT_ID

Foreign Keys from this table:

Comments

This table contains the summary information of responses per deployment. A summary program sums up informations such as total no of invitaitons and
reminders sent, total no of responses received , total no of errors etc.

Indexes

Columns

[top of page]

IES.IES_SVY_SUMMARY_STATS does not reference any database object

IES.IES_SVY_SUMMARY_STATS is referenced by following:

IES

VIEW - IES_SVY_SUMMARY_STATS#

[top of page]

Table: IES_SVY_SURVEYS_ALL

Primary Key: IES_SVY_SURVEYS_ALL_PK

1. SURVEY_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table contains the definition of individual survey. Each survey will be associated with a script defined by DSCRIPT_ID column.

Indexes

Columns

[top of page]

IES.IES_SVY_SURVEYS_ALL does not reference any database object

IES.IES_SVY_SURVEYS_ALL is referenced by following:

IES

VIEW - IES_SVY_SURVEYS_ALL#

[top of page]

Table: IES_TRANSACTIONS

Primary Key: IES_TRANSACTIONS_PK

1. TRANSACTION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

The IES_TRANSACTIONS table contains all interactions. Each session through which an agent follows the flow of a script with a customer is considered a single interaction.
An interaction references the agent involved in the interaction as well as the script that was running in the interaction.

Indexes

Columns

[top of page]

IES.IES_TRANSACTIONS does not reference any database object

IES.IES_TRANSACTIONS is referenced by following:

IES

VIEW - IES_TRANSACTIONS#

[top of page]

View: IES_AMS_LIST_ENTRIES_V

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

View on AMS_LIST_ENTRIES table

Columns

[top of page]

APPS

SYNONYM - AMS_LIST_ENTRIES

APPS.IES_AMS_LIST_ENTRIES_V is not referenced by any database object

[top of page]

View: IES_AMS_LIST_HEADERS_V

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

View on AMS_LIST_HEADERS_VL view

Columns

[top of page]

APPS

VIEW - AMS_LIST_HEADERS_VL

APPS.IES_AMS_LIST_HEADERS_V is not referenced by any database object

[top of page]

View: IES_SVY_CYCLES_V

Comments

View Type

A public view which may be useful for custom reporting or other data requirements.

View on IES_SVY_CYCLES_ALL

Columns