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]

MATERIALIZED VIEW: APPS.BIX_EMAIL_DETAILS_MV

Object Details

Object Name:	BIX_EMAIL_DETAILS_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	BIX_EMAIL_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_EMAIL_DETAILS_F

[View Source Query]

Columns

Name	Datatype	Length	Mandatory
TIME_ID	NUMBER		Yes
PERIOD_TYPE_ID	NUMBER		Yes
PERIOD_START_DATE	DATE		Yes
EMAIL_ACCOUNT_ID	NUMBER		Yes
EMAIL_CLASSIFICATION_ID	NUMBER		Yes
AGENT_ID	NUMBER
PARTY_ID	NUMBER
OUTCOME_ID	NUMBER
RESULT_ID	NUMBER
REASON_ID	NUMBER
G_ID	NUMBER
ROW_TYPE	VARCHAR2	(7)
EMAILS_OFFERED_IN_PERIOD	NUMBER
EMAILS_FETCHED_IN_PERIOD	NUMBER
EMAILS_REPLIED_IN_PERIOD	NUMBER
EMAILS_RPLD_BY_GOAL_IN_PERIOD	NUMBER
AGENT_EMAILS_RPLD_BY_GOAL	NUMBER
EMAILS_DELETED_IN_PERIOD	NUMBER
EMAILS_TRNSFRD_OUT_IN_PERIOD	NUMBER
EMAILS_TRNSFRD_IN_IN_PERIOD	NUMBER
EMAILS_RSL_AND_TRFD_IN_PERIOD	NUMBER
EMAILS_ASSIGNED_IN_PERIOD	NUMBER
EMAILS_AUTO_ROUTED_IN_PERIOD	NUMBER
EMAILS_AUTO_UPTD_SR_IN_PERIOD	NUMBER
SR_CREATED_IN_PERIOD	NUMBER
ACCUMULATED_OPEN_EMAILS	NUMBER
ACCUMULATED_OPEN_AGE	NUMBER
ACCUMULATED_EMAILS_IN_QUEUE	NUMBER
ACCUMULATED_QUEUE_TIME	NUMBER
EMAIL_RESP_TIME_IN_PERIOD	NUMBER
AGENT_RESP_TIME_IN_PERIOD	NUMBER
ACCUMULATED_EMAILS_ONE_DAY	NUMBER
ACCUMULATED_EMAILS_THREE_DAYS	NUMBER
ACCUMULATED_EMAILS_WEEK	NUMBER
ACCUMULATED_EMAILS_WEEK_PLUS	NUMBER
ONE_RSLN_IN_PERIOD	NUMBER
TWO_RSLN_IN_PERIOD	NUMBER
THREE_RSLN_IN_PERIOD	NUMBER
FOUR_RSLN_IN_PERIOD	NUMBER
INTERACTION_THREADS_IN_PERIOD	NUMBER
EMAILS_ORR_COUNT_IN_PERIOD	NUMBER
EMAILS_AUTO_REPLIED_IN_PERIOD	NUMBER
EMAILS_AUTO_DELETED_IN_PERIOD	NUMBER
EMAILS_AUTO_RESOLVED_IN_PERIOD	NUMBER
EMAILS_COMPOSED_IN_PERIOD	NUMBER
LEADS_CREATED_IN_PERIOD	NUMBER
EMAILS_REROUTED_IN_PERIOD	NUMBER
EMAILS_OFFERED_C	NUMBER
EMAILS_FETCHED_C	NUMBER
EMAILS_REPLIED_C	NUMBER
EMAILS_RPLD_BY_GOAL_C	NUMBER
AGENT_EMAILS_RPLD_BY_GOAL_C	NUMBER
EMAILS_DELETED_C	NUMBER
EMAILS_TRNSFRD_OUT_C	NUMBER
EMAILS_TRNSFRD_IN_C	NUMBER
EMAILS_RSL_AND_TRFD_C	NUMBER
EMAILS_ASSIGNED_C	NUMBER
EMAILS_AUTO_ROUTED_C	NUMBER
EMAILS_AUTO_UPTD_SR_C	NUMBER
SR_CREATED_C	NUMBER
ACCU_OPEN_EMAILS_C	NUMBER
ACCU_OPEN_AGE_C	NUMBER
ACCU_EMAILS_IN_QUEUE_C	NUMBER
ACCU_QUEUE_TIME_C	NUMBER
EMAIL_RESP_TIME_C	NUMBER
AGENT_RESP_TIME_C	NUMBER
ACCU_EMAILS_ONE_DAY_C	NUMBER
ACCU_EMAILS_THREE_DAYS_C	NUMBER
ACCU_EMAILS_WEEK_C	NUMBER
ACCU_EMAILS_WEEK_PLUS_C	NUMBER
ONE_RSLN_C	NUMBER
TWO_RSLN_C	NUMBER
THREE_RSLN_C	NUMBER
FOUR_RSLN_C	NUMBER
INTERACTION_THREAD_C	NUMBER
EMAILS_ORR_COUNT_C	NUMBER
EMAILS_AUTO_REPLIED_C	NUMBER
EMAILS_AUTO_DELETED_C	NUMBER
EMAILS_AUTO_RESOLV_C	NUMBER
EMAILS_COMPOSED_C	NUMBER
LEADS_CREATED_C	NUMBER
EMAILS_REROUTED_C	NUMBER
TOT_CNT	NUMBER

Query Text

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


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      PERIOD_START_DATE
,      EMAIL_ACCOUNT_ID
,      EMAIL_CLASSIFICATION_ID
,      AGENT_ID
,      PARTY_ID
,      OUTCOME_ID
,      RESULT_ID
,      REASON_ID
,      G_ID
,      ROW_TYPE
,      EMAILS_OFFERED_IN_PERIOD
,      EMAILS_FETCHED_IN_PERIOD
,      EMAILS_REPLIED_IN_PERIOD
,      EMAILS_RPLD_BY_GOAL_IN_PERIOD
,      AGENT_EMAILS_RPLD_BY_GOAL
,      EMAILS_DELETED_IN_PERIOD
,      EMAILS_TRNSFRD_OUT_IN_PERIOD
,      EMAILS_TRNSFRD_IN_IN_PERIOD
,      EMAILS_RSL_AND_TRFD_IN_PERIOD
,      EMAILS_ASSIGNED_IN_PERIOD
,      EMAILS_AUTO_ROUTED_IN_PERIOD
,      EMAILS_AUTO_UPTD_SR_IN_PERIOD
,      SR_CREATED_IN_PERIOD
,      ACCUMULATED_OPEN_EMAILS
,      ACCUMULATED_OPEN_AGE
,      ACCUMULATED_EMAILS_IN_QUEUE
,      ACCUMULATED_QUEUE_TIME
,      EMAIL_RESP_TIME_IN_PERIOD
,      AGENT_RESP_TIME_IN_PERIOD
,      ACCUMULATED_EMAILS_ONE_DAY
,      ACCUMULATED_EMAILS_THREE_DAYS
,      ACCUMULATED_EMAILS_WEEK
,      ACCUMULATED_EMAILS_WEEK_PLUS
,      ONE_RSLN_IN_PERIOD
,      TWO_RSLN_IN_PERIOD
,      THREE_RSLN_IN_PERIOD
,      FOUR_RSLN_IN_PERIOD
,      INTERACTION_THREADS_IN_PERIOD
,      EMAILS_ORR_COUNT_IN_PERIOD
,      EMAILS_AUTO_REPLIED_IN_PERIOD
,      EMAILS_AUTO_DELETED_IN_PERIOD
,      EMAILS_AUTO_RESOLVED_IN_PERIOD
,      EMAILS_COMPOSED_IN_PERIOD
,      LEADS_CREATED_IN_PERIOD
,      EMAILS_REROUTED_IN_PERIOD
,      EMAILS_OFFERED_C
,      EMAILS_FETCHED_C
,      EMAILS_REPLIED_C
,      EMAILS_RPLD_BY_GOAL_C
,      AGENT_EMAILS_RPLD_BY_GOAL_C
,      EMAILS_DELETED_C
,      EMAILS_TRNSFRD_OUT_C
,      EMAILS_TRNSFRD_IN_C
,      EMAILS_RSL_AND_TRFD_C
,      EMAILS_ASSIGNED_C
,      EMAILS_AUTO_ROUTED_C
,      EMAILS_AUTO_UPTD_SR_C
,      SR_CREATED_C
,      ACCU_OPEN_EMAILS_C
,      ACCU_OPEN_AGE_C
,      ACCU_EMAILS_IN_QUEUE_C
,      ACCU_QUEUE_TIME_C
,      EMAIL_RESP_TIME_C
,      AGENT_RESP_TIME_C
,      ACCU_EMAILS_ONE_DAY_C
,      ACCU_EMAILS_THREE_DAYS_C
,      ACCU_EMAILS_WEEK_C
,      ACCU_EMAILS_WEEK_PLUS_C
,      ONE_RSLN_C
,      TWO_RSLN_C
,      THREE_RSLN_C
,      FOUR_RSLN_C
,      INTERACTION_THREAD_C
,      EMAILS_ORR_COUNT_C
,      EMAILS_AUTO_REPLIED_C
,      EMAILS_AUTO_DELETED_C
,      EMAILS_AUTO_RESOLV_C
,      EMAILS_COMPOSED_C
,      LEADS_CREATED_C
,      EMAILS_REROUTED_C
,      TOT_CNT
FROM APPS.BIX_EMAIL_DETAILS_MV;

Dependencies

[top of page]

APPS.BIX_EMAIL_DETAILS_MV references the following:

APPS: BIX_EMAIL_DETAILS_MV
BIX: BIX_EMAIL_DETAILS_F

APPS.BIX_EMAIL_DETAILS_MV is not referenced by any database object