eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: ALR_ALERTS

Product:	ALR - Alert
Description:	Alerts defined on application tables
Implementation/DBA Data:	ALR.ALR_ALERTS

Primary Key: ALR_ALERTS_PK

APPLICATION_ID
ALERT_ID

Primary Key: ALR_ALERTS_UK1

APPLICATION_ID
ALERT_NAME

Foreign Keys

Table	Foreign Table	Foreign Key Column
ALR_ALERTS	FND_TABLES	ALR_ALERTS.TABLE_APPLICATION_ID ALR_ALERTS.TABLE_ID
ALR_ACTIONS	ALR_ALERTS	ALR_ACTIONS.APPLICATION_ID ALR_ACTIONS.ALERT_ID
ALR_ACTION_GROUPS	ALR_ALERTS	ALR_ACTION_GROUPS.APPLICATION_ID ALR_ACTION_GROUPS.ALERT_ID
ALR_ACTION_GROUP_MEMBERS	ALR_ALERTS	ALR_ACTION_GROUP_MEMBERS.APPLICATION_ID ALR_ACTION_GROUP_MEMBERS.ALERT_ID
ALR_ACTION_HISTORY	ALR_ALERTS	ALR_ACTION_HISTORY.APPLICATION_ID ALR_ACTION_HISTORY.ALERT_ID
ALR_ACTION_OUTPUTS	ALR_ALERTS	ALR_ACTION_OUTPUTS.APPLICATION_ID ALR_ACTION_OUTPUTS.ALERT_ID
ALR_ACTION_SETS	ALR_ALERTS	ALR_ACTION_SETS.APPLICATION_ID ALR_ACTION_SETS.ALERT_ID
ALR_ACTION_SET_CHECKS	ALR_ALERTS	ALR_ACTION_SET_CHECKS.APPLICATION_ID ALR_ACTION_SET_CHECKS.ALERT_ID
ALR_ACTION_SET_INPUTS	ALR_ALERTS	ALR_ACTION_SET_INPUTS.APPLICATION_ID ALR_ACTION_SET_INPUTS.ALERT_ID
ALR_ACTION_SET_MEMBERS	ALR_ALERTS	ALR_ACTION_SET_MEMBERS.APPLICATION_ID ALR_ACTION_SET_MEMBERS.ALERT_ID
ALR_ACTION_SET_OUTPUTS	ALR_ALERTS	ALR_ACTION_SET_OUTPUTS.APPLICATION_ID ALR_ACTION_SET_OUTPUTS.ALERT_ID
ALR_ACTUAL_RESPONSES	ALR_ALERTS	ALR_ACTUAL_RESPONSES.APPLICATION_ID ALR_ACTUAL_RESPONSES.ALERT_ID
ALR_ALERT_CHECKS	ALR_ALERTS	ALR_ALERT_CHECKS.APPLICATION_ID ALR_ALERT_CHECKS.ALERT_ID
ALR_ALERT_INPUTS	ALR_ALERTS	ALR_ALERT_INPUTS.APPLICATION_ID ALR_ALERT_INPUTS.ALERT_ID
ALR_ALERT_INSTALLATIONS	ALR_ALERTS	ALR_ALERT_INSTALLATIONS.APPLICATION_ID ALR_ALERT_INSTALLATIONS.ALERT_ID
ALR_ALERT_OUTPUTS	ALR_ALERTS	ALR_ALERT_OUTPUTS.APPLICATION_ID ALR_ALERT_OUTPUTS.ALERT_ID
ALR_PERIODIC_SET_MEMBERS	ALR_ALERTS	ALR_PERIODIC_SET_MEMBERS.CHILD_APPLICATION_ID ALR_PERIODIC_SET_MEMBERS.CHILD_ALERT_ID
ALR_RESPONSE_ACTIONS	ALR_ALERTS	ALR_RESPONSE_ACTIONS.APPLICATION_ID ALR_RESPONSE_ACTIONS.ALERT_ID
ALR_RESPONSE_SETS	ALR_ALERTS	ALR_RESPONSE_SETS.APPLICATION_ID ALR_RESPONSE_SETS.ALERT_ID
ALR_RESPONSE_VARIABLES	ALR_ALERTS	ALR_RESPONSE_VARIABLES.APPLICATION_ID ALR_RESPONSE_VARIABLES.ALERT_ID
ALR_RESPONSE_VARIABLE_VALUES	ALR_ALERTS	ALR_RESPONSE_VARIABLE_VALUES.APPLICATION_ID ALR_RESPONSE_VARIABLE_VALUES.ALERT_ID
ALR_RESPONSE_ACTION_HISTORY	ALR_ALERTS	ALR_RESPONSE_ACTION_HISTORY.APPLICATION_ID ALR_RESPONSE_ACTION_HISTORY.ALERT_ID
ALR_VALID_RESPONSES	ALR_ALERTS	ALR_VALID_RESPONSES.APPLICATION_ID ALR_VALID_RESPONSES.ALERT_ID