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_LIST_DETAILS_V

Object Details

Object Name:	IEC_G_REP_LIST_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 target groups.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CAMPAIGN_ID	NUMBER		Yes	Campaign id.
CAMPAIGN_STATUS_CODE	VARCHAR2	(30)	Yes	Campaign status code.
SCHEDULE_ID	NUMBER		Yes	Campaign schedule id.
SCHEDULE_STATUS_CODE	VARCHAR2	(30)	Yes	Schedule status code.
LIST_HEADER_ID	NUMBER			List header id.
LIST_STATUS_CODE	VARCHAR2	(30)		List status code.
DIALING_METHOD	VARCHAR2	(30)		List's dialing method.
RECORD_LOADED	NUMBER			Number of records loaded.
RECORD_VALID_ALL_CPS	NUMBER			Records Valid All Contact Points
RECORD_VALID_SOME_CPS	NUMBER			Records Valid Some Contact Points
RECORD_INVALID	NUMBER			Records Invalid
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			List's predicted exhaustion time.

Query Text

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


SELECT CAMPAIGN_ID
,      CAMPAIGN_STATUS_CODE
,      SCHEDULE_ID
,      SCHEDULE_STATUS_CODE
,      LIST_HEADER_ID
,      LIST_STATUS_CODE
,      DIALING_METHOD
,      RECORD_LOADED
,      RECORD_VALID_ALL_CPS
,      RECORD_VALID_SOME_CPS
,      RECORD_INVALID
,      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_LIST_DETAILS_V;

Dependencies

[top of page]

APPS.IEC_G_REP_LIST_DETAILS_V references the following:

APPS: IEC_CLEANDIVISOR; IEC_GETPREDICTEDEXHAUSTION; IEC_G_AO_LISTS_V; IEC_G_CAMPAIGNS_V; IEC_G_REP_SUBSET_DETAILS_V; IEC_O_VALIDATION_REPORT_DETS

APPS.IEC_G_REP_LIST_DETAILS_V is referenced by following:

APPS: IEC_G_REP_CAMPAIGN_DETAILS_V