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


TABLE: APPS.BIX_EMAIL_DETAILS_MV

Object Details
Object Name: BIX_EMAIL_DETAILS_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.BIX_EMAIL_DETAILS_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_BIX_EMAIL_DETAILS_ FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("TIME_ID")
ColumnSYS_OP_MAP_NONNULL("PERIOD_TYPE_ID")
ColumnSYS_OP_MAP_NONNULL("PERIOD_START_DATE")
ColumnSYS_OP_MAP_NONNULL("EMAIL_ACCOUNT_ID")
ColumnSYS_OP_MAP_NONNULL("EMAIL_CLASSIFICATION_ID")
ColumnSYS_OP_MAP_NONNULL("OUTCOME_ID")
ColumnSYS_OP_MAP_NONNULL("RESULT_ID")
ColumnSYS_OP_MAP_NONNULL("REASON_ID")
ColumnSYS_OP_MAP_NONNULL("PARTY_ID")
ColumnSYS_OP_MAP_NONNULL("AGENT_ID")
ColumnSYS_OP_MAP_NONNULL("G_ID")
BIX_EMAIL_DETAILS_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnROW_TYPE
BIX_EMAIL_DETAILS_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnEMAIL_ACCOUNT_ID
ColumnEMAIL_CLASSIFICATION_ID
ColumnROW_TYPE
BIX_EMAIL_DETAILS_MV_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnEMAIL_CLASSIFICATION_ID
ColumnROW_TYPE
BIX_EMAIL_DETAILS_MV_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnAGENT_ID
ColumnEMAIL_ACCOUNT_ID
ColumnEMAIL_CLASSIFICATION_ID
ColumnROW_TYPE
BIX_EMAIL_DETAILS_MV_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnAGENT_ID
ColumnEMAIL_CLASSIFICATION_ID
ColumnROW_TYPE
Columns
Name Datatype Length Mandatory Comments
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 does not reference any database object

APPS.BIX_EMAIL_DETAILS_MV is referenced by following:

SchemaAPPS
Materialized ViewBIX_EMAIL_DETAILS_MV