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

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

Comments

Indexes

Columns

[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

Primary Key: ALR_ACTION_DATA_PK

1. APPLICATION_ID
2. ACTION_HISTORY_ID
3. ROW_NUMBER

Foreign Keys from this table:

Comments

Indexes

Columns

[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

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

Comments

Indexes

Columns

[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

Primary Key: ALR_ACTION_GROUP_MEMBERS_PK

1. APPLICATION_ID
2. ACTION_GROUP_MEMBER_ID

Foreign Keys from this table:

Comments

Indexes

Columns

[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

Primary Key: ALR_ACTION_HISTORY_PK

1. APPLICATION_ID
2. ACTION_HISTORY_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Indexes

Columns

[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

Primary Key: ALR_ACTION_OUTPUTS_PK

1. APPLICATION_ID
2. ALERT_ID
3. ACTION_ID
4. NAME

Foreign Keys from this table:

Comments

Indexes

Columns

[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

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

Comments

Indexes

Columns

[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

Primary Key: ALR_ACTION_SET_CHECKS_PK

1. APPLICATION_ID
2. CHECK_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Indexes

Columns

[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

Primary Key: ALR_ACTION_SET_INPUTS_PK

1. APPLICATION_ID
2. ALERT_ID
3. ACTION_SET_ID
4. NAME

Foreign Keys from this table:

Comments

Indexes

Columns

[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

Primary Key: ALR_ACTION_SET_MEMBERS_PK

1. APPLICATION_ID
2. ACTION_SET_MEMBER_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Indexes

Columns

[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

Primary Key: ALR_ACTION_SET_OUTPUTS_PK

1. APPLICATION_ID
2. ALERT_ID
3. ACTION_SET_ID
4. NAME

Foreign Keys from this table:

Comments

Indexes

Columns

[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

Primary Key: ALR_ACTUAL_RESPONSES_PK

1. NODE_HANDLE
2. MESSAGE_HANDLE

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Indexes

Columns

[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

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

Comments

Indexes

Columns

[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

Primary Key: ALR_ALERT_CHECKS_PK

1. APPLICATION_ID
2. ALERT_CHECK_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Indexes

Columns

[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

Primary Key: ALR_ALERT_INPUTS_PK

1. APPLICATION_ID
2. ALERT_ID
3. NAME

Foreign Keys from this table:

Comments

Indexes

Columns

[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

Primary Key: ALR_ALERT_INSTALLATIONS_PK

1. APPLICATION_ID
2. ALERT_ID
3. ORACLE_ID
4. DATA_GROUP_ID

Foreign Keys from this table:

Comments

Indexes

Columns

[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

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:

Comments

Indexes

Columns

[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

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

Comments

Indexes

Columns

[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

Primary Key: ALR_LOOKUPS_PK

1. LOOKUP_TYPE
2. LOOKUP_CODE

Comments

Indexes

Columns

[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

Primary Key: ALR_MESSAGE_SYSTEMS_PK

1. NAME

Comments

Indexes

Columns

[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

Primary Key: ALR_ORACLE_MAIL_ACCOUNTS_PK

1. APPLICATION_ID
2. ORACLE_ID

Foreign Keys from this table:

Comments

Indexes

Columns

[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

Primary Key: ALR_OUTPUT_HISTORY_PK

1. APPLICATION_ID
2. CHECK_ID
3. ROW_NUMBER
4. NAME

Foreign Keys from this table:

Comments

Indexes

Columns

[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

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:

Comments

Indexes

Columns

[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

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:

Comments

Indexes

Columns

[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

Primary Key: ALR_PROFILE_OPTIONS_PK

1. PROFILE_OPTION_NAME

Primary Key: ALR_PROFILE_OPTIONS_UK1

1. DESCRIPTION

Comments

Indexes

Columns

[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

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:

Comments

Indexes

Columns

[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

Primary Key: ALR_RESPONSE_ACTION_HISTORY_PK

1. RESPONSE_MESSAGE_ID
2. SEQUENCE

Foreign Keys from this table:

Comments

Indexes

Columns

[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

Primary Key: ALR_RESPONSE_MESSAGES_PK

1. RESPONSE_MESSAGE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Indexes

Columns

[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

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

Comments

Indexes

Columns

[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

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:

Comments

Indexes

Columns

[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

Primary Key: ALR_RESPONSE_VAR_VALUES_PK

1. NODE_HANDLE
2. MESSAGE_HANDLE
3. VARIABLE_NAME

Foreign Keys from this table:

Comments

Indexes

Columns

[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

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

Comments

Indexes

Columns

[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

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

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

Comments

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

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

View Type

Internal

Columns

[top of page]

APPS

SYNONYM - ALR_ACTIONS

SYNONYM - ALR_ACTION_GROUPS

SYNONYM - ALR_ACTION_GROUP_MEMBERS

SYNONYM - ALR_ACTION_SETS

SYNONYM - ALR_ACTION_SET_MEMBERS

SYNONYM - ALR_ALERTS

APPS

VIEW - ALR_ALERT_HISTORY_VIEW

[top of page]

View: ALR_ALERT_HISTORY_VIEW

Comments

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

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

View Type

Internal

Columns

[top of page]

APPS

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

Comments

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

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

View Type

Internal

Columns

[top of page]

APPS

SYNONYM - ALR_ACTION_DATA

SYNONYM - ALR_ACTION_HISTORY

SYNONYM - ALR_ACTION_SET_CHECKS

SYNONYM - ALR_ALERT_CHECKS

SYNONYM - ALR_OUTPUT_HISTORY

APPS

VIEW - ALR_ALERT_HISTORY_VIEW

[top of page]

View: ALR_GROUPS_AND_ACTIONS_VIEW

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

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

Comments

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

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

View Type

Internal

Columns

[top of page]

APPS

SYNONYM - 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

Comments

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

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

View Type

Internal

Columns

[top of page]

APPS

SYNONYM - 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

Comments

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

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

View Type

Internal

Columns

[top of page]

APPS

SYNONYM - ALR_ACTIONS

SYNONYM - ALR_LOOKUPS

APPS.ALR_RESPONSE_ACTIONS_VIEW is not referenced by any database object

[top of page]

View: ALR_SCHEDULED_PROGRAMS

Comments

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

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

View Type

Internal

Columns

[top of page]

APPS

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

Comments

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

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

View Type

Internal

Columns

[top of page]

APPS

SYNONYM - ALR_ALERT_OUTPUTS

SYNONYM - ALR_RESPONSE_VARIABLES

APPS.ALR_VARIABLES_AND_OUTPUTS is not referenced by any database object

[top of page]