FND Design Data [Home] [Help]

Table: AMS_LIST_HEADERS_ALL

Product: AMS - Marketing
Description: This table stores the name and other details about a target list.
Implementation/DBA Data: TableAMS.AMS_LIST_HEADERS_ALL
Primary Key: AMS_LIST_HEADERS_ALL_PK
  1. ColumnLIST_HEADER_ID
Primary Key: AMS_LIST_HEADERS_ALL_UK1
  1. ColumnVIEW_APPLICATION_ID
  2. ColumnLIST_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
AMS_LIST_HEADERS_ALL FK Joins to TableAMS_CAMPAIGN_SCHEDULES AMS_LIST_HEADERS_ALL.LIST_USED_BY_ID
AMS_LIST_HEADERS_ALL FK Joins to TableAMS_EVENT_OFFERS_ALL_B AMS_LIST_HEADERS_ALL.LIST_USED_BY_ID
AMS_LIST_HEADERS_ALL FK Joins to TableFND_USER AMS_LIST_HEADERS_ALL.LAST_DEDUPED_BY_USER_ID
AMS_LIST_HEADERS_ALL FK Joins to TableFND_USER AMS_LIST_HEADERS_ALL.OWNER_USER_ID
AMS_LIST_HEADERS_ALL FK Joins to TableAMS_EVENT_HEADERS_ALL_B AMS_LIST_HEADERS_ALL.LIST_USED_BY_ID
AMS_LIST_HEADERS_ALL FK Joins to TableHZ_TIMEZONES AMS_LIST_HEADERS_ALL.TIMEZONE_ID
TableAMS_ACT_ACCESS FK Joins to AMS_LIST_HEADERS_ALL AMS_ACT_ACCESS.ACT_ACCESS_TO_OBJECT_ID
TableAMS_ACT_LISTS FK Joins to AMS_LIST_HEADERS_ALL AMS_ACT_LISTS.LIST_HEADER_ID
TableAMS_ACT_LOGS FK Joins to AMS_LIST_HEADERS_ALL AMS_ACT_LOGS.ACT_LOG_USED_BY_ID
TableAMS_ACT_METRICS_ALL FK Joins to AMS_LIST_HEADERS_ALL AMS_ACT_METRICS_ALL.ACT_METRIC_USED_BY_ID
TableAMS_DM_SCORE_LISTS FK Joins to AMS_LIST_HEADERS_ALL AMS_DM_SCORE_LISTS.LIST_HEADER_ID
TableAMS_EVENT_REGISTRATIONS FK Joins to AMS_LIST_HEADERS_ALL AMS_EVENT_REGISTRATIONS.TARGET_LIST_ID
TableAMS_LIST_ENTRIES FK Joins to AMS_LIST_HEADERS_ALL AMS_LIST_ENTRIES.LIST_HEADER_ID
TableAMS_LIST_HEADERS_ALL_TL FK Joins to AMS_LIST_HEADERS_ALL AMS_LIST_HEADERS_ALL_TL.LIST_HEADER_ID
TableIEO_CP_SERVICES_ALL FK Joins to AMS_LIST_HEADERS_ALL IEO_CP_SERVICES_ALL.CAMPAIGN_LIST_ID
TableAMS_LIST_RULE_USAGES FK Joins to AMS_LIST_HEADERS_ALL AMS_LIST_RULE_USAGES.LIST_HEADER_ID
TableAMS_LIST_SELECT_ACTIONS FK Joins to AMS_LIST_HEADERS_ALL AMS_LIST_SELECT_ACTIONS.ACTION_USED_BY_ID
TableAMS_LIST_SELECT_ACTIONS FK Joins to AMS_LIST_HEADERS_ALL AMS_LIST_SELECT_ACTIONS.INCL_OBJECT_ID
TableAMS_LIST_SRC_TYPE_USAGES FK Joins to AMS_LIST_HEADERS_ALL AMS_LIST_SRC_TYPE_USAGES.LIST_HEADER_ID
TableAMS_TCOP_PRVW_REQUESTS FK Joins to AMS_LIST_HEADERS_ALL AMS_TCOP_PRVW_REQUESTS.LIST_HEADER_ID
TableAMS_TRIGGER_ACTIONS FK Joins to AMS_LIST_HEADERS_ALL AMS_TRIGGER_ACTIONS.LIST_HEADER_ID