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


VIEW: APPS.AMS_LIST_HEADERS_VL

Object Details
Object Name: AMS_LIST_HEADERS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_LIST_HEADERS_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns
Name Datatype Length Mandatory Comments
LIST_HEADER_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
REQUEST_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

VIEW_APPLICATION_ID NUMBER

LIST_NAME VARCHAR2 (300) Yes
LIST_USED_BY_ID NUMBER
Yes
ARC_LIST_USED_BY VARCHAR2 (30) Yes
LIST_TYPE VARCHAR2 (30) Yes
USER_STATUS_ID NUMBER

STATUS_CODE VARCHAR2 (30) Yes
STATUS_DATE DATE
Yes
GENERATION_TYPE VARCHAR2 (30) Yes
REPEAT_EXCLUDE_TYPE VARCHAR2 (240)
ROW_SELECTION_TYPE VARCHAR2 (30) Yes
OWNER_USER_ID NUMBER (15) Yes
CUSTOM_SETUP_ID NUMBER

COUNTRY NUMBER

ACCESS_LEVEL VARCHAR2 (30)
ENABLE_LOG_FLAG VARCHAR2 (1)
ENABLE_WORD_REPLACEMENT_FLAG VARCHAR2 (1)
ENABLE_PARALLEL_DML_FLAG VARCHAR2 (1)
DEDUPE_DURING_GENERATION_FLAG VARCHAR2 (1)
GENERATE_CONTROL_GROUP_FLAG VARCHAR2 (1)
LAST_GENERATION_SUCCESS_FLAG VARCHAR2 (1)
FORECASTED_START_DATE DATE

FORECASTED_END_DATE DATE

ACTUAL_END_DATE DATE

SENT_OUT_DATE DATE

DEDUPE_START_DATE DATE

LAST_DEDUPE_DATE DATE

LAST_DEDUPED_BY_USER_ID NUMBER (15)
WORKFLOW_ITEM_KEY NUMBER

NO_OF_ROWS_DUPLICATES NUMBER (15)
NO_OF_ROWS_MIN_REQUESTED NUMBER (15)
NO_OF_ROWS_MAX_REQUESTED NUMBER (15)
NO_OF_ROWS_IN_LIST NUMBER (15)
NO_OF_ROWS_IN_CTRL_GROUP NUMBER (15)
NO_OF_ROWS_ACTIVE NUMBER (15)
NO_OF_ROWS_INACTIVE NUMBER

NO_OF_ROWS_MANUALLY_ENTERED NUMBER (15)
NO_OF_ROWS_DO_NOT_CALL NUMBER (15)
NO_OF_ROWS_DO_NOT_MAIL NUMBER (15)
NO_OF_ROWS_RANDOM NUMBER (15)
ORG_ID NUMBER (32)
MAIN_GEN_START_TIME DATE

MAIN_GEN_END_TIME DATE

MAIN_RANDOM_NTH_ROW_SELECTION NUMBER (15)
MAIN_RANDOM_PCT_ROW_SELECTION NUMBER (15)
CTRL_RANDOM_NTH_ROW_SELECTION NUMBER (15)
CTRL_RANDOM_PCT_ROW_SELECTION NUMBER (15)
REPEAT_SOURCE_LIST_HEADER_ID VARCHAR2 (4000)
RESULT_TEXT VARCHAR2 (4000)
KEYWORDS VARCHAR2 (4000)
DESCRIPTION VARCHAR2 (4000)
LIST_PRIORITY NUMBER (15)
ASSIGN_PERSON_ID NUMBER

LIST_SOURCE VARCHAR2 (240)
LIST_SOURCE_TYPE VARCHAR2 (30)
LIST_ONLINE_FLAG VARCHAR2 (1)
RANDOM_LIST_ID NUMBER

ENABLED_FLAG VARCHAR2 (1)
ASSIGNED_TO NUMBER

QUERY_ID NUMBER (15)
OWNER_PERSON_ID NUMBER

ARCHIVED_BY NUMBER (15)
ARCHIVED_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
TIMEZONE_ID NUMBER (15)
USER_ENTERED_START_TIME DATE

QUANTUM NUMBER

RELEASE_CONTROL_ALG_ID NUMBER

RELEASE_STRATEGY VARCHAR2 (30)
DIALING_METHOD VARCHAR2 (30)
CALLING_CALENDAR_ID NUMBER

CALLBACK_PRIORITY_FLAG VARCHAR2 (1)
CALL_CENTER_READY_FLAG VARCHAR2 (1)
PURGE_FLAG VARCHAR2 (1)
QUOTA NUMBER (10)
QUOTA_RESET NUMBER (10)
RECYCLING_ALG_ID NUMBER (15)
PUBLIC_FLAG VARCHAR2 (1)
LIST_CATEGORY VARCHAR2 (120)
NO_OF_ROWS_PREV_CONTACTED NUMBER

ROW_ID ROWID (10)
PURPOSE_CODE VARCHAR2 (120)
QUERY_TEMPLATE_ID NUMBER

NO_OF_ROWS_FATIGUED NUMBER

NO_OF_ROWS_SUPPRESSED NUMBER

APPLY_TRAFFIC_COP VARCHAR2 (1)
MIGRATION_DATE DATE

TCA_FAILED_RECORDS NUMBER

PARENT_LIST_HEADER_ID NUMBER

SPLIT_TYPE VARCHAR2 (15)
SPLIT_VALUE NUMBER

SECURITY_GROUP_ID NUMBER

CTRL_CONF_LEVEL NUMBER

Confidence Level for Control Group
CTRL_REQ_RESP_RATE NUMBER

Response Rate for Control Group
CTRL_LIMIT_OF_ERROR NUMBER

Limit of Error for Control Group
STATUS_CODE_OLD VARCHAR2 (30)
Old Status Code of Target Group during Control Group generation
CTRL_CONC_JOB_ID NUMBER

Concurrent Job Id for Control Group Generation
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
,      USER_STATUS_ID
,      STATUS_CODE
,      STATUS_DATE
,      GENERATION_TYPE
,      REPEAT_EXCLUDE_TYPE
,      ROW_SELECTION_TYPE
,      OWNER_USER_ID
,      CUSTOM_SETUP_ID
,      COUNTRY
,      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
,      QUANTUM
,      RELEASE_CONTROL_ALG_ID
,      RELEASE_STRATEGY
,      DIALING_METHOD
,      CALLING_CALENDAR_ID
,      CALLBACK_PRIORITY_FLAG
,      CALL_CENTER_READY_FLAG
,      PURGE_FLAG
,      QUOTA
,      QUOTA_RESET
,      RECYCLING_ALG_ID
,      PUBLIC_FLAG
,      LIST_CATEGORY
,      NO_OF_ROWS_PREV_CONTACTED
,      ROW_ID
,      PURPOSE_CODE
,      QUERY_TEMPLATE_ID
,      NO_OF_ROWS_FATIGUED
,      NO_OF_ROWS_SUPPRESSED
,      APPLY_TRAFFIC_COP
,      MIGRATION_DATE
,      TCA_FAILED_RECORDS
,      PARENT_LIST_HEADER_ID
,      SPLIT_TYPE
,      SPLIT_VALUE
,      SECURITY_GROUP_ID
,      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 APPS.AMS_LIST_HEADERS_VL;

Dependencies

[top of page]

APPS.AMS_LIST_HEADERS_VL references the following:

SchemaAPPS
SynonymAMS_LIST_HEADERS_ALL
SynonymAMS_LIST_HEADERS_ALL_TL
APPS.AMS_LIST_HEADERS_VL is referenced by following:

SchemaAPPS
Package BodyAMS_ACT_LIST_PVT - show dependent code
Package BodyAMS_CELL_INTEGRATE_PVT - show dependent code
Package BodyAMS_DMSELECTION_PVT - show dependent code
Package BodyAMS_GEN_SUP_LIST_PVT - show dependent code
Package BodyAMS_LISTGENERATION_PKG - show dependent code
Package BodyAMS_LISTHEADER_PVT - show dependent code
ViewAMS_LIST_ENTRIES_UWQ_V
Package BodyAMS_LIST_PURGE_PVT - show dependent code
Package BodyAMS_LIST_WF - show dependent code
Package BodyAMS_WFTRIG_PVT - show dependent code
ViewAST_PLIST_NAMES_UWQ_V
Package BodyAST_UWQ_PLISTS_CONTS_ENUMS_PVT - show dependent code
Package BodyAST_UWQ_PLISTS_OPPS_ENUMS_PVT - show dependent code
ViewIEC_G_AO_LISTS_V
ViewIES_AMS_LIST_HEADERS_V
ViewIEX_PLIST_NAMES_UWQ_V
ViewIEX_PLIST_ORGS_UWQ_V
ViewOZF_FUNDS_CUST_V