DBA Data[Home] [Help] [Dependency Information]

MATERIALIZED VIEW: APPS.BIX_AI_CALL_DETAILS_MV

Object Details
Object Name: BIX_AI_CALL_DETAILS_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: BIX_AI_CALL_DETAILS_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

BIX_CALL_DETAILS_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
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 references the following:

SchemaAPPS
TableBIX_AI_CALL_DETAILS_MV
SchemaBIX
TableBIX_CALL_DETAILS_F

APPS.BIX_AI_CALL_DETAILS_MV is not referenced by any database object