eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: AMS.AMS_LIST_HEADERS_ALL#

Object Details

Object Name:	AMS_LIST_HEADERS_ALL#
Object Type:	VIEW
Owner:	AMS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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	(240)
LIST_USED_BY_ID	NUMBER		Yes
ARC_LIST_USED_BY	VARCHAR2	(30)	Yes
LIST_TYPE	VARCHAR2	(30)	Yes
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
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
SECURITY_GROUP_ID	NUMBER
USER_STATUS_ID	NUMBER
QUANTUM	NUMBER
RELEASE_CONTROL_ALG_ID	NUMBER
DIALING_METHOD	VARCHAR2	(30)
CALLING_CALENDAR_ID	NUMBER
RELEASE_STRATEGY	VARCHAR2	(30)
CUSTOM_SETUP_ID	NUMBER
COUNTRY	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
PURPOSE_CODE	VARCHAR2	(120)
NO_OF_ROWS_FATIGUED	NUMBER
NO_OF_ROWS_SUPPRESSED	NUMBER
QUERY_TEMPLATE_ID	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
CTRL_CONF_LEVEL	NUMBER
CTRL_REQ_RESP_RATE	NUMBER
CTRL_LIMIT_OF_ERROR	NUMBER
STATUS_CODE_OLD	VARCHAR2	(30)
CTRL_CONC_JOB_ID	NUMBER
CTRL_STATUS_CODE	VARCHAR2	(30)
CTRL_GEN_MODE	VARCHAR2	(30)
APPLY_SUPPRESSION_FLAG	VARCHAR2	(1)
REMOTE_GEN_FLAG	VARCHAR2	(1)
NO_OF_ROWS_INITIALLY_SELECTED	NUMBER
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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
,      STATUS_CODE
,      STATUS_DATE
,      GENERATION_TYPE
,      REPEAT_EXCLUDE_TYPE
,      ROW_SELECTION_TYPE
,      OWNER_USER_ID
,      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
,      SECURITY_GROUP_ID
,      USER_STATUS_ID
,      QUANTUM
,      RELEASE_CONTROL_ALG_ID
,      DIALING_METHOD
,      CALLING_CALENDAR_ID
,      RELEASE_STRATEGY
,      CUSTOM_SETUP_ID
,      COUNTRY
,      CALLBACK_PRIORITY_FLAG
,      CALL_CENTER_READY_FLAG
,      PURGE_FLAG
,      QUOTA
,      QUOTA_RESET
,      RECYCLING_ALG_ID
,      PUBLIC_FLAG
,      LIST_CATEGORY
,      NO_OF_ROWS_PREV_CONTACTED
,      PURPOSE_CODE
,      NO_OF_ROWS_FATIGUED
,      NO_OF_ROWS_SUPPRESSED
,      QUERY_TEMPLATE_ID
,      APPLY_TRAFFIC_COP
,      MIGRATION_DATE
,      TCA_FAILED_RECORDS
,      PARENT_LIST_HEADER_ID
,      SPLIT_TYPE
,      SPLIT_VALUE
,      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
,      ZD_EDITION_NAME
FROM AMS.AMS_LIST_HEADERS_ALL#;

Dependencies

[top of page]

AMS.AMS_LIST_HEADERS_ALL# references the following:

AMS: AMS_LIST_HEADERS_ALL

AMS.AMS_LIST_HEADERS_ALL# is referenced by following:

APPS: AMS_LIST_HEADERS_ALL; AMS_LIST_HEADERS_ALL+