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]

TABLE: IEC.IEC_G_AVAIL_RECORDS_COUNT

Object Details

Object Name:	IEC_G_AVAIL_RECORDS_COUNT
Object Type:	TABLE
Owner:	IEC
Subobject Name:
Status:	VALID

Stores the count of currently callable list entries for a campaign schedule.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
SCHEDULE_ID	NUMBER	(15)	Yes	Foreign key to ams_campaign_schedules_b
LIST_HEADER_ID	NUMBER	(15)	Yes	LIST_HEADER_ID is the Foreign Key to the marketing AMS_LIST_HEADERS_ALL table.
SECURITY_GROUP_ID	NUMBER	(15)		Used in hosted environments.
CURR_CP_TIME_ZONE	NUMBER		Yes	Time zone of the current phone number.
CURR_CP_COUNTRY_CODE	VARCHAR2	(240)	Yes	Country code of the current phone number.
AVAILABLE_COUNT	NUMBER	(15)		Stores the currently available records in a campaign

Query Text

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


SELECT SCHEDULE_ID
,      LIST_HEADER_ID
,      SECURITY_GROUP_ID
,      CURR_CP_TIME_ZONE
,      CURR_CP_COUNTRY_CODE
,      AVAILABLE_COUNT
FROM IEC.IEC_G_AVAIL_RECORDS_COUNT;

Dependencies

[top of page]

IEC.IEC_G_AVAIL_RECORDS_COUNT does not reference any database object

IEC.IEC_G_AVAIL_RECORDS_COUNT is referenced by following:

APPS: IEC_G_AVAIL_RECORDS_COUNT