[Home] [Help]
View: JTF_FM_EMAIL_STATS_V
Product: | JTF - CRM Foundation |
Description: | View to display statics of the email sent for specific requests. |
Implementation/DBA Data: |
APPS.JTF_FM_EMAIL_STATS_V
|
View Text
SELECT STATS.REQUEST_ID
, STATS.TOTAL
, STATS.SENT
, STATS.MALFORMED
, STATS.BOUNCED
, STATS.OPENED
, STATS.UNSUBSCRIBED
, STATS.DO_NOT_CONTACT
, STATS.CREATED_BY
, STATS.CREATION_DATE
, STATS.LAST_UPDATED_BY
, STATS.LAST_UPDATE_DATE
, STATS.LAST_UPDATE_LOGIN
, STATS.RESUBMITTED_MALFORMED
, STATS.RESUBMITTED_JOB_COUNT
FROM JTF_FM_EMAIL_STATS STATS
Columns
Name |
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 |