FND Design Data [Home] [Help]

Table: AMS_IMP_LIST_HEADERS_ALL

Product: AMS - Marketing
Description: This table stores the user entered name and other details about lists imported into Oracle Marketing from external sources.
Implementation/DBA Data: TableAMS.AMS_IMP_LIST_HEADERS_ALL
Primary Key: AMS_IMP_LIST_HEADERS_ALL_PK
  1. ColumnIMPORT_LIST_HEADER_ID
Primary Key: AMS_IMP_LIST_HEADERS_ALL_UK1
  1. ColumnNAME
  2. ColumnVERSION
  3. ColumnVIEW_APPLICATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AMS_IMP_LIST_HEADERS_ALL FK Joins to TableAMS_USER_STATUSES_B AMS_IMP_LIST_HEADERS_ALL.USER_STATUS_ID
AMS_IMP_LIST_HEADERS_ALL FK Joins to TableJTF_RS_RESOURCE_EXTNS AMS_IMP_LIST_HEADERS_ALL.OWNER_USER_ID
AMS_IMP_LIST_HEADERS_ALL FK Joins to TableFND_APPLICATION AMS_IMP_LIST_HEADERS_ALL.VIEW_APPLICATION_ID
AMS_IMP_LIST_HEADERS_ALL FK Joins to TableAMS_LIST_SRC_TYPES AMS_IMP_LIST_HEADERS_ALL.LIST_SOURCE_TYPE_ID
TableAMS_ACT_LOGS FK Joins to AMS_IMP_LIST_HEADERS_ALL AMS_ACT_LOGS.ACT_LOG_USED_BY_ID
TableAMS_ACT_METRICS_ALL FK Joins to AMS_IMP_LIST_HEADERS_ALL AMS_ACT_METRICS_ALL.ACT_METRIC_USED_BY_ID
TableAMS_IMP_DOCUMENTS FK Joins to AMS_IMP_LIST_HEADERS_ALL AMS_IMP_DOCUMENTS.IMPORT_LIST_HEADER_ID
TableAMS_IMP_DOC_CONTENT FK Joins to AMS_IMP_LIST_HEADERS_ALL AMS_IMP_DOC_CONTENT.IMPORT_LIST_HEADER_ID
TableAMS_IMP_LIST_HEADERS_ALL_TL FK Joins to AMS_IMP_LIST_HEADERS_ALL AMS_IMP_LIST_HEADERS_ALL_TL.IMPORT_LIST_HEADER_ID
TableAMS_IMP_SOURCE_LINES FK Joins to AMS_IMP_LIST_HEADERS_ALL AMS_IMP_SOURCE_LINES.IMPORT_LIST_HEADER_ID
TableAMS_LIST_IMPORT_ERRORS FK Joins to AMS_IMP_LIST_HEADERS_ALL AMS_LIST_IMPORT_ERRORS.IMPORT_LIST_HEADER_ID
TableAMS_LIST_SELECT_ACTIONS FK Joins to AMS_IMP_LIST_HEADERS_ALL AMS_LIST_SELECT_ACTIONS.INCL_OBJECT_ID
TableAMS_PARTY_SOURCES FK Joins to AMS_IMP_LIST_HEADERS_ALL AMS_PARTY_SOURCES.IMPORT_LIST_HEADER_ID