VIEW: APPS.AMS_LIST_HEADERS_VL

Source

View Text - Preformatted

SELECT lh.LIST_HEADER_ID , lh.LAST_UPDATE_DATE , lh.LAST_UPDATED_BY , lh.CREATION_DATE , lh.CREATED_BY , lh.LAST_UPDATE_LOGIN , lh.OBJECT_VERSION_NUMBER , lh.REQUEST_ID , lh.PROGRAM_ID , lh.PROGRAM_APPLICATION_ID , lh.PROGRAM_UPDATE_DATE , lh.VIEW_APPLICATION_ID , lt.LIST_NAME , lh.LIST_USED_BY_ID , lh.ARC_LIST_USED_BY , lh.LIST_TYPE , lh.user_status_id , lh.STATUS_CODE , lh.STATUS_DATE , lh.GENERATION_TYPE , lh.REPEAT_EXCLUDE_TYPE , lh.ROW_SELECTION_TYPE , lh.OWNER_USER_ID , lh.custom_setup_id , lh.country , lh.ACCESS_LEVEL , lh.ENABLE_LOG_FLAG , lh.ENABLE_WORD_REPLACEMENT_FLAG , lh.ENABLE_PARALLEL_DML_FLAG , lh.DEDUPE_DURING_GENERATION_FLAG , lh.GENERATE_CONTROL_GROUP_FLAG , lh.LAST_GENERATION_SUCCESS_FLAG , lh.FORECASTED_START_DATE , lh.FORECASTED_END_DATE , lh.ACTUAL_END_DATE , lh.SENT_OUT_DATE , lh.DEDUPE_START_DATE , lh.LAST_DEDUPE_DATE , lh.LAST_DEDUPED_BY_USER_ID , lh.WORKFLOW_ITEM_KEY , lh.NO_OF_ROWS_DUPLICATES , lh.NO_OF_ROWS_MIN_REQUESTED , lh.NO_OF_ROWS_MAX_REQUESTED , lh.NO_OF_ROWS_IN_LIST , lh.NO_OF_ROWS_IN_CTRL_GROUP , lh.NO_OF_ROWS_ACTIVE , lh.NO_OF_ROWS_INACTIVE , lh.NO_OF_ROWS_MANUALLY_ENTERED , lh.NO_OF_ROWS_DO_NOT_CALL , lh.NO_OF_ROWS_DO_NOT_MAIL , lh.NO_OF_ROWS_RANDOM , lh.ORG_ID , lh.MAIN_GEN_START_TIME , lh.MAIN_GEN_END_TIME , lh.MAIN_RANDOM_NTH_ROW_SELECTION , lh.MAIN_RANDOM_PCT_ROW_SELECTION , lh.CTRL_RANDOM_NTH_ROW_SELECTION , lh.CTRL_RANDOM_PCT_ROW_SELECTION , lh.REPEAT_SOURCE_LIST_HEADER_ID , lh.RESULT_TEXT , lh.KEYWORDS , lt.DESCRIPTION , lh.LIST_PRIORITY , lh.ASSIGN_PERSON_ID , lh.LIST_SOURCE , lh.LIST_SOURCE_TYPE , lh.LIST_ONLINE_FLAG , lh.RANDOM_LIST_ID , lh.ENABLED_FLAG , lh.ASSIGNED_TO , lh.QUERY_ID , lh.OWNER_PERSON_ID , lh.ARCHIVED_BY , lh.ARCHIVED_DATE , lh.ATTRIBUTE_CATEGORY , lh.ATTRIBUTE1 , lh.ATTRIBUTE2 , lh.ATTRIBUTE3 , lh.ATTRIBUTE4 , lh.ATTRIBUTE5 , lh.ATTRIBUTE6 , lh.ATTRIBUTE7 , lh.ATTRIBUTE8 , lh.ATTRIBUTE9 , lh.ATTRIBUTE10 , lh.ATTRIBUTE11 , lh.ATTRIBUTE12 , lh.ATTRIBUTE13 , lh.ATTRIBUTE14 , lh.ATTRIBUTE15 , lh.TIMEZONE_ID , lh.USER_ENTERED_START_TIME , lh.quantum , lh.release_control_alg_id , lh.release_strategy , lh.dialing_method , lh.calling_calendar_id , lh.callback_priority_flag , lh.call_center_ready_flag, lh.purge_flag, lh.quota, lh.quota_reset, lh.recycling_alg_id, lh.public_flag , lh.LIST_CATEGORY, lh.no_of_rows_prev_contacted, lh.ROWID, lh.PURPOSE_CODE, lh.QUERY_TEMPLATE_ID, lh.NO_OF_ROWS_FATIGUED, lh.NO_OF_ROWS_SUPPRESSED, lh.APPLY_TRAFFIC_COP, lh.migration_date, lh.tca_failed_records, lh.parent_list_header_id, lh.Split_type, lh.split_value, lh.security_group_id, lh.CTRL_CONF_LEVEL, lh.CTRL_REQ_RESP_RATE, lh.CTRL_LIMIT_OF_ERROR , lh.STATUS_CODE_OLD, lh.CTRL_CONC_JOB_ID , lh.CTRL_STATUS_CODE , lh.CTRL_GEN_MODE, lh.apply_suppression_flag, lh.REMOTE_GEN_FLAG, lh.NO_OF_ROWS_INITIALLY_SELECTED from ams_list_headers_all lh, ams_list_headers_all_tl lt WHERE lh.list_header_id = lt.list_header_id and lt.language = userenv('LANG')

View Text - HTML Formatted

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