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_SUBSET_RT_INFO

Object Details

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

Stores release strategy information for a particular list

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEC_G_SUBSET_RT_INFO_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUBSET_RT_INFO_ID
IEC_G_SUBSET_RT_INFO_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LIST_SUBSET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SUBSET_RT_INFO_ID	NUMBER	(15)	Yes	Unique Identifier
LIST_SUBSET_ID	NUMBER	(15)	Yes	Foreign key to IEC_G_LIST_SUBSETS.
WORKING_QUANTUM	NUMBER			Used to dynamically control the release strategy.
WORKING_QUOTA	NUMBER			Used to dynamically control the release strategy for this subset.
CACHE_AMT_TAKEN	NUMBER	(10)		The number of entries that we predict are currently necessary in the OAO cache for this subset to support the predictive server.
TOTAL_CACHE_COUNT	NUMBER	(10)		The current number of callable entries in the OAO list entry cache.
QUOTA_RESET_TIME	DATE			Dateand time to reset the quota.
RT_QUOTA_COUNT	NUMBER	(15)		Run time quota count.
CACHE_AMT_NEEDED	NUMBER	(10)		The number of entries that we predict are currently necessary in the OAO cache for this subset to support the predictive server.
VALID_FLAG	VARCHAR2	(1)		Whether the subset is valid in relation to the list status.
USE_FLAG	VARCHAR2	(1)		Whether predictive should attempt to retrieve entries from this subset due to the subset no having any entries left.
CALLABLE_FLAG	VARCHAR2	(1)		Whether predictive should use this flag or not determined by the calling calendars of the list and schedule that this subset belongs to.
REFRESHED_FLAG	VARCHAR2	(1)		Whether the cache has been refreshed since the last prefetch.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
SECURITY_GROUP_ID	NUMBER	(15)		Used in hosted environments.
STATUS_CODE	VARCHAR2	(10)		Used for soft deletes.
LOAD_PRIORITY	NUMBER			Load priority of this subset.

Query Text

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


SELECT SUBSET_RT_INFO_ID
,      LIST_SUBSET_ID
,      WORKING_QUANTUM
,      WORKING_QUOTA
,      CACHE_AMT_TAKEN
,      TOTAL_CACHE_COUNT
,      QUOTA_RESET_TIME
,      RT_QUOTA_COUNT
,      CACHE_AMT_NEEDED
,      VALID_FLAG
,      USE_FLAG
,      CALLABLE_FLAG
,      REFRESHED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      SECURITY_GROUP_ID
,      STATUS_CODE
,      LOAD_PRIORITY
FROM IEC.IEC_G_SUBSET_RT_INFO;

Dependencies

[top of page]

IEC.IEC_G_SUBSET_RT_INFO does not reference any database object

IEC.IEC_G_SUBSET_RT_INFO is referenced by following:

APPS: IEC_G_SUBSET_RT_INFO