View: AMS_LIST_HEADERS_VL

Product:	AMS - Marketing
Description:
Implementation/DBA Data:	APPS.AMS_LIST_HEADERS_VL

View Text

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')

Columns