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

TABLE - APPLSYS.AD_APPLIED_PATCHES
TABLE - APPLSYS.AD_APPL_TOPS
TABLE - APPLSYS.AD_APPS_DEPENDENCIES
TABLE - APPLSYS.AD_BUGS
TABLE - APPLSYS.AD_CHECK_FILES
TABLE - APPLSYS.AD_CHECK_FILE_TEMP
TABLE - APPLSYS.AD_COMPRISING_PATCHES
TABLE - APPLSYS.AD_EVENTS
TABLE - APPLSYS.AD_EVENT_TRANSITIONS
TABLE - APPLSYS.AD_EVENT_VERSIONS
TABLE - APPLSYS.AD_FEATURE_VERSIONS
TABLE - APPLSYS.AD_FILES
TABLE - APPLSYS.AD_FILES_SRC_DEST_TEMP
TABLE - APPLSYS.AD_FILE_VERSIONS
TABLE - APPLSYS.AD_FIXED_ISSUES
TABLE - APPLSYS.AD_HIDDEN_PATCHES
TABLE - APPLSYS.AD_INSTALL_PROCESSES
TABLE - APPLSYS.AD_INVOKER_TASKS
TABLE - APPLSYS.AD_JOBS_DEFERRED
TABLE - APPLSYS.AD_LONG_COLUMN_CONVERSIONS
TABLE - APPLSYS.AD_MANUAL_STEP_HISTORY
TABLE - APPLSYS.AD_MERGED_TABLES
TABLE - APPLSYS.AD_OBSOLETE_OBJECTS
TABLE - APPLSYS.AD_PARALLEL_COMPILE
TABLE - APPLSYS.AD_PARALLEL_COMPILE_ERRORS
TABLE - APPLSYS.AD_PARALLEL_UPDATES
TABLE - APPLSYS.AD_PARALLEL_UPDATE_UNITS
TABLE - APPLSYS.AD_PARALLEL_WORKERS
TABLE - APPLSYS.AD_PATCH_COMMON_ACTIONS
TABLE - APPLSYS.AD_PATCH_COND_HISTORY
TABLE - APPLSYS.AD_PATCH_DRIVERS
TABLE - APPLSYS.AD_PATCH_DRIVER_LANGS
TABLE - APPLSYS.AD_PATCH_DRIVER_MINIPKS
TABLE - APPLSYS.AD_PATCH_HIST_SNAPS_TEMP
TABLE - APPLSYS.AD_PATCH_HIST_TEMP
TABLE - APPLSYS.AD_PATCH_RUNS
TABLE - APPLSYS.AD_PATCH_RUN_BUGS
TABLE - APPLSYS.AD_PATCH_RUN_BUG_ACTIONS
TABLE - APPLSYS.AD_PATCH_RUN_SESS_ATTRIBS
TABLE - APPLSYS.AD_PA_ANALYSIS_RUNS
TABLE - APPLSYS.AD_PA_ANALYSIS_RUN_BUGS
TABLE - APPLSYS.AD_PA_ANAL_BUG_DEPS
TABLE - APPLSYS.AD_PA_ANAL_RUN_BUG_CODELEVELS
TABLE - APPLSYS.AD_PA_ANAL_RUN_BUG_PREREQS
TABLE - APPLSYS.AD_PA_ANAL_RUN_PREFERENCES
TABLE - APPLSYS.AD_PA_CRITERIA
TABLE - APPLSYS.AD_PA_CRITERIA_PRODUCTS
TABLE - APPLSYS.AD_PA_CRITERIA_PROD_FAMS
TABLE - APPLSYS.AD_PA_ENTITY_INFO
TABLE - APPLSYS.AD_PA_PATCH_COND_REQUIRES_INFO
TABLE - APPLSYS.AD_PA_PATCH_ENTITY_INFO
TABLE - APPLSYS.AD_PA_PATCH_REQUIRES_INFO
TABLE - APPLSYS.AD_PLANNED_RES_LOCKS
TABLE - APPLSYS.AD_PM_MASTER
TABLE - APPLSYS.AD_PM_PATCHES
TABLE - APPLSYS.AD_PM_PREFERENCES
TABLE - APPLSYS.AD_PM_PRODUCT_INFO
TABLE - APPLSYS.AD_PM_PROD_FAMILY_MAP
TABLE - APPLSYS.AD_PREPMODE_CHECK_FILES
TABLE - APPLSYS.AD_PROGRAM_RUN_TASKS
TABLE - APPLSYS.AD_PROGRAM_RUN_TASK_JOBS
TABLE - APPLSYS.AD_RELEASES
TABLE - APPLSYS.AD_SEED_DATA_LOADED
TABLE - APPLSYS.AD_SESSIONS
TABLE - APPLSYS.AD_SESSIONS_HISTORY
TABLE - APPLSYS.AD_SESSION_ATTRIBUTES
TABLE - APPLSYS.AD_SESSION_TASKS
TABLE - APPLSYS.AD_SESSION_TASKS_HISTORY
TABLE - APPLSYS.AD_SNAPSHOTS
TABLE - APPLSYS.AD_SNAPSHOT_BUGFIXES
TABLE - APPLSYS.AD_SNAPSHOT_BUGFIXES_TEMP
TABLE - APPLSYS.AD_SNAPSHOT_FILES
TABLE - APPLSYS.AD_SNAPSHOT_FILES_TEMP
TABLE - APPLSYS.AD_SUPPORTED_LANGUAGES
TABLE - APPLSYS.AD_SUPPORTED_PLATFORMS
TABLE - APPLSYS.AD_TASK_STATUS
TABLE - APPLSYS.AD_TASK_TIMING
TABLE - APPLSYS.AD_TE_LEVEL_HISTORY
TABLE - APPLSYS.AD_TIMESTAMPS
TABLE - APPLSYS.AD_TRACKABLE_ENTITIES
TABLE - APPLSYS.AD_UMS_ENGINE_RESULTS
TABLE - APPLSYS.AD_UMS_LDT_LOADS
TABLE - APPLSYS.AD_UPDATE_PREFERENCES
TABLE - APPLSYS.AD_UPDATE_PREF_VALUES
TABLE - APPLSYS.AD_UPDATE_WORK_PARAMS
TABLE - APPLSYS.AD_WORKING_RES_LOCKS
TABLE - APPLSYS.FND_MODULE_INSTALLATIONS
TABLE - APPLSYS.FND_PRODUCT_DEPENDENCIES
TABLE - APPLSYS.FND_PRODUCT_GROUPS
TABLE - APPLSYS.FND_PRODUCT_INSTALLATIONS

Table: AD_APPLIED_PATCHES

Description: Oracle Applications patches
Primary Key: AD_APPLIED_PATCHES_PK
  1. APPLIED_PATCH_ID

[top of page]

APPLSYS.AD_APPLIED_PATCHES does not reference any database object

APPLSYS.AD_APPLIED_PATCHES is referenced by following:

APPLSYS
VIEW - AD_APPLIED_PATCHES#

[top of page]

Table: AD_APPL_TOPS

Description: APPL_TOP names
Primary Key: AD_APPL_TOPS_PK
  1. APPL_TOP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_PATCH_RUNS.APPL_TOP_ID AD_APPL_TOPS
AD_SNAPSHOTS.APPL_TOP_ID AD_APPL_TOPS

[top of page]

APPLSYS.AD_APPL_TOPS does not reference any database object

APPLSYS.AD_APPL_TOPS is referenced by following:

APPLSYS
VIEW - AD_APPL_TOPS#

[top of page]

Table: AD_APPS_DEPENDENCIES

Description: dependencies in fresh install APPS schema

[top of page]

APPLSYS.AD_APPS_DEPENDENCIES does not reference any database object

APPLSYS.AD_APPS_DEPENDENCIES is referenced by following:

APPLSYS
VIEW - AD_APPS_DEPENDENCIES#

[top of page]

Table: AD_BUGS

Description: Oracle Applications bugs fixed
Primary Key: AD_BUGS_PK
  1. BUG_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_COMPRISING_PATCHES.BUG_ID AD_BUGS
AD_PATCH_RUN_BUGS.BUG_ID AD_BUGS
AD_SNAPSHOT_BUGFIXES.BUGFIX_ID AD_BUGS

[top of page]

APPLSYS.AD_BUGS does not reference any database object

APPLSYS.AD_BUGS is referenced by following:

APPLSYS
VIEW - AD_BUGS#

[top of page]

Table: AD_CHECK_FILES

Description: Checkfile-repository: Highest versions of sql/exec files ever executed
Primary Key: AD_CHECK_FILES_PK
  1. CHECK_FILE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_CHECK_FILES.FILE_ID AD_FILES
AD_CHECK_FILES.FILE_VERSION_ID AD_FILE_VERSIONS

[top of page]

APPLSYS.AD_CHECK_FILES does not reference any database object

APPLSYS.AD_CHECK_FILES is referenced by following:

APPLSYS
VIEW - AD_CHECK_FILES#

[top of page]

Table: AD_CHECK_FILE_TEMP

Description: Interface table for loading the files, file versions, and/or checkfile repositories

[top of page]

APPLSYS.AD_CHECK_FILE_TEMP does not reference any database object

APPLSYS.AD_CHECK_FILE_TEMP is referenced by following:

APPLSYS
VIEW - AD_CHECK_FILE_TEMP#

[top of page]

Table: AD_COMPRISING_PATCHES

Description: Comprising patches in a "merged" patch
Primary Key: AD_COMPRISING_PATCHES_PK
  1. COMPRISING_PATCH_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_COMPRISING_PATCHES.PATCH_DRIVER_ID AD_PATCH_DRIVERS
AD_COMPRISING_PATCHES.BUG_ID AD_BUGS

[top of page]

APPLSYS.AD_COMPRISING_PATCHES does not reference any database object

APPLSYS.AD_COMPRISING_PATCHES is referenced by following:

APPLSYS
VIEW - AD_COMPRISING_PATCHES#

[top of page]

Table: AD_EVENTS

Description: To store the events

[top of page]

APPLSYS.AD_EVENTS does not reference any database object

APPLSYS.AD_EVENTS is referenced by following:

APPLSYS
VIEW - AD_EVENTS#

[top of page]

Table: AD_EVENT_TRANSITIONS

Description: Contains the history information on various state changes that an event undergoes in its life cycle

[top of page]

APPLSYS.AD_EVENT_TRANSITIONS does not reference any database object

APPLSYS.AD_EVENT_TRANSITIONS is referenced by following:

APPLSYS
VIEW - AD_EVENT_TRANSITIONS#

[top of page]

Table: AD_EVENT_VERSIONS

Description: To store event versions

[top of page]

APPLSYS.AD_EVENT_VERSIONS does not reference any database object

APPLSYS.AD_EVENT_VERSIONS is referenced by following:

APPLSYS
VIEW - AD_EVENT_VERSIONS#

[top of page]

Table: AD_FEATURE_VERSIONS

Description: Current datamodel version and status of various AD features

[top of page]

APPLSYS.AD_FEATURE_VERSIONS does not reference any database object

APPLSYS.AD_FEATURE_VERSIONS is referenced by following:

APPLSYS
VIEW - AD_FEATURE_VERSIONS#

[top of page]

Table: AD_FILES

Description: Files repository: Oracle Applications files
Primary Key: AD_FILES_PK
  1. FILE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_CHECK_FILES.FILE_ID AD_FILES
AD_FILE_VERSIONS.FILE_ID AD_FILES
AD_PATCH_COMMON_ACTIONS.LOADER_DATA_FILE_ID AD_FILES
AD_PATCH_RUN_BUG_ACTIONS.FILE_ID AD_FILES
AD_SNAPSHOT_FILES.FILE_ID AD_FILES
AD_SNAPSHOT_FILES.CONTAINING_FILE_ID AD_FILES

[top of page]

APPLSYS.AD_FILES does not reference any database object

APPLSYS.AD_FILES is referenced by following:

APPLSYS
VIEW - AD_FILES#

[top of page]

Table: AD_FILES_SRC_DEST_TEMP

Description: A temporary table that stores the relation between a source file and its destination.

[top of page]

APPLSYS.AD_FILES_SRC_DEST_TEMP does not reference any database object

APPLSYS.AD_FILES_SRC_DEST_TEMP is referenced by following:

APPLSYS
VIEW - AD_FILES_SRC_DEST_TEMP#

[top of page]

Table: AD_FILE_VERSIONS

Description: File Versions repository: Versions of Oracle Applications files
Primary Key: AD_FILE_VERSIONS_PK
  1. FILE_VERSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_FILE_VERSIONS.FILE_ID AD_FILES
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_CHECK_FILES.FILE_VERSION_ID AD_FILE_VERSIONS
AD_PATCH_RUN_BUG_ACTIONS.PATCH_FILE_VERSION_ID AD_FILE_VERSIONS
AD_PATCH_RUN_BUG_ACTIONS.ONSITE_FILE_VERSION_ID AD_FILE_VERSIONS
AD_PATCH_RUN_BUG_ACTIONS.ONSITE_PKG_VERSION_IN_DB_ID AD_FILE_VERSIONS
AD_SNAPSHOT_FILES.FILE_VERSION_ID AD_FILE_VERSIONS

[top of page]

APPLSYS.AD_FILE_VERSIONS does not reference any database object

APPLSYS.AD_FILE_VERSIONS is referenced by following:

APPLSYS
VIEW - AD_FILE_VERSIONS#

[top of page]

Table: AD_FIXED_ISSUES

Description: This table holds information about the bugs fixed on top of a baseline
Primary Key: AD_FIXED_ISSUES_U1
  1. BUGFIX_ID

[top of page]

APPLSYS.AD_FIXED_ISSUES does not reference any database object

APPLSYS.AD_FIXED_ISSUES is referenced by following:

APPLSYS
VIEW - AD_FIXED_ISSUES#

[top of page]

Table: AD_HIDDEN_PATCHES

Description: Stores a list of patches selected by the user to not display in the Patch Advisor UI pages when displaying recommended patches.

[top of page]

APPLSYS.AD_HIDDEN_PATCHES does not reference any database object

APPLSYS.AD_HIDDEN_PATCHES is referenced by following:

APPLSYS
VIEW - AD_HIDDEN_PATCHES#

[top of page]

Table: AD_INSTALL_PROCESSES

Description: Concurrent-sessions worker/manager communications area

[top of page]

APPLSYS.AD_INSTALL_PROCESSES does not reference any database object

APPLSYS.AD_INSTALL_PROCESSES is referenced by following:

APPLSYS
VIEW - AD_INSTALL_PROCESSES#

[top of page]

Table: AD_INVOKER_TASKS

Description: Used for Invoker Rights processing

[top of page]

APPLSYS.AD_INVOKER_TASKS does not reference any database object

APPLSYS.AD_INVOKER_TASKS is referenced by following:

APPLSYS
VIEW - AD_INVOKER_TASKS#
SYSTEM
SYNONYM - AD_INVOKER_TASKS

[top of page]

Table: AD_JOBS_DEFERRED

Description: Hold jobs which failed during a patching session and are being deferred until the end of the phase to run again

[top of page]

APPLSYS.AD_JOBS_DEFERRED does not reference any database object

APPLSYS.AD_JOBS_DEFERRED is referenced by following:

APPLSYS
VIEW - AD_JOBS_DEFERRED#

[top of page]

Table: AD_LONG_COLUMN_CONVERSIONS

Description: Table to store the registation details of tables and columns to be migrated and table level processing status

[top of page]

APPLSYS.AD_LONG_COLUMN_CONVERSIONS does not reference any database object

APPLSYS.AD_LONG_COLUMN_CONVERSIONS is referenced by following:

APPLSYS
VIEW - AD_LONG_COLUMN_CONVERSIONS#

[top of page]

Table: AD_MANUAL_STEP_HISTORY

Description: Stores history of manual steps applied to this instance. For each manual step applied into a customer instance, there will be one entry which is stored in this table
Primary Key: AD_MANUAL_STEP_HISTORY_PK
  1. HISTORY_ID

[top of page]

APPLSYS.AD_MANUAL_STEP_HISTORY does not reference any database object

APPLSYS.AD_MANUAL_STEP_HISTORY is referenced by following:

APPLSYS
VIEW - AD_MANUAL_STEP_HISTORY#

[top of page]

Table: AD_MERGED_TABLES

Description: Tables which have been DataMerged
Primary Key: AD_MERGED_TABLES_PK
  1. APPLICATION_ID
  2. TABLE_NAME
  3. ORACLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_MERGED_TABLES.APPLICATION_ID FND_APPLICATION
AD_MERGED_TABLES.ORACLE_ID FND_ORACLE_USERID

[top of page]

APPLSYS.AD_MERGED_TABLES does not reference any database object

APPLSYS.AD_MERGED_TABLES is referenced by following:

APPLSYS
VIEW - AD_MERGED_TABLES#

[top of page]

Table: AD_OBSOLETE_OBJECTS

Description: This table stores plsql objects to be dropped as part of the R12 upgrade

[top of page]

APPLSYS.AD_OBSOLETE_OBJECTS does not reference any database object

APPLSYS.AD_OBSOLETE_OBJECTS is referenced by following:

APPLSYS
VIEW - AD_OBSOLETE_OBJECTS#

[top of page]

Table: AD_PARALLEL_COMPILE

Description: List of invalid objects to compile in a schema

[top of page]

APPLSYS.AD_PARALLEL_COMPILE does not reference any database object

APPLSYS.AD_PARALLEL_COMPILE is referenced by following:

APPLSYS
VIEW - AD_PARALLEL_COMPILE#
SYSTEM
SYNONYM - AD_PARALLEL_COMPILE

[top of page]

Table: AD_PARALLEL_COMPILE_ERRORS

Description: Used to list non-fatal errors from parallel compile

[top of page]

APPLSYS.AD_PARALLEL_COMPILE_ERRORS does not reference any database object

APPLSYS.AD_PARALLEL_COMPILE_ERRORS is referenced by following:

APPLSYS
VIEW - AD_PARALLEL_COMPILE_ERRORS#
SYSTEM
SYNONYM - AD_PARALLEL_COMPILE_ERRORS

[top of page]

Table: AD_PARALLEL_UPDATES

Description: Used by the Large Table Updates framework

[top of page]

APPLSYS.AD_PARALLEL_UPDATES does not reference any database object

APPLSYS.AD_PARALLEL_UPDATES is referenced by following:

APPLSYS
VIEW - AD_PARALLEL_UPDATES#

[top of page]

Table: AD_PARALLEL_UPDATE_UNITS

Description: Used by the Large Table Updates framework

[top of page]

APPLSYS.AD_PARALLEL_UPDATE_UNITS does not reference any database object

APPLSYS.AD_PARALLEL_UPDATE_UNITS is referenced by following:

APPLSYS
VIEW - AD_PARALLEL_UPDATE_UNITS#

[top of page]

Table: AD_PARALLEL_WORKERS

Description: Used by the Large Table Updates framework

[top of page]

APPLSYS.AD_PARALLEL_WORKERS does not reference any database object

APPLSYS.AD_PARALLEL_WORKERS is referenced by following:

APPLSYS
VIEW - AD_PARALLEL_WORKERS#

[top of page]

Table: AD_PATCH_COMMON_ACTIONS

Description: Common Actions performed by Autopatch
Primary Key: AD_PATCH_COMMON_ACTIONS_PK
  1. COMMON_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_COMMON_ACTIONS.LOADER_DATA_FILE_ID AD_FILES
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_PATCH_RUN_BUG_ACTIONS.COMMON_ACTION_ID AD_PATCH_COMMON_ACTIONS

[top of page]

APPLSYS.AD_PATCH_COMMON_ACTIONS does not reference any database object

APPLSYS.AD_PATCH_COMMON_ACTIONS is referenced by following:

APPLSYS
VIEW - AD_PATCH_COMMON_ACTIONS#

[top of page]

Table: AD_PATCH_COND_HISTORY

Description:

[top of page]

APPLSYS.AD_PATCH_COND_HISTORY does not reference any database object

APPLSYS.AD_PATCH_COND_HISTORY is referenced by following:

APPLSYS
VIEW - AD_PATCH_COND_HISTORY#

[top of page]

Table: AD_PATCH_DRIVERS

Description: Patch drivers in a patch
Primary Key: AD_PATCH_DRIVERS_PK
  1. PATCH_DRIVER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_DRIVERS.APPLIED_PATCH_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_COMPRISING_PATCHES.PATCH_DRIVER_ID AD_PATCH_DRIVERS
AD_PATCH_DRIVER_LANGS.PATCH_DRIVER_ID AD_PATCH_DRIVERS
AD_PATCH_DRIVER_MINIPKS.PATCH_DRIVER_ID AD_PATCH_DRIVERS
AD_PATCH_RUNS.PATCH_DRIVER_ID AD_PATCH_DRIVERS

[top of page]

APPLSYS.AD_PATCH_DRIVERS does not reference any database object

APPLSYS.AD_PATCH_DRIVERS is referenced by following:

APPLSYS
VIEW - AD_PATCH_DRIVERS#

[top of page]

Table: AD_PATCH_DRIVER_LANGS

Description: Languages to which the patch driver pertains
Primary Key: AD_PATCH_DRIVER_LANGS_PK
  1. LANG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_DRIVER_LANGS.PATCH_DRIVER_ID AD_PATCH_DRIVERS

[top of page]

APPLSYS.AD_PATCH_DRIVER_LANGS does not reference any database object

APPLSYS.AD_PATCH_DRIVER_LANGS is referenced by following:

APPLSYS
VIEW - AD_PATCH_DRIVER_LANGS#

[top of page]

Table: AD_PATCH_DRIVER_MINIPKS

Description: Mini Packs contained in a patch (driver)
Primary Key: AD_PATCH_DRIVER_MINIPKS_PK
  1. MINIPK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_DRIVER_MINIPKS.PATCH_DRIVER_ID AD_PATCH_DRIVERS

[top of page]

APPLSYS.AD_PATCH_DRIVER_MINIPKS does not reference any database object

APPLSYS.AD_PATCH_DRIVER_MINIPKS is referenced by following:

APPLSYS
VIEW - AD_PATCH_DRIVER_MINIPKS#

[top of page]

Table: AD_PATCH_HIST_SNAPS_TEMP

Description: Temporary staging table for updating snapshots

[top of page]

APPLSYS.AD_PATCH_HIST_SNAPS_TEMP does not reference any database object

APPLSYS.AD_PATCH_HIST_SNAPS_TEMP is referenced by following:

APPLSYS
VIEW - AD_PATCH_HIST_SNAPS_TEMP#

[top of page]

Table: AD_PATCH_HIST_TEMP

Description: Temporary staging table for recording patch-history

[top of page]

APPLSYS.AD_PATCH_HIST_TEMP does not reference any database object

APPLSYS.AD_PATCH_HIST_TEMP is referenced by following:

APPLSYS
VIEW - AD_PATCH_HIST_TEMP#

[top of page]

Table: AD_PATCH_RUNS

Description: High level Autopatch history, one row per driver applied
Primary Key: AD_PATCH_RUNS_PK
  1. PATCH_RUN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_RUNS.RELEASE_ID AD_RELEASES
AD_PATCH_RUNS.UPDATED_TO_RELEASE_ID AD_RELEASES
AD_PATCH_RUNS.APPL_TOP_ID AD_APPL_TOPS
AD_PATCH_RUNS.PATCH_DRIVER_ID AD_PATCH_DRIVERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_PATCH_RUN_BUGS.PATCH_RUN_ID AD_PATCH_RUNS

[top of page]

APPLSYS.AD_PATCH_RUNS does not reference any database object

APPLSYS.AD_PATCH_RUNS is referenced by following:

APPLSYS
VIEW - AD_PATCH_RUNS#

[top of page]

Table: AD_PATCH_RUN_BUGS

Description: Bugs fixed in a specific run of Autopatch
Primary Key: AD_PATCH_RUN_BUGS_PK
  1. PATCH_RUN_BUG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_RUN_BUGS.PATCH_RUN_ID AD_PATCH_RUNS
AD_PATCH_RUN_BUGS.BUG_ID AD_BUGS
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_PATCH_RUN_BUG_ACTIONS.PATCH_RUN_BUG_ID AD_PATCH_RUN_BUGS

[top of page]

APPLSYS.AD_PATCH_RUN_BUGS does not reference any database object

APPLSYS.AD_PATCH_RUN_BUGS is referenced by following:

APPLSYS
VIEW - AD_PATCH_RUN_BUGS#

[top of page]

Table: AD_PATCH_RUN_BUG_ACTIONS

Description: Actions included in a bug (fix)
Primary Key: AD_PATCH_RUN_BUG_ACTIONS_PK
  1. ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_PATCH_RUN_BUG_ACTIONS.PATCH_RUN_BUG_ID AD_PATCH_RUN_BUGS
AD_PATCH_RUN_BUG_ACTIONS.COMMON_ACTION_ID AD_PATCH_COMMON_ACTIONS
AD_PATCH_RUN_BUG_ACTIONS.FILE_ID AD_FILES
AD_PATCH_RUN_BUG_ACTIONS.PATCH_FILE_VERSION_ID AD_FILE_VERSIONS
AD_PATCH_RUN_BUG_ACTIONS.ONSITE_FILE_VERSION_ID AD_FILE_VERSIONS
AD_PATCH_RUN_BUG_ACTIONS.ONSITE_PKG_VERSION_IN_DB_ID AD_FILE_VERSIONS

[top of page]

APPLSYS.AD_PATCH_RUN_BUG_ACTIONS does not reference any database object

APPLSYS.AD_PATCH_RUN_BUG_ACTIONS is referenced by following:

APPLSYS
VIEW - AD_PATCH_RUN_BUG_ACTIONS#

[top of page]

Table: AD_PATCH_RUN_SESS_ATTRIBS

Description: This table stores values of different attributes, for different runs of ad utilities.

[top of page]

APPLSYS.AD_PATCH_RUN_SESS_ATTRIBS does not reference any database object

APPLSYS.AD_PATCH_RUN_SESS_ATTRIBS is referenced by following:

APPLSYS
VIEW - AD_PATCH_RUN_SESS_ATTRIBS#

[top of page]

Table: AD_PA_ANALYSIS_RUNS

Description: Stores the history of Requirement Set Analyis Runs

[top of page]

APPLSYS.AD_PA_ANALYSIS_RUNS does not reference any database object

APPLSYS.AD_PA_ANALYSIS_RUNS is referenced by following:

APPLSYS
VIEW - AD_PA_ANALYSIS_RUNS#

[top of page]

Table: AD_PA_ANALYSIS_RUN_BUGS

Description: List of bugs resulting from criteria analysis run

[top of page]

APPLSYS.AD_PA_ANALYSIS_RUN_BUGS does not reference any database object

APPLSYS.AD_PA_ANALYSIS_RUN_BUGS is referenced by following:

APPLSYS
VIEW - AD_PA_ANALYSIS_RUN_BUGS#

[top of page]

Table: AD_PA_ANAL_BUG_DEPS

Description: Stores the dependencies for bugs resulting from Criteria Analysis run

[top of page]

APPLSYS.AD_PA_ANAL_BUG_DEPS does not reference any database object

APPLSYS.AD_PA_ANAL_BUG_DEPS is referenced by following:

APPLSYS
VIEW - AD_PA_ANAL_BUG_DEPS#

[top of page]

Table: AD_PA_ANAL_RUN_BUG_CODELEVELS

Description: Detailed table for new Codelevels introduced by recommended patchsets or latest Codelevel patches for a particular run
Primary Key: AD_PA_ANAL_RUN_BUG_CODELEVELS_
  1. ANALYSIS_RUN_BUG_ID
  2. INTR_TE_ABBR

[top of page]

APPLSYS.AD_PA_ANAL_RUN_BUG_CODELEVELS does not reference any database object

APPLSYS.AD_PA_ANAL_RUN_BUG_CODELEVELS is referenced by following:

APPLSYS
VIEW - AD_PA_ANAL_RUN_BUG_CODELEVELS#

[top of page]

Table: AD_PA_ANAL_RUN_BUG_PREREQS

Description: Detailed table for pre-requisite Codelevels for a particular patch by recommended patchsets or latest Codelevel patches for a particular run
Primary Key: AD_PA_ANAL_RUN_BUG_PREREQS_PK
  1. ANALYSIS_RUN_BUG_ID
  2. PREREQ_TE_ABBR

[top of page]

APPLSYS.AD_PA_ANAL_RUN_BUG_PREREQS does not reference any database object

APPLSYS.AD_PA_ANAL_RUN_BUG_PREREQS is referenced by following:

APPLSYS
VIEW - AD_PA_ANAL_RUN_BUG_PREREQS#

[top of page]

Table: AD_PA_ANAL_RUN_PREFERENCES

Description: Stores the user preferences for download options, platforms and languages for a particular request..

[top of page]

APPLSYS.AD_PA_ANAL_RUN_PREFERENCES does not reference any database object

APPLSYS.AD_PA_ANAL_RUN_PREFERENCES is referenced by following:

APPLSYS
VIEW - AD_PA_ANAL_RUN_PREFERENCES#

[top of page]

Table: AD_PA_CRITERIA

Description: Stores the requirement set from the Maintain Requirement Set page

[top of page]

APPLSYS.AD_PA_CRITERIA does not reference any database object

APPLSYS.AD_PA_CRITERIA is referenced by following:

APPLSYS
VIEW - AD_PA_CRITERIA#

[top of page]

Table: AD_PA_CRITERIA_PRODUCTS

Description: Seeded values for criteria creation

[top of page]

APPLSYS.AD_PA_CRITERIA_PRODUCTS does not reference any database object

APPLSYS.AD_PA_CRITERIA_PRODUCTS is referenced by following:

APPLSYS
VIEW - AD_PA_CRITERIA_PRODUCTS#

[top of page]

Table: AD_PA_CRITERIA_PROD_FAMS

Description: Stores criteria for Patch Advisor used when determining what types of patches should be applied for given products

[top of page]

APPLSYS.AD_PA_CRITERIA_PROD_FAMS does not reference any database object

APPLSYS.AD_PA_CRITERIA_PROD_FAMS is referenced by following:

APPLSYS
VIEW - AD_PA_CRITERIA_PROD_FAMS#

[top of page]

Table: AD_PA_ENTITY_INFO

Description: Master table to store the entity information of all the entities in Patch Wizard
Primary Key: AD_PA_ENTITY_INFO_PK
  1. TE_ABBR

[top of page]

APPLSYS.AD_PA_ENTITY_INFO does not reference any database object

APPLSYS.AD_PA_ENTITY_INFO is referenced by following:

APPLSYS
VIEW - AD_PA_ENTITY_INFO#

[top of page]

Table: AD_PA_PATCH_COND_REQUIRES_INFO

Description: Detailed table to store the conditional pre-requisite codelevel information of a patch from patch_metadata.xml
Primary Key: AD_PA_PATCH_COND_REQS_INFO_PK
  1. PATCH_COND_REQUIRES_ID

[top of page]

APPLSYS.AD_PA_PATCH_COND_REQUIRES_INFO does not reference any database object

APPLSYS.AD_PA_PATCH_COND_REQUIRES_INFO is referenced by following:

APPLSYS
VIEW - AD_PA_PATCH_COND_REQUIRES_INF#

[top of page]

Table: AD_PA_PATCH_ENTITY_INFO

Description: Master table to store the entity information of all the entities in Patch Wizard
Primary Key: AD_PA_PATCH_ENTITY_INFO_PK
  1. PATCH_ENTITY_ID

[top of page]

APPLSYS.AD_PA_PATCH_ENTITY_INFO does not reference any database object

APPLSYS.AD_PA_PATCH_ENTITY_INFO is referenced by following:

APPLSYS
VIEW - AD_PA_PATCH_ENTITY_INFO#

[top of page]

Table: AD_PA_PATCH_REQUIRES_INFO

Description: Detailed table to store the pre-requisite codelevel information of a patch from patch_metadata.xml
Primary Key: AD_PA_PATCH_REQUIRES_INFO_PK
  1. PATCH_REQUIRES_ID

[top of page]

APPLSYS.AD_PA_PATCH_REQUIRES_INFO does not reference any database object

APPLSYS.AD_PA_PATCH_REQUIRES_INFO is referenced by following:

APPLSYS
VIEW - AD_PA_PATCH_REQUIRES_INFO#

[top of page]

Table: AD_PLANNED_RES_LOCKS

Description: Stores locks to be required by an AD Utility

[top of page]

APPLSYS.AD_PLANNED_RES_LOCKS does not reference any database object

APPLSYS.AD_PLANNED_RES_LOCKS is referenced by following:

APPLSYS
VIEW - AD_PLANNED_RES_LOCKS#

[top of page]

Table: AD_PM_MASTER

Description: Master table for the Patch Metadata repository

[top of page]

APPLSYS.AD_PM_MASTER does not reference any database object

APPLSYS.AD_PM_MASTER is referenced by following:

APPLSYS
VIEW - AD_PM_MASTER#

[top of page]

Table: AD_PM_PATCHES

Description: Lists all patches whose MetaData has been uploaded by Patch Advisor

[top of page]

APPLSYS.AD_PM_PATCHES does not reference any database object

APPLSYS.AD_PM_PATCHES is referenced by following:

APPLSYS
VIEW - AD_PM_PATCHES#

[top of page]

Table: AD_PM_PREFERENCES

Description: Stores the default user preferences for download/merge options, platforms and languages.

[top of page]

APPLSYS.AD_PM_PREFERENCES does not reference any database object

APPLSYS.AD_PM_PREFERENCES is referenced by following:

APPLSYS
VIEW - AD_PM_PREFERENCES#

[top of page]

Table: AD_PM_PRODUCT_INFO

Description: Contains information about Oracle Applications products and pseudo-products

[top of page]

APPLSYS.AD_PM_PRODUCT_INFO does not reference any database object

APPLSYS.AD_PM_PRODUCT_INFO is referenced by following:

APPLSYS
VIEW - AD_PM_PRODUCT_INFO#

[top of page]

Table: AD_PM_PROD_FAMILY_MAP

Description: Contains information about Oracle Applications products and pseudo-products and their mapping to a product family

[top of page]

APPLSYS.AD_PM_PROD_FAMILY_MAP does not reference any database object

APPLSYS.AD_PM_PROD_FAMILY_MAP is referenced by following:

APPLSYS
VIEW - AD_PM_PROD_FAMILY_MAP#

[top of page]

Table: AD_PREPMODE_CHECK_FILES

Description: A "check-file" repository used in clone schema approach

[top of page]

APPLSYS.AD_PREPMODE_CHECK_FILES does not reference any database object

APPLSYS.AD_PREPMODE_CHECK_FILES is referenced by following:

APPLSYS
VIEW - AD_PREPMODE_CHECK_FILES#

[top of page]

Table: AD_PROGRAM_RUN_TASKS

Description: This table stores the information of the various tasks executed during a particular run of ad utility.

[top of page]

APPLSYS.AD_PROGRAM_RUN_TASKS does not reference any database object

APPLSYS.AD_PROGRAM_RUN_TASKS is referenced by following:

APPLSYS
VIEW - AD_PROGRAM_RUN_TASKS#

[top of page]

Table: AD_PROGRAM_RUN_TASK_JOBS

Description: History of timing information of jobs run in parallel

[top of page]

APPLSYS.AD_PROGRAM_RUN_TASK_JOBS does not reference any database object

APPLSYS.AD_PROGRAM_RUN_TASK_JOBS is referenced by following:

APPLSYS
VIEW - AD_PROGRAM_RUN_TASK_JOBS#

[top of page]

Table: AD_RELEASES

Description: Oracle Applications releases
Primary Key: AD_RELEASES_PK
  1. RELEASE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_PATCH_RUNS.RELEASE_ID AD_RELEASES
AD_PATCH_RUNS.UPDATED_TO_RELEASE_ID AD_RELEASES
AD_SNAPSHOTS.RELEASE_ID AD_RELEASES

[top of page]

APPLSYS.AD_RELEASES does not reference any database object

APPLSYS.AD_RELEASES is referenced by following:

APPLSYS
VIEW - AD_RELEASES#

[top of page]

Table: AD_SEED_DATA_LOADED

Description: Languages in a patch for which seed data loading has completed

[top of page]

APPLSYS.AD_SEED_DATA_LOADED does not reference any database object

APPLSYS.AD_SEED_DATA_LOADED is referenced by following:

APPLSYS
VIEW - AD_SEED_DATA_LOADED#

[top of page]

Table: AD_SESSIONS

Description: Stores information on all AD sessions for an Applications System

[top of page]

APPLSYS.AD_SESSIONS does not reference any database object

APPLSYS.AD_SESSIONS is referenced by following:

APPLSYS
VIEW - AD_SESSIONS#

[top of page]

Table: AD_SESSIONS_HISTORY

Description: Stores information on all AD sessions for an Applications System

[top of page]

APPLSYS.AD_SESSIONS_HISTORY does not reference any database object

APPLSYS.AD_SESSIONS_HISTORY is referenced by following:

APPLSYS
VIEW - AD_SESSIONS_HISTORY#

[top of page]

Table: AD_SESSION_ATTRIBUTES

Description: This table stores various attributes for a particular session of ad utility.

[top of page]

APPLSYS.AD_SESSION_ATTRIBUTES does not reference any database object

APPLSYS.AD_SESSION_ATTRIBUTES is referenced by following:

APPLSYS
VIEW - AD_SESSION_ATTRIBUTES#

[top of page]

Table: AD_SESSION_TASKS

Description: Stores the tasks for each concurrent AD utility session

[top of page]

APPLSYS.AD_SESSION_TASKS does not reference any database object

APPLSYS.AD_SESSION_TASKS is referenced by following:

APPLSYS
VIEW - AD_SESSION_TASKS#

[top of page]

Table: AD_SESSION_TASKS_HISTORY

Description: Stores the tasks for each concurrent AD utility session

[top of page]

APPLSYS.AD_SESSION_TASKS_HISTORY does not reference any database object

APPLSYS.AD_SESSION_TASKS_HISTORY is referenced by following:

APPLSYS
VIEW - AD_SESSION_TASKS_HISTORY#

[top of page]

Table: AD_SNAPSHOTS

Description: File-system snapshots
Primary Key: AD_SNAPSHOTS_PK
  1. SNAPSHOT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_SNAPSHOTS.APPL_TOP_ID AD_APPL_TOPS
AD_SNAPSHOTS.RELEASE_ID AD_RELEASES
Foreign Keys to this table:
Foreign Key Column Foreign Table
AD_SNAPSHOT_BUGFIXES.SNAPSHOT_ID AD_SNAPSHOTS
AD_SNAPSHOT_FILES.SNAPSHOT_ID AD_SNAPSHOTS

[top of page]

APPLSYS.AD_SNAPSHOTS does not reference any database object

APPLSYS.AD_SNAPSHOTS is referenced by following:

APPLSYS
VIEW - AD_SNAPSHOTS#

[top of page]

Table: AD_SNAPSHOT_BUGFIXES

Description: Bug-fixes applied when the snapshot was taken
Primary Key: AD_SNAPSHOT_BUGFIXES_PK
  1. SNAPSHOT_BUG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_SNAPSHOT_BUGFIXES.SNAPSHOT_ID AD_SNAPSHOTS
AD_SNAPSHOT_BUGFIXES.BUGFIX_ID AD_BUGS

[top of page]

APPLSYS.AD_SNAPSHOT_BUGFIXES does not reference any database object

APPLSYS.AD_SNAPSHOT_BUGFIXES is referenced by following:

APPLSYS
VIEW - AD_SNAPSHOT_BUGFIXES#

[top of page]

Table: AD_SNAPSHOT_BUGFIXES_TEMP

Description: Temp table to store data to be inserted into AD_SNAPSHOT_BUGFIXES

[top of page]

APPLSYS.AD_SNAPSHOT_BUGFIXES_TEMP does not reference any database object

APPLSYS.AD_SNAPSHOT_BUGFIXES_TEMP is referenced by following:

APPLSYS
VIEW - AD_SNAPSHOT_BUGFIXES_TEMP#

[top of page]

Table: AD_SNAPSHOT_FILES

Description: File-details in the snapshot
Primary Key: AD_SNAPSHOT_FILES_PK
  1. SNAPSHOT_FILE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
AD_SNAPSHOT_FILES.SNAPSHOT_ID AD_SNAPSHOTS
AD_SNAPSHOT_FILES.FILE_ID AD_FILES
AD_SNAPSHOT_FILES.CONTAINING_FILE_ID AD_FILES
AD_SNAPSHOT_FILES.FILE_VERSION_ID AD_FILE_VERSIONS

[top of page]

APPLSYS.AD_SNAPSHOT_FILES does not reference any database object

APPLSYS.AD_SNAPSHOT_FILES is referenced by following:

APPLSYS
VIEW - AD_SNAPSHOT_FILES#

[top of page]

Table: AD_SNAPSHOT_FILES_TEMP

Description: This is a temporary table used during updation of the snapshot of the Application System.

[top of page]

APPLSYS.AD_SNAPSHOT_FILES_TEMP does not reference any database object

APPLSYS.AD_SNAPSHOT_FILES_TEMP is referenced by following:

APPLSYS
VIEW - AD_SNAPSHOT_FILES_TEMP#

[top of page]

Table: AD_SUPPORTED_LANGUAGES

Description: Oracle Supported langauges for download and/or merging.

[top of page]

APPLSYS.AD_SUPPORTED_LANGUAGES does not reference any database object

APPLSYS.AD_SUPPORTED_LANGUAGES is referenced by following:

APPLSYS
VIEW - AD_SUPPORTED_LANGUAGES#

[top of page]

Table: AD_SUPPORTED_PLATFORMS

Description: Oracle Supported platforms for download and/or merging.

[top of page]

APPLSYS.AD_SUPPORTED_PLATFORMS does not reference any database object

APPLSYS.AD_SUPPORTED_PLATFORMS is referenced by following:

APPLSYS
VIEW - AD_SUPPORTED_PLATFORMS#

[top of page]

Table: AD_TASK_STATUS

Description: This table stores the information about various tasks executed during the run of ad utility.

[top of page]

APPLSYS.AD_TASK_STATUS does not reference any database object

APPLSYS.AD_TASK_STATUS is referenced by following:

APPLSYS
VIEW - AD_TASK_STATUS#

[top of page]

Table: AD_TASK_TIMING

Description: Timing information of jobs run in parallel

[top of page]

APPLSYS.AD_TASK_TIMING does not reference any database object

APPLSYS.AD_TASK_TIMING is referenced by following:

APPLSYS
VIEW - AD_TASK_TIMING#

[top of page]

Table: AD_TE_LEVEL_HISTORY

Description: Holds the history information of trackable entity codelevels. Whenever a row is updated in AD_TRACKABLE_ENTITIES, the row before updating is inserted in this table for history purposes
Primary Key: AD_TE_LEVEL_HISTORY_U1
  1. ABBREVIATION
  2. CODELEVEL

[top of page]

APPLSYS.AD_TE_LEVEL_HISTORY does not reference any database object

APPLSYS.AD_TE_LEVEL_HISTORY is referenced by following:

APPLSYS
VIEW - AD_TE_LEVEL_HISTORY#

[top of page]

Table: AD_TIMESTAMPS

Description: Holds the timestamp of when a particular operation took place

[top of page]

APPLSYS.AD_TIMESTAMPS does not reference any database object

APPLSYS.AD_TIMESTAMPS is referenced by following:

APPLSYS
VIEW - AD_TIMESTAMPS#
SYSTEM
SYNONYM - AD_TIMESTAMPS

[top of page]

Table: AD_TRACKABLE_ENTITIES

Description: Stores Oracle Applications Entities and their Code Levels
Primary Key: AD_TRACKABLE_ENTITIES_PK
  1. ABBREVIATION

[top of page]

APPLSYS.AD_TRACKABLE_ENTITIES does not reference any database object

APPLSYS.AD_TRACKABLE_ENTITIES is referenced by following:

APPLSYS
VIEW - AD_TRACKABLE_ENTITIES#

[top of page]

Table: AD_UMS_ENGINE_RESULTS

Description: Stores the results of the UMS environment analysis

[top of page]

APPLSYS.AD_UMS_ENGINE_RESULTS does not reference any database object

APPLSYS.AD_UMS_ENGINE_RESULTS is referenced by following:

APPLSYS
VIEW - AD_UMS_ENGINE_RESULTS#

[top of page]

Table: AD_UMS_LDT_LOADS

Description: Stores dataloader file names used in Patch Advisor

[top of page]

APPLSYS.AD_UMS_LDT_LOADS does not reference any database object

APPLSYS.AD_UMS_LDT_LOADS is referenced by following:

APPLSYS
VIEW - AD_UMS_LDT_LOADS#

[top of page]

Table: AD_UPDATE_PREFERENCES

Description: Not currently used - contains information on various preferences that can be set and referenced during an upgrade

[top of page]

APPLSYS.AD_UPDATE_PREFERENCES does not reference any database object

APPLSYS.AD_UPDATE_PREFERENCES is referenced by following:

APPLSYS
VIEW - AD_UPDATE_PREFERENCES#

[top of page]

Table: AD_UPDATE_PREF_VALUES

Description: Not currently used - contains values specified for a preference at various levels. A value can be specified globally that is applicable for all patch sessions or individually for a specific patch session

[top of page]

APPLSYS.AD_UPDATE_PREF_VALUES does not reference any database object

APPLSYS.AD_UPDATE_PREF_VALUES is referenced by following:

APPLSYS
VIEW - AD_UPDATE_PREF_VALUES#

[top of page]

Table: AD_UPDATE_WORK_PARAMS

Description: Not currently used - contains name-value pairs that can be set and retrieved by upgrade scripts running at various stages during a patch application

[top of page]

APPLSYS.AD_UPDATE_WORK_PARAMS does not reference any database object

APPLSYS.AD_UPDATE_WORK_PARAMS is referenced by following:

APPLSYS
VIEW - AD_UPDATE_WORK_PARAMS#

[top of page]

Table: AD_WORKING_RES_LOCKS

Description: Holds Active Locks held by AD Utilites

[top of page]

APPLSYS.AD_WORKING_RES_LOCKS does not reference any database object

APPLSYS.AD_WORKING_RES_LOCKS is referenced by following:

APPLSYS
VIEW - AD_WORKING_RES_LOCKS#

[top of page]

Table: FND_MODULE_INSTALLATIONS

Description: Oracle Application modules installed at your site
Primary Key: FND_MODULE_INSTALLATIONS_PK
  1. APPLICATION_ID
  2. ORACLE_ID
  3. MODULE_SHORT_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
FND_MODULE_INSTALLATIONS.APPLICATION_ID FND_APPLICATION
FND_MODULE_INSTALLATIONS.ORACLE_ID FND_ORACLE_USERID

[top of page]

APPLSYS.FND_MODULE_INSTALLATIONS does not reference any database object

APPLSYS.FND_MODULE_INSTALLATIONS is referenced by following:

APPLSYS
VIEW - FND_MODULE_INSTALLATIONS#

[top of page]

Table: FND_PRODUCT_DEPENDENCIES

Description: Dependencies of Oracle Applications products installed at your site
Primary Key: FND_PRODUCT_DEPENDENCIES_PK
  1. APPLICATION_ID
  2. ORACLE_ID
  3. REQUIRED_APPLICATION_ID
  4. REQUIRED_ORACLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FND_PRODUCT_DEPENDENCIES.APPLICATION_ID
FND_PRODUCT_DEPENDENCIES.ORACLE_ID 		FND_PRODUCT_INSTALLATIONS
FND_PRODUCT_DEPENDENCIES.REQUIRED_APPLICATION_ID
FND_PRODUCT_DEPENDENCIES.REQUIRED_ORACLE_ID 		FND_PRODUCT_INSTALLATIONS

[top of page]

APPLSYS.FND_PRODUCT_DEPENDENCIES does not reference any database object

APPLSYS.FND_PRODUCT_DEPENDENCIES is referenced by following:

APPLSYS
VIEW - FND_PRODUCT_DEPENDENCIES#

[top of page]

Table: FND_PRODUCT_GROUPS

Description: Site specific information used by AD utilities
Primary Key: FND_PRODUCT_GROUPS_PK
  1. PRODUCT_GROUP_ID
Primary Key: FND_PRODUCT_GROUPS_UK1
  1. PRODUCT_GROUP_NAME

[top of page]

APPLSYS.FND_PRODUCT_GROUPS does not reference any database object

APPLSYS.FND_PRODUCT_GROUPS is referenced by following:

APPLSYS
VIEW - FND_PRODUCT_GROUPS#

[top of page]

Table: FND_PRODUCT_INSTALLATIONS

Description: Oracle Applications products installed at your site
Primary Key: FND_PRODUCT_INSTALLATIONS_PK
  1. APPLICATION_ID
  2. ORACLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FND_PRODUCT_INSTALLATIONS.APPLICATION_ID FND_APPLICATION
FND_PRODUCT_INSTALLATIONS.ORACLE_ID FND_ORACLE_USERID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTION_SET_CHECKS.APPLICATION_ID
ALR_ACTION_SET_CHECKS.ORACLE_ID 		FND_PRODUCT_INSTALLATIONS
FND_PRODUCT_DEPENDENCIES.APPLICATION_ID
FND_PRODUCT_DEPENDENCIES.ORACLE_ID 		FND_PRODUCT_INSTALLATIONS
FND_PRODUCT_DEPENDENCIES.REQUIRED_APPLICATION_ID
FND_PRODUCT_DEPENDENCIES.REQUIRED_ORACLE_ID 		FND_PRODUCT_INSTALLATIONS

[top of page]

APPLSYS.FND_PRODUCT_INSTALLATIONS does not reference any database object

APPLSYS.FND_PRODUCT_INSTALLATIONS is referenced by following:

APPLSYS
VIEW - FND_PRODUCT_INSTALLATIONS#

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