DBA Data[Home] [Help] [Dependency Information]

TABLE: AMS.AMS_LIST_HEADERS_ALL

Object Details
Object Name: AMS_LIST_HEADERS_ALL
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_LIST_HEADERS_ALL
Subobject Name:
Status: VALID


AMS_LIST_HEADERS_ALL defines List information. Direct marketing promotions have one or more prospect customer lists generated for mailshots and telemarketing. The table contain all information needed by the List Generation Build process to build a list. That is, is there a min or max amount of rows, should rows be selected randomly etc.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_LIST_HEADERS_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_HEADER_ID
AMS_LIST_HEADERS_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_USED_BY_ID
ColumnARC_LIST_USED_BY
AMS_LIST_HEADERS_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATUS_CODE
AMS_LIST_HEADERS_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_DEDUPED_BY_USER_ID
AMS_LIST_HEADERS_ALL_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOWNER_USER_ID
AMS_LIST_HEADERS_ALL_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_TYPE
AMS_LIST_HEADERS_ALL_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCESS_LEVEL
AMS_LIST_HEADERS_ALL_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORG_ID
AMS_LIST_HEADERS_ALL_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_SOURCE_TYPE
Columns
Name Datatype Length Mandatory Comments
LIST_HEADER_ID NUMBER
Yes UNIQUE IDENTIFIER
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
OBJECT_VERSION_NUMBER NUMBER (9)
This column is used for locking purposes
REQUEST_ID NUMBER (15)
Request identifier of last concurrent program to update this record
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last update date of this record by a concurrent program
VIEW_APPLICATION_ID NUMBER

Application Id of Oracle Product that created the list.
LIST_NAME VARCHAR2 (240)
Obseleted (moved to ams_list_headers_all_tl )
LIST_USED_BY_ID NUMBER
Yes Foreign key to marketing activity associated with the list.
ARC_LIST_USED_BY VARCHAR2 (30) Yes Qualifier to marketing activity associated with the list.
LIST_TYPE VARCHAR2 (30) Yes Type of list either Target or Template.
STATUS_CODE VARCHAR2 (30) Yes Status of the list, either New or Pending or Available or Reserved or Locked or Archived.
STATUS_DATE DATE
Yes The Date on which The Status was set.
GENERATION_TYPE VARCHAR2 (30) Yes Generation Type of the List, either Standard or Incremental or Repeating.
REPEAT_EXCLUDE_TYPE VARCHAR2 (240)
Not implemented.
ROW_SELECTION_TYPE VARCHAR2 (30) Yes Selection type of a row in the list either Standard or N th or Random.
OWNER_USER_ID NUMBER (15) Yes Owner of the list.
ACCESS_LEVEL VARCHAR2 (30)
Access level of the list either User or Group.
ENABLE_LOG_FLAG VARCHAR2 (1)
Flag to enable log during list generation.
ENABLE_WORD_REPLACEMENT_FLAG VARCHAR2 (1)
Flag to enable word replacement during deduplication.
ENABLE_PARALLEL_DML_FLAG VARCHAR2 (1)
not implemented.
DEDUPE_DURING_GENERATION_FLAG VARCHAR2 (1)
Flag to determine if deduplication to be done during generation.
GENERATE_CONTROL_GROUP_FLAG VARCHAR2 (1)
not implemented.
LAST_GENERATION_SUCCESS_FLAG VARCHAR2 (1)
Flag to indicate sucess or failure of last generation.
FORECASTED_START_DATE DATE

The Date on which The List is estimated to start.
FORECASTED_END_DATE DATE

The Date on which The List is estimated to expire.
ACTUAL_END_DATE DATE

The Date on which this list will expire.
SENT_OUT_DATE DATE

The date on which the list is assigned for processing.
DEDUPE_START_DATE DATE

The deduplication start date of the list.
LAST_DEDUPE_DATE DATE

The last deduplication date of the list.
LAST_DEDUPED_BY_USER_ID NUMBER (15)
User identifier who last deduplicated the list.
WORKFLOW_ITEM_KEY NUMBER

not implemented.
NO_OF_ROWS_DUPLICATES NUMBER (15)
number of duplicate rows in the list.
NO_OF_ROWS_MIN_REQUESTED NUMBER (15)
minimum number of rows in the list to be generated.
NO_OF_ROWS_MAX_REQUESTED NUMBER (15)
maximum number of rows in the list to be generated.
NO_OF_ROWS_IN_LIST NUMBER (15)
total number of rows in the list.
NO_OF_ROWS_IN_CTRL_GROUP NUMBER (15)
not implemented.
NO_OF_ROWS_ACTIVE NUMBER (15)
for OSM upgrade.
NO_OF_ROWS_INACTIVE NUMBER

For OSM upgrade
NO_OF_ROWS_MANUALLY_ENTERED NUMBER (15)
For OSM upgrade
NO_OF_ROWS_DO_NOT_CALL NUMBER (15)
number of rows in the list to not call.
NO_OF_ROWS_DO_NOT_MAIL NUMBER (15)
number of rows in the list to not mail.
NO_OF_ROWS_RANDOM NUMBER (15)
For OSM upgrade
ORG_ID NUMBER (32)
Operating unit which performed this transaction.
MAIN_GEN_START_TIME DATE

Time the list started generation.
MAIN_GEN_END_TIME DATE

Time the list ended generation.
MAIN_RANDOM_NTH_ROW_SELECTION NUMBER (15)
Number of random rows to be selected.
MAIN_RANDOM_PCT_ROW_SELECTION NUMBER (15)
Percent of random rows to be selected.
CTRL_RANDOM_NTH_ROW_SELECTION NUMBER (15)
not implemented.
CTRL_RANDOM_PCT_ROW_SELECTION NUMBER (15)
not implemented.
REPEAT_SOURCE_LIST_HEADER_ID VARCHAR2 (4000)
Identifier of parent of generating list.
RESULT_TEXT VARCHAR2 (4000)
Text for list generation processing information.
KEYWORDS VARCHAR2 (4000)
words used to categorize the list.
DESCRIPTION VARCHAR2 (4000)
A Description of the intended usage for the list.
LIST_PRIORITY NUMBER (15)
For OSM upgrade only
ASSIGN_PERSON_ID NUMBER

For OSM upgrade only
LIST_SOURCE VARCHAR2 (240)
For OSM upgrade only
LIST_SOURCE_TYPE VARCHAR2 (30)
For OSM upgrade only
LIST_ONLINE_FLAG VARCHAR2 (1)
For OSM upgrade only
RANDOM_LIST_ID NUMBER

For OSM upgrade only
ENABLED_FLAG VARCHAR2 (1)
For OSM upgrade only
ASSIGNED_TO NUMBER

For OSM upgrade only
QUERY_ID NUMBER (15)
For OSM upgrade only
OWNER_PERSON_ID NUMBER

For OSM upgrade only
ARCHIVED_BY NUMBER (15)
The User who performed The Archive.
ARCHIVED_DATE DATE

The Date on which The List Entries were Archived.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment.
TIMEZONE_ID NUMBER (15)
User entered timezone for list generation schedule.
USER_ENTERED_START_TIME DATE

User entered date & time for list generation schedule, this corresponds to the TIMEZONE_ID.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
USER_STATUS_ID NUMBER

User status identifier
QUANTUM NUMBER

For Advanced Outbound Purposes
RELEASE_CONTROL_ALG_ID NUMBER

For Advanced Outbound Purposes
DIALING_METHOD VARCHAR2 (30)
For Advanced Outbound Purposes
CALLING_CALENDAR_ID NUMBER

For Advanced Outbound Purposes
RELEASE_STRATEGY VARCHAR2 (30)
For Advanced Outbound Purposes
CUSTOM_SETUP_ID NUMBER

Custom set up Identifier
COUNTRY NUMBER

Country code
CALLBACK_PRIORITY_FLAG VARCHAR2 (1)
For Advanced Outbound Purposes
CALL_CENTER_READY_FLAG VARCHAR2 (1)
For Advanced Outbound Purposes
PURGE_FLAG VARCHAR2 (1)
Purge Flag Can be Y or N
QUOTA NUMBER (10)
For Advanced Outbound Purposes
QUOTA_RESET NUMBER (10)
For Advanced Outbound Purposes
RECYCLING_ALG_ID NUMBER (15)
For Advanced Outbound Purposes
PUBLIC_FLAG VARCHAR2 (1)
Flag to indicate whether the list is public
LIST_CATEGORY VARCHAR2 (120)
It helps the user to categorize the lists
NO_OF_ROWS_PREV_CONTACTED NUMBER

Stores total number of previously contacted entries
PURPOSE_CODE VARCHAR2 (120)
Purpose code associated with the list.
NO_OF_ROWS_FATIGUED NUMBER

Total number of rows marked by the traffic cop engine.
NO_OF_ROWS_SUPPRESSED NUMBER

Number of suppressed rows
QUERY_TEMPLATE_ID NUMBER

If list created using a template, this column will have the template id.
APPLY_TRAFFIC_COP VARCHAR2 (1)
If fatigue rules are enabled, this column will have value as 'Y'.
MIGRATION_DATE DATE

Migration date of list entries.Used for lists based on remote data sources.
TCA_FAILED_RECORDS NUMBER

Number of TCA failed records.
PARENT_LIST_HEADER_ID NUMBER

Will have value of parent list header id incase of some split lists.
SPLIT_TYPE VARCHAR2 (15)
Split type of list (e.g. Attribute/Percentage/Number)
SPLIT_VALUE NUMBER

Split value for Percentage and Number splits.
CTRL_CONF_LEVEL NUMBER

Confidence Level for Statistcal Formula for Control Group
CTRL_REQ_RESP_RATE NUMBER

Response Rate for Statistical Formula for Control Group
CTRL_LIMIT_OF_ERROR NUMBER

% Limit of Error for Control Group
STATUS_CODE_OLD VARCHAR2 (30)
Previous Status of the Target Group while the Control Group Generation
CTRL_CONC_JOB_ID NUMBER

Concurrent Request ID for the Control Group Generation request
CTRL_STATUS_CODE VARCHAR2 (30)
Control Group Status Code
CTRL_GEN_MODE VARCHAR2 (30)
Control Group Generation Mode
APPLY_SUPPRESSION_FLAG VARCHAR2 (1)
Apply Suppression Flag
REMOTE_GEN_FLAG VARCHAR2 (1)
Remote Generation Flag
NO_OF_ROWS_INITIALLY_SELECTED NUMBER

Number of Rows Initially Selected
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LIST_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      VIEW_APPLICATION_ID
,      LIST_NAME
,      LIST_USED_BY_ID
,      ARC_LIST_USED_BY
,      LIST_TYPE
,      STATUS_CODE
,      STATUS_DATE
,      GENERATION_TYPE
,      REPEAT_EXCLUDE_TYPE
,      ROW_SELECTION_TYPE
,      OWNER_USER_ID
,      ACCESS_LEVEL
,      ENABLE_LOG_FLAG
,      ENABLE_WORD_REPLACEMENT_FLAG
,      ENABLE_PARALLEL_DML_FLAG
,      DEDUPE_DURING_GENERATION_FLAG
,      GENERATE_CONTROL_GROUP_FLAG
,      LAST_GENERATION_SUCCESS_FLAG
,      FORECASTED_START_DATE
,      FORECASTED_END_DATE
,      ACTUAL_END_DATE
,      SENT_OUT_DATE
,      DEDUPE_START_DATE
,      LAST_DEDUPE_DATE
,      LAST_DEDUPED_BY_USER_ID
,      WORKFLOW_ITEM_KEY
,      NO_OF_ROWS_DUPLICATES
,      NO_OF_ROWS_MIN_REQUESTED
,      NO_OF_ROWS_MAX_REQUESTED
,      NO_OF_ROWS_IN_LIST
,      NO_OF_ROWS_IN_CTRL_GROUP
,      NO_OF_ROWS_ACTIVE
,      NO_OF_ROWS_INACTIVE
,      NO_OF_ROWS_MANUALLY_ENTERED
,      NO_OF_ROWS_DO_NOT_CALL
,      NO_OF_ROWS_DO_NOT_MAIL
,      NO_OF_ROWS_RANDOM
,      ORG_ID
,      MAIN_GEN_START_TIME
,      MAIN_GEN_END_TIME
,      MAIN_RANDOM_NTH_ROW_SELECTION
,      MAIN_RANDOM_PCT_ROW_SELECTION
,      CTRL_RANDOM_NTH_ROW_SELECTION
,      CTRL_RANDOM_PCT_ROW_SELECTION
,      REPEAT_SOURCE_LIST_HEADER_ID
,      RESULT_TEXT
,      KEYWORDS
,      DESCRIPTION
,      LIST_PRIORITY
,      ASSIGN_PERSON_ID
,      LIST_SOURCE
,      LIST_SOURCE_TYPE
,      LIST_ONLINE_FLAG
,      RANDOM_LIST_ID
,      ENABLED_FLAG
,      ASSIGNED_TO
,      QUERY_ID
,      OWNER_PERSON_ID
,      ARCHIVED_BY
,      ARCHIVED_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TIMEZONE_ID
,      USER_ENTERED_START_TIME
,      SECURITY_GROUP_ID
,      USER_STATUS_ID
,      QUANTUM
,      RELEASE_CONTROL_ALG_ID
,      DIALING_METHOD
,      CALLING_CALENDAR_ID
,      RELEASE_STRATEGY
,      CUSTOM_SETUP_ID
,      COUNTRY
,      CALLBACK_PRIORITY_FLAG
,      CALL_CENTER_READY_FLAG
,      PURGE_FLAG
,      QUOTA
,      QUOTA_RESET
,      RECYCLING_ALG_ID
,      PUBLIC_FLAG
,      LIST_CATEGORY
,      NO_OF_ROWS_PREV_CONTACTED
,      PURPOSE_CODE
,      NO_OF_ROWS_FATIGUED
,      NO_OF_ROWS_SUPPRESSED
,      QUERY_TEMPLATE_ID
,      APPLY_TRAFFIC_COP
,      MIGRATION_DATE
,      TCA_FAILED_RECORDS
,      PARENT_LIST_HEADER_ID
,      SPLIT_TYPE
,      SPLIT_VALUE
,      CTRL_CONF_LEVEL
,      CTRL_REQ_RESP_RATE
,      CTRL_LIMIT_OF_ERROR
,      STATUS_CODE_OLD
,      CTRL_CONC_JOB_ID
,      CTRL_STATUS_CODE
,      CTRL_GEN_MODE
,      APPLY_SUPPRESSION_FLAG
,      REMOTE_GEN_FLAG
,      NO_OF_ROWS_INITIALLY_SELECTED
FROM AMS.AMS_LIST_HEADERS_ALL;

Dependencies

[top of page]

AMS.AMS_LIST_HEADERS_ALL does not reference any database object

AMS.AMS_LIST_HEADERS_ALL is referenced by following:

SchemaAPPS
SynonymAMS_LIST_HEADERS_ALL