[Home] [Help] [Dependency Information]
Object Name: | BIX_EMAIL_DETAILS_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.BIX_EMAIL_DETAILS_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SNAP$_BIX_EMAIL_DETAILS_ | 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("EMAIL_ACCOUNT_ID") SYS_OP_MAP_NONNULL("EMAIL_CLASSIFICATION_ID") SYS_OP_MAP_NONNULL("OUTCOME_ID") SYS_OP_MAP_NONNULL("RESULT_ID") SYS_OP_MAP_NONNULL("REASON_ID") SYS_OP_MAP_NONNULL("PARTY_ID") SYS_OP_MAP_NONNULL("AGENT_ID") SYS_OP_MAP_NONNULL("G_ID") |
BIX_EMAIL_DETAILS_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
TIME_ID
PERIOD_TYPE_ID ROW_TYPE |
BIX_EMAIL_DETAILS_MV_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
TIME_ID
PERIOD_TYPE_ID EMAIL_ACCOUNT_ID EMAIL_CLASSIFICATION_ID ROW_TYPE |
BIX_EMAIL_DETAILS_MV_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
TIME_ID
PERIOD_TYPE_ID EMAIL_CLASSIFICATION_ID ROW_TYPE |
BIX_EMAIL_DETAILS_MV_N4 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
TIME_ID
PERIOD_TYPE_ID AGENT_ID EMAIL_ACCOUNT_ID EMAIL_CLASSIFICATION_ID ROW_TYPE |
BIX_EMAIL_DETAILS_MV_N5 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
TIME_ID
PERIOD_TYPE_ID AGENT_ID EMAIL_CLASSIFICATION_ID ROW_TYPE |
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 |
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;
APPS.BIX_EMAIL_DETAILS_MV does not reference any database object
APPS.BIX_EMAIL_DETAILS_MV is referenced by following:
|
|
|