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_EXECUTING_LISTS_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

View used to retrieve all of the AO lists that are currently executing.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LIST_HEADER_ID	NUMBER			List Header Id.
SCHEDULE_ID	NUMBER		Yes	Schedule Id.
CAMPAIGN_ID	NUMBER		Yes	campaign Id
RELEASE_CONTROL_ALG_ID	NUMBER			List record filter.
DIALING_METHOD	VARCHAR2	(30)		List dialing method.
RELEASE_STRATEGY	VARCHAR2	(30)		List release strategy.
CALLING_CALENDAR_ID	NUMBER			List calling calendar id.
SOURCE_TYPE_CODE	VARCHAR2	(30)		List source type.
QUOTA	NUMBER	(10)		List quota.
QUOTA_RESET	NUMBER			Quota Reset time
RECYCLING_ALG_ID	NUMBER			List recycling algorithm id.
PREVIEW_TIME	NUMBER	(15)		Preview Time
DISTRIBUTION_PRIORITY	VARCHAR2	(20)		Distribution Priority
DISTRIBUTION_WEIGHT	NUMBER			Distribution Weight
RESET_TIME	VARCHAR2	(30)		Reset Time
PREDICTIVE_TIMEOUT	VARCHAR2	(15)		Predictive Timeout
ABANDON_LIMIT	VARCHAR2	(15)		Abandon Limit
AGENT_LINE_RATIO	NUMBER	(15)		Agent Line Ratio
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_HEADER_ID
,      SCHEDULE_ID
,      CAMPAIGN_ID
,      RELEASE_CONTROL_ALG_ID
,      DIALING_METHOD
,      RELEASE_STRATEGY
,      CALLING_CALENDAR_ID
,      SOURCE_TYPE_CODE
,      QUOTA
,      QUOTA_RESET
,      RECYCLING_ALG_ID
,      PREVIEW_TIME
,      DISTRIBUTION_PRIORITY
,      DISTRIBUTION_WEIGHT
,      RESET_TIME
,      PREDICTIVE_TIMEOUT
,      ABANDON_LIMIT
,      AGENT_LINE_RATIO
,      DIALING_COMPLIANCE_RULE
,      ENABLE_WITHDRAW_FLAG
,      ENABLE_ABANDON_FLAG
FROM APPS.IEC_G_EXECUTING_LISTS_V;

Dependencies

[top of page]

APPS.IEC_G_EXECUTING_LISTS_V references the following:

APPS: IEC_G_AO_LISTS_V; IEC_G_CAMPAIGNS_V

APPS.IEC_G_EXECUTING_LISTS_V is referenced by following:

APPS: IEC_AO_CAMPAIGN_LIST_V; IEC_BLNDG_SCH_REC_COUNT_V; IEC_CPN_RLSE_STTGY_PVT - show dependent code; IEC_CPN_RLSE_STTGY_PVT - show dependent code; IEC_G_EXECUTING_CAMPAIGNS_V; IEC_RECOVER_PVT - show dependent code; IEC_REPORTS_UTIL_PVT - show dependent code; IEU_PVT - show dependent code