FND Design Data [Home] [Help]

Table: AMS_LIST_RULE_USAGES

Product: AMS - Marketing
Description: This table stores the information about the deduplication rules to be used against a generated or imported list.
Implementation/DBA Data: TableAMS.AMS_LIST_RULE_USAGES
Primary Key: AMS_LIST_RULE_USAGES_PK
  1. ColumnLIST_RULE_USAGE_ID
Primary Key: AMS_LIST_RULE_USAGES_UK
  1. ColumnLIST_HEADER_ID
  2. ColumnLIST_RULE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AMS_LIST_RULE_USAGES FK Joins to TableAMS_LIST_RULES_ALL AMS_LIST_RULE_USAGES.LIST_RULE_ID
AMS_LIST_RULE_USAGES FK Joins to TableAMS_LIST_HEADERS_ALL AMS_LIST_RULE_USAGES.LIST_HEADER_ID