[Home] [Help]
[Dependency Information]
Object Name: | JTF_FM_BOUNCE_BACKS |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Table to store information about Emails that bounced back.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000328485C00010$$ | LOB | UNIQUE |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Yes | Unique Request Identifier | |
JOB | NUMBER | Yes | Unique Job Identifier | |
TO_ADDRESS | VARCHAR2 | (1000) | The Address of the recipient | |
FROM_ADDRESS | VARCHAR2 | (240) | Address of the sender | |
SUBJECT | VARCHAR2 | (1000) | Subject of the email | |
ORIG_TO | VARCHAR2 | (1000) | The original address of the recipient | |
ORIG_FROM | VARCHAR2 | (1000) | Original address of the sender | |
ORIG_CC | VARCHAR2 | (1000) | The address of the person to who the original request was CC'd | |
ORIG_BCC | VARCHAR2 | (1000) | The BCC address of the original email | |
MESSAGE | BLOB | (4000) | The Bounceback email message | |
BOUNCE_TYPE | VARCHAR2 | (1) | Defines the type of Bounce back | |
CREATED_BY | NUMBER | Yes | Standard WHO column to indicated the creator of the record | |
CREATION_DATE | DATE | Yes | Standard WHO column to indicate the date on which the record was created | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column to denote the last updated date | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column to denote the last updated by. | |
JTF_FM_LAST_UPDATE_LOGIN | NUMBER | Standard WHO column to indicate the Last Updated person's ID |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, JOB
, TO_ADDRESS
, FROM_ADDRESS
, SUBJECT
, ORIG_TO
, ORIG_FROM
, ORIG_CC
, ORIG_BCC
, MESSAGE
, BOUNCE_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, JTF_FM_LAST_UPDATE_LOGIN
FROM JTF.JTF_FM_BOUNCE_BACKS;
JTF.JTF_FM_BOUNCE_BACKS does not reference any database object
JTF.JTF_FM_BOUNCE_BACKS is referenced by following:
|
|
|