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_REP_CAMPAIGN_DETAILS_V

Object Details

Object Name:	IEC_G_REP_CAMPAIGN_DETAILS_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 of real-time report summary statistics for executing campaign schedules.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CAMPAIGN_ID	NUMBER		Yes	Campaign id.
STATUS_CODE	VARCHAR2	(30)	Yes	Status code.
RECORD_LOADED	NUMBER			Number of records loaded.
RECORD_CALLED_ONCE	NUMBER			Number of records called at least once.
RECORD_CALLED_ONCE_PERC	NUMBER			Percentage of records called at least once, based on records loaded.
RECORD_REMOVED	NUMBER			Number of records removed.
RECORD_REMOVED_PERC	NUMBER			Percentage of records removed, based on records loaded.
RECORD_REMAINING	NUMBER			Number of records remaining.
RECORD_REMAINING_PERC	NUMBER			Percentage of records remaining, based on records loaded.
RECORD_AVAILABLE	NUMBER			Number of records that are currently available for calling.
RECORD_AVAILABLE_PERC	NUMBER			Percentage of records available, based on records loaded.
RECORD_UNAVAILABLE	NUMBER			Number of records that are currently unavailable for calling.
RECORD_UNAVAILABLE_PERC	NUMBER			Percentage of records unavailable, based on records loaded.
PREDICTED_EXHAUSTION	DATE			Campaign schedule's predicted exhaustion time.

Query Text

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


SELECT CAMPAIGN_ID
,      STATUS_CODE
,      RECORD_LOADED
,      RECORD_CALLED_ONCE
,      RECORD_CALLED_ONCE_PERC
,      RECORD_REMOVED
,      RECORD_REMOVED_PERC
,      RECORD_REMAINING
,      RECORD_REMAINING_PERC
,      RECORD_AVAILABLE
,      RECORD_AVAILABLE_PERC
,      RECORD_UNAVAILABLE
,      RECORD_UNAVAILABLE_PERC
,      PREDICTED_EXHAUSTION
FROM APPS.IEC_G_REP_CAMPAIGN_DETAILS_V;

Dependencies

[top of page]

APPS.IEC_G_REP_CAMPAIGN_DETAILS_V references the following:

APPS: IEC_CLEANDIVISOR; IEC_GETPREDICTEDEXHAUSTION; IEC_G_CAMPAIGNS_V; IEC_G_REP_LIST_DETAILS_V

APPS.IEC_G_REP_CAMPAIGN_DETAILS_V is not referenced by any database object