[Home] [Help]
[Dependency Information]
[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;
APPS
AMS_LIST_HEADERS_ALL
AMS_LIST_HEADERS_ALL_TL
APPS
AMS_ACT_LIST_PVT
- show dependent code
AMS_CELL_INTEGRATE_PVT
- show dependent code
AMS_DMSELECTION_PVT
- show dependent code
AMS_GEN_SUP_LIST_PVT
- show dependent code
AMS_LISTGENERATION_PKG
- show dependent code
AMS_LISTHEADER_PVT
- show dependent code
AMS_LIST_ENTRIES_UWQ_V
AMS_LIST_PURGE_PVT
- show dependent code
AMS_LIST_WF
- show dependent code
AMS_WFTRIG_PVT
- show dependent code
AST_PLIST_NAMES_UWQ_V
AST_UWQ_PLISTS_CONTS_ENUMS_PVT
- show dependent code
AST_UWQ_PLISTS_OPPS_ENUMS_PVT
- show dependent code
IEC_G_AO_LISTS_V
IES_AMS_LIST_HEADERS_V
IEX_PLIST_NAMES_UWQ_V
IEX_PLIST_ORGS_UWQ_V
OZF_FUNDS_CUST_V
|
|
|
|