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_SUBSET_DETAILS_V

Object Details

Object Name:	IEC_G_REP_SUBSET_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 subsets.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CAMPAIGN_ID	NUMBER	(15)		Campaign id.
CAMPAIGN_STATUS_CODE	VARCHAR2	(30)	Yes	Campaign status code.
SCHEDULE_ID	NUMBER	(15)	Yes	Campaign schedule id.
SCHEDULE_STATUS_CODE	VARCHAR2	(30)	Yes	Schedule status code.
LIST_HEADER_ID	NUMBER	(15)	Yes	List header id.
LIST_STATUS_CODE	VARCHAR2	(30)		List status code.
SUBSET_ID	NUMBER	(15)	Yes	Subset id.
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			Obsolete column.
RECORD_CALLED_AND_REMOVED	NUMBER			Obsolete column.

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
,      SUBSET_ID
,      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
,      RECORD_CALLED_AND_REMOVED
FROM APPS.IEC_G_REP_SUBSET_DETAILS_V;

Dependencies

[top of page]

APPS.IEC_G_REP_SUBSET_DETAILS_V references the following:

APPS: IEC_CLEANDIVISOR; IEC_G_AO_LISTS_V; IEC_G_CAMPAIGNS_V; IEC_G_LIST_SUBSETS; IEC_G_REP_SUBSET_AVAIL_RECS; IEC_G_REP_SUBSET_COUNTS; IEC_G_REP_SUBSET_UNAVAIL_RECS

APPS.IEC_G_REP_SUBSET_DETAILS_V is referenced by following:

APPS: IEC_G_REP_LIST_DETAILS_V