Table: AMS_LIST_SELECT_ACTIONS

Product:	AMS - Marketing
Description:	This table stores the set of discoverer workbook, target segments and existing lists which are used to generate the set of list entries.
Implementation/DBA Data:	AMS.AMS_LIST_SELECT_ACTIONS

Primary Key: AMS_LIST_SELECT_ACTIONS_PK

1. LIST_SELECT_ACTION_ID

Primary Key: AMS_LIST_SELECT_ACTIONS_UK1

1. LIST_HEADER_ID
2. INCL_OBJECT_NAME
3. ARC_INCL_OBJECT_FROM

Primary Key: AMS_LIST_SELECT_ACTIONS_UK2

1. LIST_HEADER_ID
2. ORDER_NUMBER

Foreign Keys

Table		Foreign Table	Foreign Key Column
AMS_LIST_SELECT_ACTIONS		AMS_LIST_HEADERS_ALL	AMS_LIST_SELECT_ACTIONS.ACTION_USED_BY_ID
AMS_LIST_SELECT_ACTIONS		AMS_CELLS_ALL_B	AMS_LIST_SELECT_ACTIONS.INCL_OBJECT_ID
AMS_LIST_SELECT_ACTIONS		AMS_LIST_HEADERS_ALL	AMS_LIST_SELECT_ACTIONS.INCL_OBJECT_ID
AMS_LIST_SELECT_ACTIONS		AMS_LIST_QUERIES_ALL	AMS_LIST_SELECT_ACTIONS.INCL_OBJECT_ID
AMS_LIST_SELECT_ACTIONS		AMS_DM_MODELS_ALL_B	AMS_LIST_SELECT_ACTIONS.ACTION_USED_BY_ID
AMS_LIST_SELECT_ACTIONS		AMS_DM_SCORES_ALL_B	AMS_LIST_SELECT_ACTIONS.ACTION_USED_BY_ID
AMS_LIST_SELECT_ACTIONS		AMS_IMP_LIST_HEADERS_ALL	AMS_LIST_SELECT_ACTIONS.INCL_OBJECT_ID
AMS_LIST_SELECT_ACTIONS		AMS_DISCOVERER_SQL	AMS_LIST_SELECT_ACTIONS.INCL_OBJECT_ID