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_SCHEDULES_V

Object Details

Object Name:	IEC_G_SCHEDULES_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 created to retrieve only campaign activities that have been assigned Advanced Outbound.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SCHEDULE_ID	NUMBER		Yes	SCHEDULE_ID
SCHEDULE_NAME	VARCHAR2	(240)	Yes	SCHEDULE_NAME
DESCRIPTION	VARCHAR2	(4000)		DESCRIPTION
USER_STATUS_ID	NUMBER		Yes	USER_STATUS_ID
STATUS_CODE	VARCHAR2	(30)	Yes	STATUS_CODE
ACTIVITY_ID	NUMBER			ACTIVITY_ID
CALENDAR_ID	VARCHAR2	(150)		CALENDAR_ID
RECYCLING_ALGORITHM_ID	VARCHAR2	(150)		RECYCLING_ALGORITHM_ID
RELEASE_ALGORITHM_ID	VARCHAR2	(150)		RELEASE_ALGORITHM_ID
DIALING_METHOD	VARCHAR2	(150)		DIALING_METHOD
ABANDON_LIMIT	VARCHAR2	(150)		ABANDON_LIMIT
CALL_CENTER_READY_FLAG	VARCHAR2	(150)		CALL_CENTER_READY_FLAG
PREDICTIVE_PACING_CLASS	VARCHAR2	(150)		PREDICTIVE_PACING_CLASS
PREDICTIVE_TIMEOUT	VARCHAR2	(150)		PREDICTIVE_TIMEOUT
ACTIVE_FLAG	VARCHAR2	(1)	Yes	ACTIVE_FLAG
SOURCE_CODE	VARCHAR2	(30)	Yes	SOURCE_CODE
START_DATE_TIME	DATE			START_DATE_TIME
END_DATE_TIME	DATE			END_DATE_TIME
CAMPAIGN_ID	NUMBER		Yes	CAMPAIGN_ID
CAMPAIGN_NAME	VARCHAR2	(240)	Yes	CAMPAIGN_NAME
MARKETING_MEDIUM_ID	NUMBER			MARKETING_MEDIUM_ID
LAST_UPDATE_DATE	DATE		Yes	LAST_UPDATE_DATE
LAST_UPDATE_BY	NUMBER	(15)	Yes	LAST_UPDATE_BY
CREATION_DATE	DATE		Yes	CREATION_DATE
CREATED_BY	NUMBER	(15)	Yes	CREATED_BY
LAST_UPDATE_LOGIN	NUMBER	(15)		LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER	NUMBER	(9)		OBJECT_VERSION_NUMBER
OWNER_USER_ID	NUMBER		Yes	OWNER_USER_ID
LANGUAGE	VARCHAR2	(4)	Yes	LANGUAGE
NAME	VARCHAR2	(120)		NAME

Query Text

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


SELECT SCHEDULE_ID
,      SCHEDULE_NAME
,      DESCRIPTION
,      USER_STATUS_ID
,      STATUS_CODE
,      ACTIVITY_ID
,      CALENDAR_ID
,      RECYCLING_ALGORITHM_ID
,      RELEASE_ALGORITHM_ID
,      DIALING_METHOD
,      ABANDON_LIMIT
,      CALL_CENTER_READY_FLAG
,      PREDICTIVE_PACING_CLASS
,      PREDICTIVE_TIMEOUT
,      ACTIVE_FLAG
,      SOURCE_CODE
,      START_DATE_TIME
,      END_DATE_TIME
,      CAMPAIGN_ID
,      CAMPAIGN_NAME
,      MARKETING_MEDIUM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATE_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      OWNER_USER_ID
,      LANGUAGE
,      NAME
FROM APPS.IEC_G_SCHEDULES_V;

Dependencies

[top of page]

APPS.IEC_G_SCHEDULES_V references the following:

APPS: AMS_CAMPAIGNS_ALL_TL; AMS_CAMPAIGN_SCHEDULES_B; AMS_CAMPAIGN_SCHEDULES_TL; AMS_USER_STATUSES_TL

APPS.IEC_G_SCHEDULES_V is referenced by following:

APPS: IEC_REPORTS_UTIL_PVT - show dependent code