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

VIEW: APPS.JTF_FM_EMAIL_STATS_V

Object Details
Object Name: JTF_FM_EMAIL_STATS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_FM_EMAIL_STATS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View to display Statics of the Emails sent for that request.


[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes Column that stores the Fulfillment Request Id
TOTAL NUMBER

Total is the aggregate number of emails sent for that request Id.
SENT NUMBER

Sent represents the number of emails successfully sent.
MALFORMED NUMBER

Number of email recipients who had Malformed Email Address
BOUNCED NUMBER

Number of Emails that bounced back for a given request.
OPENED NUMBER

Number of emails that were opened.
UNSUBSCRIBED NUMBER

Number of recipients who opted for to "Unsubscribe" after receiving a request
DO_NOT_CONTACT NUMBER

Number of contacts that had a "DO NOT CONTACT" Flag set
CREATED_BY NUMBER
Yes Record created by.
CREATION_DATE DATE
Yes Record creation date
LAST_UPDATED_BY NUMBER
Yes Record last updated by
LAST_UPDATE_DATE DATE
Yes Last Updated date.
LAST_UPDATE_LOGIN NUMBER

Last update Login
RESUBMITTED_MALFORMED NUMBER

this column will keep track of the number of jobs within a request that initially had malformed requests but later the address has been changed and resubmitted
RESUBMITTED_JOB_COUNT NUMBER

this column will keep track of the number of each individual job that has been resubmitted.
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 APPS.JTF_FM_EMAIL_STATS_V;

Dependencies

[top of page]

APPS.JTF_FM_EMAIL_STATS_V references the following:

SchemaAPPS
SynonymJTF_FM_EMAIL_STATS

APPS.JTF_FM_EMAIL_STATS_V is not referenced by any database object