[Home] [Help] [Dependency Information]
Object Name: | AMS_LIST_HEADERS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_LIST_HEADERS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
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 |
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;
|
|
|