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

VIEW: JTF.JTF_FM_EMAIL_STATS#

Object Details
Object Name: JTF_FM_EMAIL_STATS#
Object Type: VIEW
Owner: JTF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes
TOTAL NUMBER

SENT NUMBER

MALFORMED NUMBER

BOUNCED NUMBER

OPENED NUMBER

UNSUBSCRIBED NUMBER

DO_NOT_CONTACT NUMBER

CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

RESUBMITTED_MALFORMED NUMBER

RESUBMITTED_JOB_COUNT NUMBER

Query Text

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


SELECT REQUEST_ID
,      TOTAL
,      SENT
,      MALFORMED
,      BOUNCED
,      OPENED
,      UNSUBSCRIBED
,      DO_NOT_CONTACT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RESUBMITTED_MALFORMED
,      RESUBMITTED_JOB_COUNT
FROM JTF.JTF_FM_EMAIL_STATS#;

Dependencies

[top of page]

JTF.JTF_FM_EMAIL_STATS# references the following:

SchemaJTF
TableJTF_FM_EMAIL_STATS
JTF.JTF_FM_EMAIL_STATS# is referenced by following:

SchemaAPPS
SynonymJTF_FM_EMAIL_STATS