VIEW: AMS.AMS_LIST_HEADERS_ALL#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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