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: APPS.BIX_AI_CALL_DETAILS_MV

Object Details

Object Name:	BIX_AI_CALL_DETAILS_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.BIX_AI_CALL_DETAILS_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP$_BIX_AI_CALL_DETAIL	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("TIME_ID") SYS_OP_MAP_NONNULL("PERIOD_TYPE_ID") SYS_OP_MAP_NONNULL("PERIOD_START_DATE") SYS_OP_MAP_NONNULL("PERIOD_START_TIME") SYS_OP_MAP_NONNULL("MEDIA_ITEM_TYPE") SYS_OP_MAP_NONNULL("SERVER_GROUP_ID") SYS_OP_MAP_NONNULL("CLASSIFICATION_VALUE") SYS_OP_MAP_NONNULL("OUTCOME_ID") SYS_OP_MAP_NONNULL("RESULT_ID") SYS_OP_MAP_NONNULL("REASON_ID") SYS_OP_MAP_NONNULL("DNIS_NAME") SYS_OP_MAP_NONNULL("RESOURCE_ID") SYS_OP_MAP_NONNULL("PARTY_ID") SYS_OP_MAP_NONNULL("G_ID")
BIX_AI_CALL_DETAILS_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ROW_TYPE TIME_ID PERIOD_TYPE_ID CLASSIFICATION_VALUE DNIS_NAME SERVER_GROUP_ID RESOURCE_ID
BIX_AI_CALL_DETAILS_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ROW_TYPE TIME_ID PERIOD_TYPE_ID DNIS_NAME SERVER_GROUP_ID RESOURCE_ID
BIX_AI_CALL_DETAILS_MV_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ROW_TYPE TIME_ID PERIOD_TYPE_ID SERVER_GROUP_ID RESOURCE_ID
BIX_AI_CALL_DETAILS_MV_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ROW_TYPE TIME_ID PERIOD_TYPE_ID RESOURCE_ID

Columns

Name	Datatype	Length
G_ID	NUMBER
ROW_TYPE	VARCHAR2	(4)
TIME_ID	NUMBER
PERIOD_TYPE_ID	NUMBER
PERIOD_START_DATE	DATE
PERIOD_START_TIME	VARCHAR2	(5)
MEDIA_ITEM_TYPE	VARCHAR2	(80)
CLASSIFICATION_VALUE	VARCHAR2	(64)
DNIS_NAME	VARCHAR2	(30)
SERVER_GROUP_ID	NUMBER
RESOURCE_ID	NUMBER
OUTCOME_ID	NUMBER
RESULT_ID	NUMBER
REASON_ID	NUMBER
PARTY_ID	NUMBER
CALL_CALLS_OFFERED_TOTAL	NUMBER
CALLS_OFFERED_TOTAL_XCNT	NUMBER
CALL_CALLS_OFFERED_ABOVE_TH	NUMBER
CALLS_OFFERED_ABOVE_TH_XCNT	NUMBER
CALL_CALLS_HANDLED_TOTAL	NUMBER
CALLS_HANDLED_TOTAL_XCNT	NUMBER
CALL_CALLS_HANDLED_ABOVE_TH	NUMBER
CALLS_HANDLED_ABOVE_TH_XCNT	NUMBER
CALL_CALLS_ABANDONED	NUMBER
CALLS_ABANDONED_XCNT	NUMBER
CALL_CALLS_TRANSFERRED	NUMBER
CALLS_TRANSFERRED_XCNT	NUMBER
CALL_IVR_TIME	NUMBER
IVR_TIME_XCNT	NUMBER
CALL_ROUTE_TIME	NUMBER
ROUTE_TIME_XCNT	NUMBER
CALL_QUEUE_TIME	NUMBER
QUEUE_TIME_XCNT	NUMBER
CALL_TOT_QUEUE_TO_ABANDON	NUMBER
TOT_QUEUE_TO_ABANDON_XCNT	NUMBER
CALL_TOT_QUEUE_TO_ANSWER	NUMBER
TOT_QUEUE_TO_ANSWER_XCNT	NUMBER
CALL_TALK_TIME	NUMBER
TALK_TIME_XCNT	NUMBER
CALL_CONT_CALLS_OFFERED_NA	NUMBER
CONT_CALLS_OFFERED_NA_XCNT	NUMBER
CALL_CONT_CALLS_HANDLED_TOT_NA	NUMBER
CONT_CALLS_HANDLED_TOT_NA_XCNT	NUMBER
AGENT_TALK_TIME_NAC	NUMBER
TALK_TIME_NAC_XCNT	NUMBER
AGENT_WRAP_TIME_NAC	NUMBER
WRAP_TIME_NAC_XCNT	NUMBER
AGENT_CALLS_TRAN_CONF_TO_NAC	NUMBER
CALLS_TRAN_CONF_TO_NAC_XCNT	NUMBER
AGENT_CALLS_HANDLED_TOTAL	NUMBER
AGENT_HANDLED_TOTAL_XCNT	NUMBER
AGENT_CALLS_HANDLED_ABOVE_TH	NUMBER
AGENT_HANDLED_ABOVE_TH_XCNT	NUMBER
AGENT_CALLS_ANSWERED_BY_GOAL	NUMBER
AGENT_ANSWERED_BY_GOAL_XCNT	NUMBER
AGENT_SR_CREATED	NUMBER
SR_CREATED_XCNT	NUMBER
AGENT_LEADS_CREATED	NUMBER
LEADS_CREATED_XCNT	NUMBER
AGENT_LEADS_AMOUNT	NUMBER
LEADS_AMOUNT_XCNT	NUMBER
AGENT_LEADS_CONVERTED_TO_OPP	NUMBER
LEADS_CONVERTED_TO_OPP_XCNT	NUMBER
AGENT_OPPORTUNITIES_CREATED	NUMBER
OPPORTUNITIES_CREATED_XCNT	NUMBER
AGENT_OPPORTUNITIES_WON	NUMBER
OPPORTUNITIES_WON_XCNT	NUMBER
AGENT_OPPORTUNITIES_WON_AMOUNT	NUMBER
OPPORTUNITIES_WON_AMOUNT_XCNT	NUMBER
AGENT_OPPORTUNITIES_CROSS_SOLD	NUMBER
OPPORTUNITIES_CROSS_SOLD_XCNT	NUMBER
AGENT_OPPORTUNITIES_UP_SOLD	NUMBER
OPPORTUNITIES_UP_SOLD_XCNT	NUMBER
AGENT_OPPORTUNITIES_DECLINED	NUMBER
OPPORTUNITIES_DECLINED_XCNT	NUMBER
AGENT_OPPORTUNITIES_LOST	NUMBER
OPPORTUNITIES_LOST_XCNT	NUMBER
AGENT_PREVIEW_TIME	NUMBER
PREVIEW_TIME_XCNT	NUMBER
AGENTCALL_ORR_COUNT	NUMBER
CALL_ORR_COUNT_XCNT	NUMBER
AGENTCALL_PR_COUNT	NUMBER
CALL_PR_COUNT_XCNT	NUMBER
AGENT_CONT_CALLS_HAND_NA	NUMBER
CONT_CALLS_HAND_NA_XCNT	NUMBER
AGENT_CONT_CALLS_TC_NA	NUMBER
CONT_CALLS_TC_NA_XCNT	NUMBER
XCNT	NUMBER

Query Text

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


SELECT G_ID
,      ROW_TYPE
,      TIME_ID
,      PERIOD_TYPE_ID
,      PERIOD_START_DATE
,      PERIOD_START_TIME
,      MEDIA_ITEM_TYPE
,      CLASSIFICATION_VALUE
,      DNIS_NAME
,      SERVER_GROUP_ID
,      RESOURCE_ID
,      OUTCOME_ID
,      RESULT_ID
,      REASON_ID
,      PARTY_ID
,      CALL_CALLS_OFFERED_TOTAL
,      CALLS_OFFERED_TOTAL_XCNT
,      CALL_CALLS_OFFERED_ABOVE_TH
,      CALLS_OFFERED_ABOVE_TH_XCNT
,      CALL_CALLS_HANDLED_TOTAL
,      CALLS_HANDLED_TOTAL_XCNT
,      CALL_CALLS_HANDLED_ABOVE_TH
,      CALLS_HANDLED_ABOVE_TH_XCNT
,      CALL_CALLS_ABANDONED
,      CALLS_ABANDONED_XCNT
,      CALL_CALLS_TRANSFERRED
,      CALLS_TRANSFERRED_XCNT
,      CALL_IVR_TIME
,      IVR_TIME_XCNT
,      CALL_ROUTE_TIME
,      ROUTE_TIME_XCNT
,      CALL_QUEUE_TIME
,      QUEUE_TIME_XCNT
,      CALL_TOT_QUEUE_TO_ABANDON
,      TOT_QUEUE_TO_ABANDON_XCNT
,      CALL_TOT_QUEUE_TO_ANSWER
,      TOT_QUEUE_TO_ANSWER_XCNT
,      CALL_TALK_TIME
,      TALK_TIME_XCNT
,      CALL_CONT_CALLS_OFFERED_NA
,      CONT_CALLS_OFFERED_NA_XCNT
,      CALL_CONT_CALLS_HANDLED_TOT_NA
,      CONT_CALLS_HANDLED_TOT_NA_XCNT
,      AGENT_TALK_TIME_NAC
,      TALK_TIME_NAC_XCNT
,      AGENT_WRAP_TIME_NAC
,      WRAP_TIME_NAC_XCNT
,      AGENT_CALLS_TRAN_CONF_TO_NAC
,      CALLS_TRAN_CONF_TO_NAC_XCNT
,      AGENT_CALLS_HANDLED_TOTAL
,      AGENT_HANDLED_TOTAL_XCNT
,      AGENT_CALLS_HANDLED_ABOVE_TH
,      AGENT_HANDLED_ABOVE_TH_XCNT
,      AGENT_CALLS_ANSWERED_BY_GOAL
,      AGENT_ANSWERED_BY_GOAL_XCNT
,      AGENT_SR_CREATED
,      SR_CREATED_XCNT
,      AGENT_LEADS_CREATED
,      LEADS_CREATED_XCNT
,      AGENT_LEADS_AMOUNT
,      LEADS_AMOUNT_XCNT
,      AGENT_LEADS_CONVERTED_TO_OPP
,      LEADS_CONVERTED_TO_OPP_XCNT
,      AGENT_OPPORTUNITIES_CREATED
,      OPPORTUNITIES_CREATED_XCNT
,      AGENT_OPPORTUNITIES_WON
,      OPPORTUNITIES_WON_XCNT
,      AGENT_OPPORTUNITIES_WON_AMOUNT
,      OPPORTUNITIES_WON_AMOUNT_XCNT
,      AGENT_OPPORTUNITIES_CROSS_SOLD
,      OPPORTUNITIES_CROSS_SOLD_XCNT
,      AGENT_OPPORTUNITIES_UP_SOLD
,      OPPORTUNITIES_UP_SOLD_XCNT
,      AGENT_OPPORTUNITIES_DECLINED
,      OPPORTUNITIES_DECLINED_XCNT
,      AGENT_OPPORTUNITIES_LOST
,      OPPORTUNITIES_LOST_XCNT
,      AGENT_PREVIEW_TIME
,      PREVIEW_TIME_XCNT
,      AGENTCALL_ORR_COUNT
,      CALL_ORR_COUNT_XCNT
,      AGENTCALL_PR_COUNT
,      CALL_PR_COUNT_XCNT
,      AGENT_CONT_CALLS_HAND_NA
,      CONT_CALLS_HAND_NA_XCNT
,      AGENT_CONT_CALLS_TC_NA
,      CONT_CALLS_TC_NA_XCNT
,      XCNT
FROM APPS.BIX_AI_CALL_DETAILS_MV;

Dependencies

[top of page]

APPS.BIX_AI_CALL_DETAILS_MV does not reference any database object

APPS.BIX_AI_CALL_DETAILS_MV is referenced by following:

APPS: BIX_AI_CALL_DETAILS_MV