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

TABLE - ALR.ALR_ACTIONS
TABLE - ALR.ALR_ACTION_DATA
TABLE - ALR.ALR_ACTION_GROUPS
TABLE - ALR.ALR_ACTION_GROUP_MEMBERS
TABLE - ALR.ALR_ACTION_HISTORY
TABLE - ALR.ALR_ACTION_OUTPUTS
TABLE - ALR.ALR_ACTION_SETS
TABLE - ALR.ALR_ACTION_SET_CHECKS
TABLE - ALR.ALR_ACTION_SET_INPUTS
TABLE - ALR.ALR_ACTION_SET_MEMBERS
TABLE - ALR.ALR_ACTION_SET_OUTPUTS
TABLE - ALR.ALR_ACTUAL_RESPONSES
TABLE - ALR.ALR_ALERTS
TABLE - ALR.ALR_ALERT_CHECKS
TABLE - ALR.ALR_ALERT_INPUTS
TABLE - ALR.ALR_ALERT_INSTALLATIONS
TABLE - ALR.ALR_ALERT_OUTPUTS
TABLE - ALR.ALR_DISTRIBUTION_LISTS
TABLE - ALR.ALR_LOOKUPS
TABLE - ALR.ALR_MESSAGE_SYSTEMS
TABLE - ALR.ALR_ORACLE_MAIL_ACCOUNTS
TABLE - ALR.ALR_OUTPUT_HISTORY
TABLE - ALR.ALR_PERIODIC_SETS
TABLE - ALR.ALR_PERIODIC_SET_MEMBERS
TABLE - ALR.ALR_PROFILE_OPTIONS
TABLE - ALR.ALR_RESPONSE_ACTIONS
TABLE - ALR.ALR_RESPONSE_ACTION_HISTORY
TABLE - ALR.ALR_RESPONSE_MESSAGES
TABLE - ALR.ALR_RESPONSE_SETS
TABLE - ALR.ALR_RESPONSE_VARIABLES
TABLE - ALR.ALR_RESPONSE_VARIABLE_VALUES
TABLE - ALR.ALR_VALID_RESPONSES
VIEW - APPS.ALR_ACTIONS_V
VIEW - APPS.ALR_ALERT_ACTIONS_VIEW
VIEW - APPS.ALR_ALERT_HISTORY_VIEW
VIEW - APPS.ALR_CHECK_ACTION_HISTORY_VIEW
VIEW - APPS.ALR_GROUPS_AND_ACTIONS_VIEW
VIEW - APPS.ALR_INSTALLATIONS_VIEW
VIEW - APPS.ALR_PERIODIC_ALERTS_VIEW
VIEW - APPS.ALR_RESPONSE_ACTIONS_VIEW
VIEW - APPS.ALR_SCHEDULED_PROGRAMS
VIEW - APPS.ALR_VARIABLES_AND_OUTPUTS

Table: ALR_ACTIONS

Description: Alert and response actions
Primary Key: ALR_ACTIONS_PK
  1. APPLICATION_ID
  2. ACTION_ID
  3. END_DATE_ACTIVE
Primary Key: ALR_ACTIONS_UK1
  1. APPLICATION_ID
  2. ALERT_ID
  3. NAME
  4. END_DATE_ACTIVE
Primary Key: ALR_ACTIONS_UK2
  1. APPLICATION_ID
  2. ACTION_ID
  3. VERSION_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ACTIONS.APPLICATION_ID
ALR_ACTIONS.ALERT_ID 		ALR_ALERTS
ALR_ACTIONS.LIST_APPLICATION_ID
ALR_ACTIONS.LIST_ID
ALR_ACTIONS.END_DATE_ACTIVE 		ALR_DISTRIBUTION_LISTS
ALR_ACTIONS.PROGRAM_APPLICATION_ID
ALR_ACTIONS.CONCURRENT_PROGRAM_ID 		FND_CONCURRENT_PROGRAMS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTION_GROUP_MEMBERS.APPLICATION_ID
ALR_ACTION_GROUP_MEMBERS.ACTION_ID
ALR_ACTION_GROUP_MEMBERS.END_DATE_ACTIVE 		ALR_ACTIONS
ALR_ACTION_OUTPUTS.APPLICATION_ID
ALR_ACTION_OUTPUTS.ACTION_ID
ALR_ACTION_OUTPUTS.END_DATE_ACTIVE 		ALR_ACTIONS
ALR_ACTION_SET_MEMBERS.APPLICATION_ID
ALR_ACTION_SET_MEMBERS.ACTION_ID
ALR_ACTION_SET_MEMBERS.END_DATE_ACTIVE 		ALR_ACTIONS
ALR_RESPONSE_ACTIONS.APPLICATION_ID
ALR_RESPONSE_ACTIONS.ACTION_ID
ALR_RESPONSE_ACTIONS.END_DATE_ACTIVE 		ALR_ACTIONS

[top of page]

ALR.ALR_ACTIONS does not reference any database object

ALR.ALR_ACTIONS is referenced by following:

APPS
SYNONYM - ALR_ACTIONS

[top of page]

Table: ALR_ACTION_DATA

Description: Exceptions found during an action set check
Primary Key: ALR_ACTION_DATA_PK
  1. APPLICATION_ID
  2. ACTION_HISTORY_ID
  3. ROW_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ACTION_DATA.APPLICATION_ID
ALR_ACTION_DATA.CHECK_ID 		ALR_ACTION_SET_CHECKS
ALR_ACTION_DATA.APPLICATION_ID
ALR_ACTION_DATA.ACTION_HISTORY_ID 		ALR_ACTION_HISTORY

[top of page]

ALR.ALR_ACTION_DATA does not reference any database object

ALR.ALR_ACTION_DATA is referenced by following:

APPS
SYNONYM - ALR_ACTION_DATA

[top of page]

Table: ALR_ACTION_GROUPS

Description: Alert action, threshold, and escalation groups
Primary Key: ALR_ACTION_GROUPS_PK
  1. APPLICATION_ID
  2. ACTION_GROUP_ID
Primary Key: ALR_ACTION_GROUPS_UK1
  1. APPLICATION_ID
  2. ALERT_ID
  3. NAME
  4. GROUP_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ACTION_GROUPS.APPLICATION_ID
ALR_ACTION_GROUPS.ALERT_ID 		ALR_ALERTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTION_GROUP_MEMBERS.APPLICATION_ID
ALR_ACTION_GROUP_MEMBERS.ACTION_GROUP_ID 		ALR_ACTION_GROUPS
ALR_ACTION_SET_MEMBERS.APPLICATION_ID
ALR_ACTION_SET_MEMBERS.ACTION_GROUP_ID 		ALR_ACTION_GROUPS

[top of page]

ALR.ALR_ACTION_GROUPS does not reference any database object

ALR.ALR_ACTION_GROUPS is referenced by following:

APPS
SYNONYM - ALR_ACTION_GROUPS

[top of page]

Table: ALR_ACTION_GROUP_MEMBERS

Description: Member actions of an alert action group
Primary Key: ALR_ACTION_GROUP_MEMBERS_PK
  1. APPLICATION_ID
  2. ACTION_GROUP_MEMBER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ACTION_GROUP_MEMBERS.APPLICATION_ID
ALR_ACTION_GROUP_MEMBERS.ACTION_GROUP_ID 		ALR_ACTION_GROUPS
ALR_ACTION_GROUP_MEMBERS.APPLICATION_ID
ALR_ACTION_GROUP_MEMBERS.ACTION_ID
ALR_ACTION_GROUP_MEMBERS.END_DATE_ACTIVE 		ALR_ACTIONS
ALR_ACTION_GROUP_MEMBERS.APPLICATION_ID
ALR_ACTION_GROUP_MEMBERS.ALERT_ID 		ALR_ALERTS

[top of page]

ALR.ALR_ACTION_GROUP_MEMBERS does not reference any database object

ALR.ALR_ACTION_GROUP_MEMBERS is referenced by following:

APPS
SYNONYM - ALR_ACTION_GROUP_MEMBERS

[top of page]

Table: ALR_ACTION_HISTORY

Description: Actual action execution history
Primary Key: ALR_ACTION_HISTORY_PK
  1. APPLICATION_ID
  2. ACTION_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ACTION_HISTORY.APPLICATION_ID
ALR_ACTION_HISTORY.ALERT_ID 		ALR_ALERTS
ALR_ACTION_HISTORY.APPLICATION_ID
ALR_ACTION_HISTORY.ACTION_SET_ID 		ALR_ACTION_SETS
ALR_ACTION_HISTORY.APPLICATION_ID
ALR_ACTION_HISTORY.ACTION_SET_MEMBER_ID 		ALR_ACTION_SET_MEMBERS
ALR_ACTION_HISTORY.APPLICATION_ID
ALR_ACTION_HISTORY.CHECK_ID 		ALR_ACTION_SET_CHECKS
ALR_ACTION_HISTORY.NODE_HANDLE
ALR_ACTION_HISTORY.MESSAGE_HANDLE 		ALR_ACTUAL_RESPONSES
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTION_DATA.APPLICATION_ID
ALR_ACTION_DATA.ACTION_HISTORY_ID 		ALR_ACTION_HISTORY

[top of page]

ALR.ALR_ACTION_HISTORY does not reference any database object

ALR.ALR_ACTION_HISTORY is referenced by following:

APPS
SYNONYM - ALR_ACTION_HISTORY

[top of page]

Table: ALR_ACTION_OUTPUTS

Description: Critical outputs used in a summary action
Primary Key: ALR_ACTION_OUTPUTS_PK
  1. APPLICATION_ID
  2. ALERT_ID
  3. ACTION_ID
  4. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ACTION_OUTPUTS.APPLICATION_ID
ALR_ACTION_OUTPUTS.ALERT_ID 		ALR_ALERTS
ALR_ACTION_OUTPUTS.APPLICATION_ID
ALR_ACTION_OUTPUTS.ACTION_ID
ALR_ACTION_OUTPUTS.END_DATE_ACTIVE 		ALR_ACTIONS

[top of page]

ALR.ALR_ACTION_OUTPUTS does not reference any database object

ALR.ALR_ACTION_OUTPUTS is referenced by following:

APPS
SYNONYM - ALR_ACTION_OUTPUTS

[top of page]

Table: ALR_ACTION_SETS

Description: Alert action sets
Primary Key: ALR_ACTION_SETS_PK
  1. APPLICATION_ID
  2. ACTION_SET_ID
Primary Key: ALR_ACTION_SETS_UK1
  1. APPLICATION_ID
  2. ALERT_ID
  3. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ACTION_SETS.APPLICATION_ID
ALR_ACTION_SETS.ALERT_ID 		ALR_ALERTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTION_HISTORY.APPLICATION_ID
ALR_ACTION_HISTORY.ACTION_SET_ID 		ALR_ACTION_SETS
ALR_ACTION_SET_CHECKS.APPLICATION_ID
ALR_ACTION_SET_CHECKS.ACTION_SET_ID 		ALR_ACTION_SETS
ALR_ACTION_SET_INPUTS.APPLICATION_ID
ALR_ACTION_SET_INPUTS.ACTION_SET_ID 		ALR_ACTION_SETS
ALR_ACTION_SET_MEMBERS.APPLICATION_ID
ALR_ACTION_SET_MEMBERS.ACTION_SET_ID 		ALR_ACTION_SETS
ALR_ACTION_SET_OUTPUTS.APPLICATION_ID
ALR_ACTION_SET_OUTPUTS.ACTION_SET_ID 		ALR_ACTION_SETS

[top of page]

ALR.ALR_ACTION_SETS does not reference any database object

ALR.ALR_ACTION_SETS is referenced by following:

APPS
SYNONYM - ALR_ACTION_SETS

[top of page]

Table: ALR_ACTION_SET_CHECKS

Description: Action set check information
Primary Key: ALR_ACTION_SET_CHECKS_PK
  1. APPLICATION_ID
  2. CHECK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ACTION_SET_CHECKS.APPLICATION_ID
ALR_ACTION_SET_CHECKS.ORACLE_ID 		FND_PRODUCT_INSTALLATIONS
ALR_ACTION_SET_CHECKS.APPLICATION_ID
ALR_ACTION_SET_CHECKS.ALERT_ID 		ALR_ALERTS
ALR_ACTION_SET_CHECKS.APPLICATION_ID
ALR_ACTION_SET_CHECKS.ACTION_SET_ID 		ALR_ACTION_SETS
ALR_ACTION_SET_CHECKS.APPLICATION_ID
ALR_ACTION_SET_CHECKS.ALERT_CHECK_ID 		ALR_ALERT_CHECKS
ALR_ACTION_SET_CHECKS.ORACLE_ID FND_ORACLE_USERID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTION_DATA.APPLICATION_ID
ALR_ACTION_DATA.CHECK_ID 		ALR_ACTION_SET_CHECKS
ALR_ACTION_HISTORY.APPLICATION_ID
ALR_ACTION_HISTORY.CHECK_ID 		ALR_ACTION_SET_CHECKS
ALR_ACTUAL_RESPONSES.APPLICATION_ID
ALR_ACTUAL_RESPONSES.ALERT_CHECK_ID 		ALR_ACTION_SET_CHECKS
ALR_OUTPUT_HISTORY.APPLICATION_ID
ALR_OUTPUT_HISTORY.CHECK_ID 		ALR_ACTION_SET_CHECKS

[top of page]

ALR.ALR_ACTION_SET_CHECKS does not reference any database object

ALR.ALR_ACTION_SET_CHECKS is referenced by following:

APPS
SYNONYM - ALR_ACTION_SET_CHECKS

[top of page]

Table: ALR_ACTION_SET_INPUTS

Description: Alert action set inputs
Primary Key: ALR_ACTION_SET_INPUTS_PK
  1. APPLICATION_ID
  2. ALERT_ID
  3. ACTION_SET_ID
  4. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ACTION_SET_INPUTS.APPLICATION_ID
ALR_ACTION_SET_INPUTS.ACTION_SET_ID 		ALR_ACTION_SETS
ALR_ACTION_SET_INPUTS.APPLICATION_ID
ALR_ACTION_SET_INPUTS.ALERT_ID 		ALR_ALERTS

[top of page]

ALR.ALR_ACTION_SET_INPUTS does not reference any database object

ALR.ALR_ACTION_SET_INPUTS is referenced by following:

APPS
SYNONYM - ALR_ACTION_SET_INPUTS

[top of page]

Table: ALR_ACTION_SET_MEMBERS

Description: Member actions and action groups of alert action sets
Primary Key: ALR_ACTION_SET_MEMBERS_PK
  1. APPLICATION_ID
  2. ACTION_SET_MEMBER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ACTION_SET_MEMBERS.APPLICATION_ID
ALR_ACTION_SET_MEMBERS.ACTION_SET_ID 		ALR_ACTION_SETS
ALR_ACTION_SET_MEMBERS.APPLICATION_ID
ALR_ACTION_SET_MEMBERS.ACTION_ID
ALR_ACTION_SET_MEMBERS.END_DATE_ACTIVE 		ALR_ACTIONS
ALR_ACTION_SET_MEMBERS.APPLICATION_ID
ALR_ACTION_SET_MEMBERS.ACTION_GROUP_ID 		ALR_ACTION_GROUPS
ALR_ACTION_SET_MEMBERS.APPLICATION_ID
ALR_ACTION_SET_MEMBERS.ALERT_ID 		ALR_ALERTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTION_HISTORY.APPLICATION_ID
ALR_ACTION_HISTORY.ACTION_SET_MEMBER_ID 		ALR_ACTION_SET_MEMBERS

[top of page]

ALR.ALR_ACTION_SET_MEMBERS does not reference any database object

ALR.ALR_ACTION_SET_MEMBERS is referenced by following:

APPS
SYNONYM - ALR_ACTION_SET_MEMBERS

[top of page]

Table: ALR_ACTION_SET_OUTPUTS

Description: Alert action set outputs
Primary Key: ALR_ACTION_SET_OUTPUTS_PK
  1. APPLICATION_ID
  2. ALERT_ID
  3. ACTION_SET_ID
  4. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ACTION_SET_OUTPUTS.APPLICATION_ID
ALR_ACTION_SET_OUTPUTS.ACTION_SET_ID 		ALR_ACTION_SETS
ALR_ACTION_SET_OUTPUTS.APPLICATION_ID
ALR_ACTION_SET_OUTPUTS.ALERT_ID 		ALR_ALERTS

[top of page]

ALR.ALR_ACTION_SET_OUTPUTS does not reference any database object

ALR.ALR_ACTION_SET_OUTPUTS is referenced by following:

APPS
SYNONYM - ALR_ACTION_SET_OUTPUTS

[top of page]

Table: ALR_ACTUAL_RESPONSES

Description: Responses expected and received for an alert message
Primary Key: ALR_ACTUAL_RESPONSES_PK
  1. NODE_HANDLE
  2. MESSAGE_HANDLE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ACTUAL_RESPONSES.APPLICATION_ID
ALR_ACTUAL_RESPONSES.ALERT_ID 		ALR_ALERTS
ALR_ACTUAL_RESPONSES.APPLICATION_ID
ALR_ACTUAL_RESPONSES.ALERT_ID
ALR_ACTUAL_RESPONSES.RESPONSE_SET_ID 		ALR_RESPONSE_SETS
ALR_ACTUAL_RESPONSES.APPLICATION_ID
ALR_ACTUAL_RESPONSES.ALERT_CHECK_ID 		ALR_ACTION_SET_CHECKS
ALR_ACTUAL_RESPONSES.APPLICATION_ID
ALR_ACTUAL_RESPONSES.ALERT_ID
ALR_ACTUAL_RESPONSES.RESPONSE_SET_ID
ALR_ACTUAL_RESPONSES.RESPONSE_ID 		ALR_VALID_RESPONSES
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTION_HISTORY.NODE_HANDLE
ALR_ACTION_HISTORY.MESSAGE_HANDLE 		ALR_ACTUAL_RESPONSES
ALR_RESPONSE_MESSAGES.NODE_HANDLE
ALR_RESPONSE_MESSAGES.MESSAGE_HANDLE 		ALR_ACTUAL_RESPONSES
ALR_RESPONSE_VARIABLE_VALUES.NODE_HANDLE
ALR_RESPONSE_VARIABLE_VALUES.MESSAGE_HANDLE 		ALR_ACTUAL_RESPONSES
ALR_RESPONSE_ACTION_HISTORY.NODE_HANDLE
ALR_RESPONSE_ACTION_HISTORY.MESSAGE_HANDLE 		ALR_ACTUAL_RESPONSES

[top of page]

ALR.ALR_ACTUAL_RESPONSES does not reference any database object

ALR.ALR_ACTUAL_RESPONSES is referenced by following:

APPS
SYNONYM - ALR_ACTUAL_RESPONSES

[top of page]

Table: ALR_ALERTS

Description: Alerts defined on application tables
Primary Key: ALR_ALERTS_PK
  1. APPLICATION_ID
  2. ALERT_ID
Primary Key: ALR_ALERTS_UK1
  1. APPLICATION_ID
  2. ALERT_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ALERTS.TABLE_APPLICATION_ID
ALR_ALERTS.TABLE_ID 		FND_TABLES
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTIONS.APPLICATION_ID
ALR_ACTIONS.ALERT_ID 		ALR_ALERTS
ALR_ACTION_GROUPS.APPLICATION_ID
ALR_ACTION_GROUPS.ALERT_ID 		ALR_ALERTS
ALR_ACTION_GROUP_MEMBERS.APPLICATION_ID
ALR_ACTION_GROUP_MEMBERS.ALERT_ID 		ALR_ALERTS
ALR_ACTION_HISTORY.APPLICATION_ID
ALR_ACTION_HISTORY.ALERT_ID 		ALR_ALERTS
ALR_ACTION_OUTPUTS.APPLICATION_ID
ALR_ACTION_OUTPUTS.ALERT_ID 		ALR_ALERTS
ALR_ACTION_SETS.APPLICATION_ID
ALR_ACTION_SETS.ALERT_ID 		ALR_ALERTS
ALR_ACTION_SET_CHECKS.APPLICATION_ID
ALR_ACTION_SET_CHECKS.ALERT_ID 		ALR_ALERTS
ALR_ACTION_SET_INPUTS.APPLICATION_ID
ALR_ACTION_SET_INPUTS.ALERT_ID 		ALR_ALERTS
ALR_ACTION_SET_MEMBERS.APPLICATION_ID
ALR_ACTION_SET_MEMBERS.ALERT_ID 		ALR_ALERTS
ALR_ACTION_SET_OUTPUTS.APPLICATION_ID
ALR_ACTION_SET_OUTPUTS.ALERT_ID 		ALR_ALERTS
ALR_ACTUAL_RESPONSES.APPLICATION_ID
ALR_ACTUAL_RESPONSES.ALERT_ID 		ALR_ALERTS
ALR_ALERT_CHECKS.APPLICATION_ID
ALR_ALERT_CHECKS.ALERT_ID 		ALR_ALERTS
ALR_ALERT_INPUTS.APPLICATION_ID
ALR_ALERT_INPUTS.ALERT_ID 		ALR_ALERTS
ALR_ALERT_INSTALLATIONS.APPLICATION_ID
ALR_ALERT_INSTALLATIONS.ALERT_ID 		ALR_ALERTS
ALR_ALERT_OUTPUTS.APPLICATION_ID
ALR_ALERT_OUTPUTS.ALERT_ID 		ALR_ALERTS
ALR_PERIODIC_SET_MEMBERS.CHILD_APPLICATION_ID
ALR_PERIODIC_SET_MEMBERS.CHILD_ALERT_ID 		ALR_ALERTS
ALR_RESPONSE_ACTIONS.APPLICATION_ID
ALR_RESPONSE_ACTIONS.ALERT_ID 		ALR_ALERTS
ALR_RESPONSE_SETS.APPLICATION_ID
ALR_RESPONSE_SETS.ALERT_ID 		ALR_ALERTS
ALR_RESPONSE_VARIABLES.APPLICATION_ID
ALR_RESPONSE_VARIABLES.ALERT_ID 		ALR_ALERTS
ALR_RESPONSE_VARIABLE_VALUES.APPLICATION_ID
ALR_RESPONSE_VARIABLE_VALUES.ALERT_ID 		ALR_ALERTS
ALR_RESPONSE_ACTION_HISTORY.APPLICATION_ID
ALR_RESPONSE_ACTION_HISTORY.ALERT_ID 		ALR_ALERTS
ALR_VALID_RESPONSES.APPLICATION_ID
ALR_VALID_RESPONSES.ALERT_ID 		ALR_ALERTS

[top of page]

ALR.ALR_ALERTS does not reference any database object

ALR.ALR_ALERTS is referenced by following:

APPS
SYNONYM - ALR_ALERTS

[top of page]

Table: ALR_ALERT_CHECKS

Description: Alert check information
Primary Key: ALR_ALERT_CHECKS_PK
  1. APPLICATION_ID
  2. ALERT_CHECK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ALERT_CHECKS.APPLICATION_ID
ALR_ALERT_CHECKS.ALERT_ID 		ALR_ALERTS
ALR_ALERT_CHECKS.REQUEST_ID FND_CONCURRENT_REQUESTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTION_SET_CHECKS.APPLICATION_ID
ALR_ACTION_SET_CHECKS.ALERT_CHECK_ID 		ALR_ALERT_CHECKS

[top of page]

ALR.ALR_ALERT_CHECKS does not reference any database object

ALR.ALR_ALERT_CHECKS is referenced by following:

APPS
SYNONYM - ALR_ALERT_CHECKS

[top of page]

Table: ALR_ALERT_INPUTS

Description: Alert inputs
Primary Key: ALR_ALERT_INPUTS_PK
  1. APPLICATION_ID
  2. ALERT_ID
  3. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ALERT_INPUTS.APPLICATION_ID
ALR_ALERT_INPUTS.ALERT_ID 		ALR_ALERTS

[top of page]

ALR.ALR_ALERT_INPUTS does not reference any database object

ALR.ALR_ALERT_INPUTS is referenced by following:

APPS
SYNONYM - ALR_ALERT_INPUTS

[top of page]

Table: ALR_ALERT_INSTALLATIONS

Description: Alert installation information
Primary Key: ALR_ALERT_INSTALLATIONS_PK
  1. APPLICATION_ID
  2. ALERT_ID
  3. ORACLE_ID
  4. DATA_GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ALERT_INSTALLATIONS.APPLICATION_ID
ALR_ALERT_INSTALLATIONS.ALERT_ID 		ALR_ALERTS
ALR_ALERT_INSTALLATIONS.ORACLE_ID FND_ORACLE_USERID
ALR_ALERT_INSTALLATIONS.DATA_GROUP_ID FND_DATA_GROUPS

[top of page]

ALR.ALR_ALERT_INSTALLATIONS does not reference any database object

ALR.ALR_ALERT_INSTALLATIONS is referenced by following:

APPS
SYNONYM - ALR_ALERT_INSTALLATIONS

[top of page]

Table: ALR_ALERT_OUTPUTS

Description: Alert outputs
Primary Key: ALR_ALERT_OUTPUTS_PK
  1. APPLICATION_ID
  2. ALERT_ID
  3. NAME
Primary Key: ALR_ALERT_OUTPUTS_UK1
  1. APPLICATION_ID
  2. ALERT_ID
  3. SEQUENCE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ALERT_OUTPUTS.APPLICATION_ID
ALR_ALERT_OUTPUTS.ALERT_ID 		ALR_ALERTS

[top of page]

ALR.ALR_ALERT_OUTPUTS does not reference any database object

ALR.ALR_ALERT_OUTPUTS is referenced by following:

APPS
SYNONYM - ALR_ALERT_OUTPUTS

[top of page]

Table: ALR_DISTRIBUTION_LISTS

Description: Distribution lists
Primary Key: ALR_DISTRIBUTION_LISTS_PK
  1. APPLICATION_ID
  2. LIST_ID
  3. END_DATE_ACTIVE
Primary Key: ALR_DISTRIBUTION_LISTS_UK1
  1. APPLICATION_ID
  2. NAME
  3. END_DATE_ACTIVE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_DISTRIBUTION_LISTS.APPLICATION_ID FND_APPLICATION
ALR_DISTRIBUTION_LISTS.PRINTER FND_PRINTER
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTIONS.LIST_APPLICATION_ID
ALR_ACTIONS.LIST_ID
ALR_ACTIONS.END_DATE_ACTIVE 		ALR_DISTRIBUTION_LISTS

[top of page]

ALR.ALR_DISTRIBUTION_LISTS does not reference any database object

ALR.ALR_DISTRIBUTION_LISTS is referenced by following:

APPS
TRIGGER - ALR_ALR_DISTRIBUTION_LISTS_IAR
TRIGGER - ALR_ALR_DISTRIBUTION_LISTS_UAR
SYNONYM - ALR_DISTRIBUTION_LISTS

[top of page]

Table: ALR_LOOKUPS

Description: Oracle Alert lookup types and codes
Primary Key: ALR_LOOKUPS_PK
  1. LOOKUP_TYPE
  2. LOOKUP_CODE

[top of page]

ALR.ALR_LOOKUPS does not reference any database object

ALR.ALR_LOOKUPS is referenced by following:

APPS
SYNONYM - ALR_LOOKUPS

[top of page]

Table: ALR_MESSAGE_SYSTEMS

Description: Electronic mail system information
Primary Key: ALR_MESSAGE_SYSTEMS_PK
  1. NAME

[top of page]

ALR.ALR_MESSAGE_SYSTEMS does not reference any database object

ALR.ALR_MESSAGE_SYSTEMS is referenced by following:

APPS
SYNONYM - ALR_MESSAGE_SYSTEMS

[top of page]

Table: ALR_ORACLE_MAIL_ACCOUNTS

Description: Oracle*Mail mail account information
Primary Key: ALR_ORACLE_MAIL_ACCOUNTS_PK
  1. APPLICATION_ID
  2. ORACLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_ORACLE_MAIL_ACCOUNTS.APPLICATION_ID FND_APPLICATION
ALR_ORACLE_MAIL_ACCOUNTS.ORACLE_ID FND_ORACLE_USERID

[top of page]

ALR.ALR_ORACLE_MAIL_ACCOUNTS does not reference any database object

ALR.ALR_ORACLE_MAIL_ACCOUNTS is referenced by following:

APPS
SYNONYM - ALR_ORACLE_MAIL_ACCOUNTS

[top of page]

Table: ALR_OUTPUT_HISTORY

Description: Exception output history
Primary Key: ALR_OUTPUT_HISTORY_PK
  1. APPLICATION_ID
  2. CHECK_ID
  3. ROW_NUMBER
  4. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_OUTPUT_HISTORY.APPLICATION_ID
ALR_OUTPUT_HISTORY.CHECK_ID 		ALR_ACTION_SET_CHECKS

[top of page]

ALR.ALR_OUTPUT_HISTORY does not reference any database object

ALR.ALR_OUTPUT_HISTORY is referenced by following:

APPS
SYNONYM - ALR_OUTPUT_HISTORY

[top of page]

Table: ALR_PERIODIC_SETS

Description: Periodic alert sets
Primary Key: ALR_PERIODIC_SETS_PK
  1. APPLICATION_ID
  2. PERIODIC_SET_ID
Primary Key: ALR_PERIODIC_SETS_UK1
  1. APPLICATION_ID
  2. NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_PERIODIC_SET_MEMBERS.APPLICATION_ID
ALR_PERIODIC_SET_MEMBERS.PERIODIC_SET_ID 		ALR_PERIODIC_SETS

[top of page]

ALR.ALR_PERIODIC_SETS does not reference any database object

ALR.ALR_PERIODIC_SETS is referenced by following:

APPS
SYNONYM - ALR_PERIODIC_SETS

[top of page]

Table: ALR_PERIODIC_SET_MEMBERS

Description: Member alerts and periodic sets of periodic sets
Primary Key: ALR_PERIODIC_SET_MEMBERS_PK
  1. APPLICATION_ID
  2. PERIODIC_SET_ID
  3. CHILD_APPLICATION_ID
  4. CHILD_ALERT_ID
  5. CHILD_PERIODIC_SET_ID
  6. SEQUENCE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_PERIODIC_SET_MEMBERS.APPLICATION_ID
ALR_PERIODIC_SET_MEMBERS.PERIODIC_SET_ID 		ALR_PERIODIC_SETS
ALR_PERIODIC_SET_MEMBERS.CHILD_APPLICATION_ID
ALR_PERIODIC_SET_MEMBERS.CHILD_ALERT_ID 		ALR_ALERTS

[top of page]

ALR.ALR_PERIODIC_SET_MEMBERS does not reference any database object

ALR.ALR_PERIODIC_SET_MEMBERS is referenced by following:

APPS
SYNONYM - ALR_PERIODIC_SET_MEMBERS

[top of page]

Table: ALR_PROFILE_OPTIONS

Description: Oracle Alert profile options and values
Primary Key: ALR_PROFILE_OPTIONS_PK
  1. PROFILE_OPTION_NAME
Primary Key: ALR_PROFILE_OPTIONS_UK1
  1. DESCRIPTION

[top of page]

ALR.ALR_PROFILE_OPTIONS does not reference any database object

ALR.ALR_PROFILE_OPTIONS is referenced by following:

APPS
SYNONYM - ALR_PROFILE_OPTIONS

[top of page]

Table: ALR_RESPONSE_ACTIONS

Description: Member actions of a response set
Primary Key: ALR_RESPONSE_ACTIONS_PK
  1. APPLICATION_ID
  2. ALERT_ID
  3. RESPONSE_SET_ID
  4. RESPONSE_ID
  5. SEQUENCE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_RESPONSE_ACTIONS.APPLICATION_ID
ALR_RESPONSE_ACTIONS.ALERT_ID 		ALR_ALERTS
ALR_RESPONSE_ACTIONS.APPLICATION_ID
ALR_RESPONSE_ACTIONS.ACTION_ID
ALR_RESPONSE_ACTIONS.END_DATE_ACTIVE 		ALR_ACTIONS
ALR_RESPONSE_ACTIONS.APPLICATION_ID
ALR_RESPONSE_ACTIONS.ALERT_ID
ALR_RESPONSE_ACTIONS.RESPONSE_SET_ID 		ALR_RESPONSE_SETS

[top of page]

ALR.ALR_RESPONSE_ACTIONS does not reference any database object

ALR.ALR_RESPONSE_ACTIONS is referenced by following:

APPS
SYNONYM - ALR_RESPONSE_ACTIONS

[top of page]

Table: ALR_RESPONSE_ACTION_HISTORY

Description: Response processing history
Primary Key: ALR_RESPONSE_ACTION_HISTORY_PK
  1. RESPONSE_MESSAGE_ID
  2. SEQUENCE
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_RESPONSE_ACTION_HISTORY.RESPONSE_MESSAGE_ID ALR_RESPONSE_MESSAGES
ALR_RESPONSE_ACTION_HISTORY.ORACLE_ID FND_ORACLE_USERID
ALR_RESPONSE_ACTION_HISTORY.NODE_HANDLE
ALR_RESPONSE_ACTION_HISTORY.MESSAGE_HANDLE 		ALR_ACTUAL_RESPONSES
ALR_RESPONSE_ACTION_HISTORY.APPLICATION_ID
ALR_RESPONSE_ACTION_HISTORY.ALERT_ID 		ALR_ALERTS

[top of page]

ALR.ALR_RESPONSE_ACTION_HISTORY does not reference any database object

ALR.ALR_RESPONSE_ACTION_HISTORY is referenced by following:

APPS
SYNONYM - ALR_RESPONSE_ACTION_HISTORY

[top of page]

Table: ALR_RESPONSE_MESSAGES

Description: Messages received in reply to an alert message
Primary Key: ALR_RESPONSE_MESSAGES_PK
  1. RESPONSE_MESSAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_RESPONSE_MESSAGES.NODE_HANDLE
ALR_RESPONSE_MESSAGES.MESSAGE_HANDLE 		ALR_ACTUAL_RESPONSES
ALR_RESPONSE_MESSAGES.APPLICATION_ID
ALR_RESPONSE_MESSAGES.ALERT_ID
ALR_RESPONSE_MESSAGES.RESPONSE_SET_ID
ALR_RESPONSE_MESSAGES.RESPONSE_ID 		ALR_VALID_RESPONSES
ALR_RESPONSE_MESSAGES.APPLICATION_ID
ALR_RESPONSE_MESSAGES.ALERT_ID
ALR_RESPONSE_MESSAGES.RESPONSE_SET_ID 		ALR_RESPONSE_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_RESPONSE_ACTION_HISTORY.RESPONSE_MESSAGE_ID ALR_RESPONSE_MESSAGES

[top of page]

ALR.ALR_RESPONSE_MESSAGES does not reference any database object

ALR.ALR_RESPONSE_MESSAGES is referenced by following:

APPS
SYNONYM - ALR_RESPONSE_MESSAGES

[top of page]

Table: ALR_RESPONSE_SETS

Description: Response sets
Primary Key: ALR_RESPONSE_SETS_PK
  1. APPLICATION_ID
  2. ALERT_ID
  3. RESPONSE_SET_ID
Primary Key: ALR_RESPONSE_SETS_UK1
  1. APPLICATION_ID
  2. ALERT_ID
  3. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_RESPONSE_SETS.APPLICATION_ID
ALR_RESPONSE_SETS.ALERT_ID 		ALR_ALERTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTUAL_RESPONSES.APPLICATION_ID
ALR_ACTUAL_RESPONSES.ALERT_ID
ALR_ACTUAL_RESPONSES.RESPONSE_SET_ID 		ALR_RESPONSE_SETS
ALR_RESPONSE_ACTIONS.APPLICATION_ID
ALR_RESPONSE_ACTIONS.ALERT_ID
ALR_RESPONSE_ACTIONS.RESPONSE_SET_ID 		ALR_RESPONSE_SETS
ALR_RESPONSE_MESSAGES.APPLICATION_ID
ALR_RESPONSE_MESSAGES.ALERT_ID
ALR_RESPONSE_MESSAGES.RESPONSE_SET_ID 		ALR_RESPONSE_SETS
ALR_RESPONSE_VARIABLES.APPLICATION_ID
ALR_RESPONSE_VARIABLES.ALERT_ID
ALR_RESPONSE_VARIABLES.RESPONSE_SET_ID 		ALR_RESPONSE_SETS
ALR_RESPONSE_VARIABLE_VALUES.APPLICATION_ID
ALR_RESPONSE_VARIABLE_VALUES.ALERT_ID
ALR_RESPONSE_VARIABLE_VALUES.RESPONSE_SET_ID 		ALR_RESPONSE_SETS
ALR_VALID_RESPONSES.APPLICATION_ID
ALR_VALID_RESPONSES.ALERT_ID
ALR_VALID_RESPONSES.RESPONSE_ID 		ALR_RESPONSE_SETS

[top of page]

ALR.ALR_RESPONSE_SETS does not reference any database object

ALR.ALR_RESPONSE_SETS is referenced by following:

APPS
SYNONYM - ALR_RESPONSE_SETS

[top of page]

Table: ALR_RESPONSE_VARIABLES

Description: Response set variables
Primary Key: ALR_RESPONSE_VARIABLES_PK
  1. APPLICATION_ID
  2. ALERT_ID
  3. RESPONSE_SET_ID
  4. VARIABLE_NUMBER
Primary Key: ALR_RESPONSE_VARIABLES_UK1
  1. APPLICATION_ID
  2. ALERT_ID
  3. RESPONSE_SET_ID
  4. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_RESPONSE_VARIABLES.APPLICATION_ID
ALR_RESPONSE_VARIABLES.ALERT_ID 		ALR_ALERTS
ALR_RESPONSE_VARIABLES.APPLICATION_ID
ALR_RESPONSE_VARIABLES.ALERT_ID
ALR_RESPONSE_VARIABLES.RESPONSE_SET_ID 		ALR_RESPONSE_SETS

[top of page]

ALR.ALR_RESPONSE_VARIABLES does not reference any database object

ALR.ALR_RESPONSE_VARIABLES is referenced by following:

APPS
SYNONYM - ALR_RESPONSE_VARIABLES

[top of page]

Table: ALR_RESPONSE_VARIABLE_VALUES

Description: Actual variable and alert output values returned in a response message
Primary Key: ALR_RESPONSE_VAR_VALUES_PK
  1. NODE_HANDLE
  2. MESSAGE_HANDLE
  3. VARIABLE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_RESPONSE_VARIABLE_VALUES.APPLICATION_ID
ALR_RESPONSE_VARIABLE_VALUES.ALERT_ID 		ALR_ALERTS
ALR_RESPONSE_VARIABLE_VALUES.APPLICATION_ID
ALR_RESPONSE_VARIABLE_VALUES.ALERT_ID
ALR_RESPONSE_VARIABLE_VALUES.RESPONSE_SET_ID 		ALR_RESPONSE_SETS
ALR_RESPONSE_VARIABLE_VALUES.NODE_HANDLE
ALR_RESPONSE_VARIABLE_VALUES.MESSAGE_HANDLE 		ALR_ACTUAL_RESPONSES

[top of page]

ALR.ALR_RESPONSE_VARIABLE_VALUES does not reference any database object

ALR.ALR_RESPONSE_VARIABLE_VALUES is referenced by following:

APPS
SYNONYM - ALR_RESPONSE_VARIABLE_VALUES

[top of page]

Table: ALR_VALID_RESPONSES

Description: Response text for each possible response to an alert message
Primary Key: ALR_VALID_RESPONSES_PK
  1. APPLICATION_ID
  2. ALERT_ID
  3. RESPONSE_SET_ID
  4. RESPONSE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ALR_VALID_RESPONSES.APPLICATION_ID
ALR_VALID_RESPONSES.ALERT_ID 		ALR_ALERTS
ALR_VALID_RESPONSES.APPLICATION_ID
ALR_VALID_RESPONSES.ALERT_ID
ALR_VALID_RESPONSES.RESPONSE_ID 		ALR_RESPONSE_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ALR_ACTUAL_RESPONSES.APPLICATION_ID
ALR_ACTUAL_RESPONSES.ALERT_ID
ALR_ACTUAL_RESPONSES.RESPONSE_SET_ID
ALR_ACTUAL_RESPONSES.RESPONSE_ID 		ALR_VALID_RESPONSES
ALR_RESPONSE_MESSAGES.APPLICATION_ID
ALR_RESPONSE_MESSAGES.ALERT_ID
ALR_RESPONSE_MESSAGES.RESPONSE_SET_ID
ALR_RESPONSE_MESSAGES.RESPONSE_ID 		ALR_VALID_RESPONSES

[top of page]

ALR.ALR_VALID_RESPONSES does not reference any database object

ALR.ALR_VALID_RESPONSES is referenced by following:

APPS
SYNONYM - ALR_VALID_RESPONSES

[top of page]

View: ALR_ACTIONS_V

[top of page]

APPS.ALR_ACTIONS_V references the following:

APPS
SYNONYM - ALR_ACTIONS
SYNONYM - ALR_DISTRIBUTION_LISTS
SYNONYM - ALR_RESPONSE_SETS
SYNONYM - FND_APPLICATION_TL

APPS.ALR_ACTIONS_V is not referenced by any database object

[top of page]

View: ALR_ALERT_ACTIONS_VIEW

[top of page]

APPS.ALR_ALERT_ACTIONS_VIEW references the following:

APPS
SYNONYM - ALR_ACTIONS
SYNONYM - ALR_ACTION_GROUPS
SYNONYM - ALR_ACTION_GROUP_MEMBERS
SYNONYM - ALR_ACTION_SETS
SYNONYM - ALR_ACTION_SET_MEMBERS
SYNONYM - ALR_ALERTS
APPS.ALR_ALERT_ACTIONS_VIEW is referenced by following:

APPS
VIEW - ALR_ALERT_HISTORY_VIEW

[top of page]

View: ALR_ALERT_HISTORY_VIEW

[top of page]

APPS.ALR_ALERT_HISTORY_VIEW references the following:

APPS
VIEW - ALR_ALERT_ACTIONS_VIEW
VIEW - ALR_CHECK_ACTION_HISTORY_VIEW

APPS.ALR_ALERT_HISTORY_VIEW is not referenced by any database object

[top of page]

View: ALR_CHECK_ACTION_HISTORY_VIEW

[top of page]

APPS.ALR_CHECK_ACTION_HISTORY_VIEW references the following:

APPS
SYNONYM - ALR_ACTION_DATA
SYNONYM - ALR_ACTION_HISTORY
SYNONYM - ALR_ACTION_SET_CHECKS
SYNONYM - ALR_ALERT_CHECKS
SYNONYM - ALR_OUTPUT_HISTORY
APPS.ALR_CHECK_ACTION_HISTORY_VIEW is referenced by following:

APPS
VIEW - ALR_ALERT_HISTORY_VIEW

[top of page]

View: ALR_GROUPS_AND_ACTIONS_VIEW

[top of page]

APPS.ALR_GROUPS_AND_ACTIONS_VIEW references the following:

APPS
SYNONYM - ALR_ACTIONS
SYNONYM - ALR_ACTION_GROUPS
SYNONYM - ALR_ALERTS
SYNONYM - ALR_LOOKUPS

APPS.ALR_GROUPS_AND_ACTIONS_VIEW is not referenced by any database object

[top of page]

View: ALR_INSTALLATIONS_VIEW

[top of page]

APPS.ALR_INSTALLATIONS_VIEW references the following:

APPS
SYNONYM - ALR_LOOKUPS
VIEW - FND_APPLICATION_VL
SYNONYM - FND_ORACLE_USERID
SYNONYM - FND_PRODUCT_INSTALLATIONS

APPS.ALR_INSTALLATIONS_VIEW is not referenced by any database object

[top of page]

View: ALR_PERIODIC_ALERTS_VIEW

[top of page]

APPS.ALR_PERIODIC_ALERTS_VIEW references the following:

APPS
SYNONYM - ALR_ALERTS
SYNONYM - ALR_PERIODIC_SETS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS

APPS.ALR_PERIODIC_ALERTS_VIEW is not referenced by any database object

[top of page]

View: ALR_RESPONSE_ACTIONS_VIEW

[top of page]

APPS.ALR_RESPONSE_ACTIONS_VIEW references the following:

APPS
SYNONYM - ALR_ACTIONS
SYNONYM - ALR_LOOKUPS

APPS.ALR_RESPONSE_ACTIONS_VIEW is not referenced by any database object

[top of page]

View: ALR_SCHEDULED_PROGRAMS

[top of page]

APPS.ALR_SCHEDULED_PROGRAMS references the following:

APPS
VIEW - FND_CONCURRENT_PROGRAMS_VL
SYNONYM - FND_CONCURRENT_QUEUES

APPS.ALR_SCHEDULED_PROGRAMS is not referenced by any database object

[top of page]

View: ALR_VARIABLES_AND_OUTPUTS

[top of page]

APPS.ALR_VARIABLES_AND_OUTPUTS references the following:

APPS
SYNONYM - ALR_ALERT_OUTPUTS
SYNONYM - ALR_RESPONSE_VARIABLES

APPS.ALR_VARIABLES_AND_OUTPUTS is not referenced by any database object

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