Table: ALR_ACTIONS

Product:	ALR - Alert
Description:	Alert and response actions
Implementation/DBA Data:	ALR.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

Table		Foreign Table	Foreign Key Column
ALR_ACTIONS		ALR_ALERTS	ALR_ACTIONS.APPLICATION_ID ALR_ACTIONS.ALERT_ID
ALR_ACTIONS		ALR_DISTRIBUTION_LISTS	ALR_ACTIONS.LIST_APPLICATION_ID ALR_ACTIONS.LIST_ID ALR_ACTIONS.END_DATE_ACTIVE
ALR_ACTIONS		FND_CONCURRENT_PROGRAMS	ALR_ACTIONS.PROGRAM_APPLICATION_ID ALR_ACTIONS.CONCURRENT_PROGRAM_ID
ALR_ACTION_GROUP_MEMBERS		ALR_ACTIONS	ALR_ACTION_GROUP_MEMBERS.APPLICATION_ID ALR_ACTION_GROUP_MEMBERS.ACTION_ID ALR_ACTION_GROUP_MEMBERS.END_DATE_ACTIVE
ALR_ACTION_OUTPUTS		ALR_ACTIONS	ALR_ACTION_OUTPUTS.APPLICATION_ID ALR_ACTION_OUTPUTS.ACTION_ID ALR_ACTION_OUTPUTS.END_DATE_ACTIVE
ALR_ACTION_SET_MEMBERS		ALR_ACTIONS	ALR_ACTION_SET_MEMBERS.APPLICATION_ID ALR_ACTION_SET_MEMBERS.ACTION_ID ALR_ACTION_SET_MEMBERS.END_DATE_ACTIVE
ALR_RESPONSE_ACTIONS		ALR_ACTIONS	ALR_RESPONSE_ACTIONS.APPLICATION_ID ALR_RESPONSE_ACTIONS.ACTION_ID ALR_RESPONSE_ACTIONS.END_DATE_ACTIVE