FND Design Data [Home] [Help]

Table: AMS_LIST_SRC_TYPES

Product: AMS - Marketing
Description: This table stores all different list source types that may be used for list generation.
Implementation/DBA Data: TableAMS.AMS_LIST_SRC_TYPES
Primary Key: AMS_LIST_SRC_TYPES_PK
  1. ColumnLIST_SOURCE_TYPE_ID
Primary Key: AMS_LIST_SRC_TYPES_UK2
  1. ColumnLIST_SOURCE_TYPE
  2. ColumnLIST_SOURCE_NAME
  3. ColumnSOURCE_TYPE_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
TableAMS_DM_TARGETS_B FK Joins to AMS_LIST_SRC_TYPES AMS_DM_TARGETS_B.DATA_SOURCE_ID
TableAMS_DM_TARGETS_B FK Joins to AMS_LIST_SRC_TYPES AMS_DM_TARGETS_B.TARGET_SOURCE_ID
TableAMS_DM_TARGET_SOURCES FK Joins to AMS_LIST_SRC_TYPES AMS_DM_TARGET_SOURCES.DATA_SOURCE_ID
TableAMS_IMP_DEFAULT_MAPPING FK Joins to AMS_LIST_SRC_TYPES AMS_IMP_DEFAULT_MAPPING.LIST_SOURCE_TYPE_ID
TableAMS_IMP_LIST_HEADERS_ALL FK Joins to AMS_LIST_SRC_TYPES AMS_IMP_LIST_HEADERS_ALL.LIST_SOURCE_TYPE_ID
TableAMS_LIST_SRC_FIELDS FK Joins to AMS_LIST_SRC_TYPES AMS_LIST_SRC_FIELDS.LIST_SOURCE_TYPE_ID
TableAMS_LIST_SRC_TYPE_ASSOCS FK Joins to AMS_LIST_SRC_TYPES AMS_LIST_SRC_TYPE_ASSOCS.MASTER_SOURCE_TYPE_ID
TableAMS_LIST_SRC_TYPE_ASSOCS FK Joins to AMS_LIST_SRC_TYPES AMS_LIST_SRC_TYPE_ASSOCS.SUB_SOURCE_TYPE_ID
TableAMS_PARTY_SOURCES FK Joins to AMS_LIST_SRC_TYPES AMS_PARTY_SOURCES.LIST_SOURCE_TYPE_ID