FND Design Data [Home] [Help]

Table: AMS_TRIGGER_CHECKS

Product: AMS - Marketing
Description: AMS_TRIGGER_CHECKS stores all checks that should be run when a datetime(specified in the AMS_TRIGGERS table) is reached.
Implementation/DBA Data: TableAMS.AMS_TRIGGER_CHECKS
Primary Key: AMS_TRIGGER_CHECKS_PK
  1. ColumnTRIGGER_CHECK_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AMS_TRIGGER_CHECKS FK Joins to TableAMS_TRIGGERS AMS_TRIGGER_CHECKS.TRIGGER_ID
AMS_TRIGGER_CHECKS FK Joins to TableAMS_ACT_METRICS_ALL AMS_TRIGGER_CHECKS.CHK1_SOURCE_CODE_METRIC_ID
AMS_TRIGGER_CHECKS FK Joins to TableAMS_ACT_METRICS_ALL AMS_TRIGGER_CHECKS.CHK2_SOURCE_CODE_METRIC_ID
TableAMS_TRIGGER_RESULTS FK Joins to AMS_TRIGGER_CHECKS AMS_TRIGGER_RESULTS.TRIGGER_RESULT_FOR_ID