[Home] [Help] [Dependency Information]
Object Name: | JTF_FM_EMAIL_STATS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_FM_EMAIL_STATS_V |
Subobject Name: | |
Status: | VALID |
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.
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. |
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;
APPS.JTF_FM_EMAIL_STATS_V is not referenced by any database object
|
|
|