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: IEC.IEC_G_LIST_RT_INFO#

Object Details

Object Name:	IEC_G_LIST_RT_INFO#
Object Type:	VIEW
Owner:	IEC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
LIST_RT_INFO_ID	NUMBER	(15)	Yes
LIST_HEADER_ID	NUMBER	(15)	Yes
WORKING_QUANTUM	NUMBER	(7)
WORKING_QUOTA	NUMBER	(7)
QUOTA_RESET_TIME	DATE
CACHE_AMT_TAKEN	NUMBER	(10)
TOTAL_CACHE_COUNT	NUMBER	(10)
RT_QUOTA_COUNT	NUMBER	(15)
CACHE_AMT_NEEDED	NUMBER	(10)
VALID_FLAG	VARCHAR2	(1)
USE_FLAG	VARCHAR2	(1)
CALLABLE_FLAG	VARCHAR2	(1)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
SECURITY_GROUP_ID	NUMBER	(15)
EXECUTION_START_TIME	DATE
TRANSITION_STATUS	VARCHAR2	(1)
CAMPAIGN_ID	NUMBER	(15)	Yes
CAMPAIGN_SCHEDULE_ID	NUMBER	(15)
STATUS_CODE	VARCHAR2	(30)
DIALING_METHOD	VARCHAR2	(30)
RELEASE_CONTROL_ALG_ID	NUMBER
RELEASE_STRATEGY	VARCHAR2	(30)
QUANTUM	NUMBER
CALLING_CALENDAR_ID	NUMBER
RECYCLING_ALG_ID	NUMBER
QUOTA	NUMBER	(10)
QUOTA_RESET	NUMBER
CALL_CENTER_READY_FLAG	VARCHAR2	(1)
PREVIEW_TIME	NUMBER	(15)
DISTRIBUTION_PRIORITY	VARCHAR2	(20)
DISTRIBUTION_WEIGHT	NUMBER
VALIDATION_RULE_ID	NUMBER
VALIDATION_ACTION_BLOCK_ID	NUMBER
RESET_TIME	VARCHAR2	(30)
PREDICTIVE_TIMEOUT	VARCHAR2	(15)
ABANDON_LIMIT	VARCHAR2	(15)
AGENT_LINE_RATIO	NUMBER	(15)
PARAMS_INHERITED_FLAG	VARCHAR2	(1)
STRATEGY_RELEASED	NUMBER	(15)
STRATEGY_UPDATE_DATE	DATE
SERVER_DISTRIBUTION_WEIGHT	NUMBER
SERVER_DISTRIBUTION_PRIORITY	VARCHAR2	(20)
DIALING_COMPLIANCE_RULE	VARCHAR2	(240)
ENABLE_WITHDRAW_FLAG	VARCHAR2	(1)
ENABLE_ABANDON_FLAG	VARCHAR2	(1)
API_INITIATED_FLAG	VARCHAR2	(1)

Query Text

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


SELECT LIST_RT_INFO_ID
,      LIST_HEADER_ID
,      WORKING_QUANTUM
,      WORKING_QUOTA
,      QUOTA_RESET_TIME
,      CACHE_AMT_TAKEN
,      TOTAL_CACHE_COUNT
,      RT_QUOTA_COUNT
,      CACHE_AMT_NEEDED
,      VALID_FLAG
,      USE_FLAG
,      CALLABLE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      EXECUTION_START_TIME
,      TRANSITION_STATUS
,      CAMPAIGN_ID
,      CAMPAIGN_SCHEDULE_ID
,      STATUS_CODE
,      DIALING_METHOD
,      RELEASE_CONTROL_ALG_ID
,      RELEASE_STRATEGY
,      QUANTUM
,      CALLING_CALENDAR_ID
,      RECYCLING_ALG_ID
,      QUOTA
,      QUOTA_RESET
,      CALL_CENTER_READY_FLAG
,      PREVIEW_TIME
,      DISTRIBUTION_PRIORITY
,      DISTRIBUTION_WEIGHT
,      VALIDATION_RULE_ID
,      VALIDATION_ACTION_BLOCK_ID
,      RESET_TIME
,      PREDICTIVE_TIMEOUT
,      ABANDON_LIMIT
,      AGENT_LINE_RATIO
,      PARAMS_INHERITED_FLAG
,      STRATEGY_RELEASED
,      STRATEGY_UPDATE_DATE
,      SERVER_DISTRIBUTION_WEIGHT
,      SERVER_DISTRIBUTION_PRIORITY
,      DIALING_COMPLIANCE_RULE
,      ENABLE_WITHDRAW_FLAG
,      ENABLE_ABANDON_FLAG
,      API_INITIATED_FLAG
FROM IEC.IEC_G_LIST_RT_INFO#;

Dependencies

[top of page]

IEC.IEC_G_LIST_RT_INFO# references the following:

IEC: IEC_G_LIST_RT_INFO

IEC.IEC_G_LIST_RT_INFO# is referenced by following:

APPS: IEC_G_LIST_RT_INFO