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: APPS.IEC_G_AO_LISTS_V

Object Details

Object Name:	IEC_G_AO_LISTS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LIST_NAME	VARCHAR2	(300)		The Name of the List.
LIST_HEADER_ID	NUMBER			UNIQUE IDENTIFIER
SOURCE_TYPE_CODE	VARCHAR2	(30)		stores the list source type.
LIST_STATUS	VARCHAR2	(30)		stores the list status code
SCHEDULE_NAME	VARCHAR2	(240)	Yes	stores the schedule name.
SCHEDULE_ID	NUMBER		Yes	stores the campaign schedule id.
SCHEDULE_STATUS	VARCHAR2	(30)	Yes	stores the schedule status code.
STATUS_CODE	VARCHAR2	(30)		stores the list status code
API_INITIATED_FLAG	VARCHAR2	(1)
LANGUAGE	VARCHAR2	(4)	Yes	stores the language.
CAMPAIGN_ID	NUMBER		Yes	stores the campaign id.
CAMPAIGN_NAME	VARCHAR2	(240)	Yes
DIALING_METHOD	VARCHAR2	(30)		Dialing Method
RELEASE_CONTROL_ALG_ID	NUMBER			Release Control Algorithm Id
RELEASE_STRATEGY	VARCHAR2	(30)		Release Strategy
CALLING_CALENDAR_ID	NUMBER			Calling Calendar id
RECYCLING_ALG_ID	NUMBER			Recycling Algorithm ID
QUOTA	NUMBER	(10)		Quota
QUOTA_RESET	NUMBER			Quota Reset time
CALL_CENTER_READY_FLAG	VARCHAR2	(1)		Call center ready flag
PREVIEW_TIME	NUMBER	(15)		Preview Time
EXECUTION_START_TIME	DATE			Time when AO begin execution on target group.
DISTRIBUTION_PRIORITY	VARCHAR2	(20)
DISTRIBUTION_WEIGHT	NUMBER
RESET_TIME	VARCHAR2	(30)
PREDICTIVE_TIMEOUT	VARCHAR2	(15)
ABANDON_LIMIT	VARCHAR2	(15)
AGENT_LINE_RATIO	NUMBER	(15)
START_DATE_TIME	DATE			Campaign Schedule start date
END_DATE_TIME	DATE			campaign schedule end date
DIALING_COMPLIANCE_RULE	VARCHAR2	(240)		Specifies which dialing compliance rule is in effect.
ENABLE_WITHDRAW_FLAG	VARCHAR2	(1)		Specifies whether calls may be withdrawn.
ENABLE_ABANDON_FLAG	VARCHAR2	(1)		Specifies whether calls may be abandoned.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LIST_NAME
,      LIST_HEADER_ID
,      SOURCE_TYPE_CODE
,      LIST_STATUS
,      SCHEDULE_NAME
,      SCHEDULE_ID
,      SCHEDULE_STATUS
,      STATUS_CODE
,      API_INITIATED_FLAG
,      LANGUAGE
,      CAMPAIGN_ID
,      CAMPAIGN_NAME
,      DIALING_METHOD
,      RELEASE_CONTROL_ALG_ID
,      RELEASE_STRATEGY
,      CALLING_CALENDAR_ID
,      RECYCLING_ALG_ID
,      QUOTA
,      QUOTA_RESET
,      CALL_CENTER_READY_FLAG
,      PREVIEW_TIME
,      EXECUTION_START_TIME
,      DISTRIBUTION_PRIORITY
,      DISTRIBUTION_WEIGHT
,      RESET_TIME
,      PREDICTIVE_TIMEOUT
,      ABANDON_LIMIT
,      AGENT_LINE_RATIO
,      START_DATE_TIME
,      END_DATE_TIME
,      DIALING_COMPLIANCE_RULE
,      ENABLE_WITHDRAW_FLAG
,      ENABLE_ABANDON_FLAG
FROM APPS.IEC_G_AO_LISTS_V;

Dependencies

[top of page]

APPS.IEC_G_AO_LISTS_V references the following:

APPS: AMS_ACT_LISTS; AMS_CAMPAIGNS_ALL_TL; AMS_CAMPAIGN_SCHEDULES_B; AMS_CAMPAIGN_SCHEDULES_TL; AMS_LIST_HEADERS_VL; IEC_G_LIST_RT_INFO

APPS.IEC_G_AO_LISTS_V is referenced by following:

APPS: IEC_AO_CAMPAIGN_LIST_V; IEC_AVAILABLE_RECORDS_V; IEC_G_EXECUTING_LISTS_V; IEC_G_REP_LIST_DETAILS_V; IEC_G_REP_SUBSET_DETAILS_V; IEC_O_LISTS_TO_ACTIVATE_V; IEC_O_LISTS_TO_COPY_V; IEC_O_LISTS_TO_PURGE_V; IEC_O_LISTS_TO_STOP_V; IEC_O_LISTS_TO_VALIDATE_V; IEC_O_VALIDATING_LISTS_V; IEC_O_VALIDATION_REPORT_SUMM_V