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: BIX.MLOG$_BIX_EMAIL_DETAILS_F

Object Details

Object Name:	MLOG$_BIX_EMAIL_DETAILS_F
Object Type:	TABLE
Owner:	BIX
Subobject Name:
Status:	VALID

snapshot log for master table BIX.BIX_EMAIL_DETAILS_F

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	60
PCT Used:

Columns

Name	Datatype	Length
ACCUMULATED_EMAILS_IN_QUEUE	NUMBER
ACCUMULATED_EMAILS_ONE_DAY	NUMBER
ACCUMULATED_EMAILS_THREE_DAYS	NUMBER
ACCUMULATED_EMAILS_WEEK	NUMBER
ACCUMULATED_EMAILS_WEEK_PLUS	NUMBER
ACCUMULATED_OPEN_AGE	NUMBER
ACCUMULATED_OPEN_EMAILS	NUMBER
ACCUMULATED_QUEUE_TIME	NUMBER
AGENT_ID	NUMBER
AGENT_RESP_TIME_IN_PERIOD	NUMBER
EMAILS_ASSIGNED_IN_PERIOD	NUMBER
EMAILS_AUTO_DELETED_IN_PERIOD	NUMBER
EMAILS_AUTO_REPLIED_IN_PERIOD	NUMBER
EMAILS_AUTO_RESOLVED_IN_PERIOD	NUMBER
EMAILS_AUTO_ROUTED_IN_PERIOD	NUMBER
EMAILS_AUTO_UPTD_SR_IN_PERIOD	NUMBER
EMAILS_COMPOSED_IN_PERIOD	NUMBER
EMAILS_DELETED_IN_PERIOD	NUMBER
EMAILS_FETCHED_IN_PERIOD	NUMBER
EMAILS_OFFERED_IN_PERIOD	NUMBER
EMAILS_ORR_COUNT_IN_PERIOD	NUMBER
EMAILS_REPLIED_IN_PERIOD	NUMBER
EMAILS_REROUTED_IN_PERIOD	NUMBER
EMAILS_RPLD_BY_GOAL_IN_PERIOD	NUMBER
EMAILS_RSL_AND_TRFD_IN_PERIOD	NUMBER
EMAILS_TRNSFRD_IN_IN_PERIOD	NUMBER
EMAILS_TRNSFRD_OUT_IN_PERIOD	NUMBER
EMAIL_ACCOUNT_ID	NUMBER
EMAIL_CLASSIFICATION_ID	NUMBER
EMAIL_RESP_TIME_IN_PERIOD	NUMBER
FOUR_RSLN_IN_PERIOD	NUMBER
INTERACTION_THREADS_IN_PERIOD	NUMBER
LEADS_CREATED_IN_PERIOD	NUMBER
OLDEST_EMAIL_OPEN_DATE	DATE
OLDEST_EMAIL_QUEUE_DATE	DATE
ONE_RSLN_IN_PERIOD	NUMBER
OUTCOME_ID	NUMBER
PARTY_ID	NUMBER
PERIOD_START_DATE	DATE
PERIOD_TYPE_ID	NUMBER
REASON_ID	NUMBER
RESULT_ID	NUMBER
SR_CREATED_IN_PERIOD	NUMBER
THREE_RSLN_IN_PERIOD	NUMBER
TIME_ID	NUMBER
TWO_RSLN_IN_PERIOD	NUMBER
M_ROW$$	VARCHAR2	(255)
SEQUENCE$$	NUMBER
SNAPTIME$$	DATE
DMLTYPE$$	VARCHAR2	(1)
OLD_NEW$$	VARCHAR2	(1)
CHANGE_VECTOR$$	RAW	(255)
AGENT_EMAILS_RPLD_BY_GOAL	NUMBER

Query Text

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


SELECT ACCUMULATED_EMAILS_IN_QUEUE
,      ACCUMULATED_EMAILS_ONE_DAY
,      ACCUMULATED_EMAILS_THREE_DAYS
,      ACCUMULATED_EMAILS_WEEK
,      ACCUMULATED_EMAILS_WEEK_PLUS
,      ACCUMULATED_OPEN_AGE
,      ACCUMULATED_OPEN_EMAILS
,      ACCUMULATED_QUEUE_TIME
,      AGENT_ID
,      AGENT_RESP_TIME_IN_PERIOD
,      EMAILS_ASSIGNED_IN_PERIOD
,      EMAILS_AUTO_DELETED_IN_PERIOD
,      EMAILS_AUTO_REPLIED_IN_PERIOD
,      EMAILS_AUTO_RESOLVED_IN_PERIOD
,      EMAILS_AUTO_ROUTED_IN_PERIOD
,      EMAILS_AUTO_UPTD_SR_IN_PERIOD
,      EMAILS_COMPOSED_IN_PERIOD
,      EMAILS_DELETED_IN_PERIOD
,      EMAILS_FETCHED_IN_PERIOD
,      EMAILS_OFFERED_IN_PERIOD
,      EMAILS_ORR_COUNT_IN_PERIOD
,      EMAILS_REPLIED_IN_PERIOD
,      EMAILS_REROUTED_IN_PERIOD
,      EMAILS_RPLD_BY_GOAL_IN_PERIOD
,      EMAILS_RSL_AND_TRFD_IN_PERIOD
,      EMAILS_TRNSFRD_IN_IN_PERIOD
,      EMAILS_TRNSFRD_OUT_IN_PERIOD
,      EMAIL_ACCOUNT_ID
,      EMAIL_CLASSIFICATION_ID
,      EMAIL_RESP_TIME_IN_PERIOD
,      FOUR_RSLN_IN_PERIOD
,      INTERACTION_THREADS_IN_PERIOD
,      LEADS_CREATED_IN_PERIOD
,      OLDEST_EMAIL_OPEN_DATE
,      OLDEST_EMAIL_QUEUE_DATE
,      ONE_RSLN_IN_PERIOD
,      OUTCOME_ID
,      PARTY_ID
,      PERIOD_START_DATE
,      PERIOD_TYPE_ID
,      REASON_ID
,      RESULT_ID
,      SR_CREATED_IN_PERIOD
,      THREE_RSLN_IN_PERIOD
,      TIME_ID
,      TWO_RSLN_IN_PERIOD
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
,      AGENT_EMAILS_RPLD_BY_GOAL
FROM BIX.MLOG$_BIX_EMAIL_DETAILS_F;

Dependencies

[top of page]

BIX.MLOG$_BIX_EMAIL_DETAILS_F does not reference any database object

BIX.MLOG$_BIX_EMAIL_DETAILS_F is referenced by following:

APPS: MLOG$_BIX_EMAIL_DETAILS_F