FND Design Data [Home] [Help]

Table: AMS_LIST_ENTRY_USAGES

Product: AMS - Marketing
Description: This table stores the assignment of list entries to the sales person and the promotion.
Implementation/DBA Data: TableAMS.AMS_LIST_ENTRY_USAGES
Primary Key: AMS_LIST_ENTRY_USAGES_PK
  1. ColumnLIST_ENTRY_USAGE_ID
Primary Key: AMS_LIST_ENTRY_USAGES_UK1
  1. ColumnLIST_HEADER_ID
  2. ColumnCAMPAIGN_ID
  3. ColumnLIST_ENTRY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AMS_LIST_ENTRY_USAGES FK Joins to TableAMS_LIST_ENTRIES AMS_LIST_ENTRY_USAGES.LIST_HEADER_ID
AMS_LIST_ENTRY_USAGES.LIST_ENTRY_ID
AMS_LIST_ENTRY_USAGES FK Joins to TableAMS_CAMPAIGNS_ALL_B AMS_LIST_ENTRY_USAGES.CAMPAIGN_ID