eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OKS.OKS_EMAIL_DETAILS

Object Details

Object Name:	OKS_EMAIL_DETAILS
Object Type:	TABLE
Owner:	OKS
Subobject Name:
Status:	VALID

This table is used to store the details of the email sent from Send Email page.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000407633C00010$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
EMAIL_ID	NUMBER		Yes	Email Id generated using sequence
FROM_ADDRESS	VARCHAR2	(4000)	Yes	Email address of the sender
TO_ADDRESS	VARCHAR2	(4000)	Yes	Email addresses of the persons to whom email is sent
CC_ADDRESS	VARCHAR2	(4000)		Email addresses of persons receiving email as cc
BCC_ADDRESS	VARCHAR2	(4000)		Email addresses of persons receiving email as bcc. This column is not exposed in the UI.
REPLY_TO_ADDRESS	VARCHAR2	(4000)		Reply to email address
MESSAGE_TEMPLATE_ID	NUMBER			Template used to generate the cover letter
ATTACHMENT_TEMPLATE_ID	NUMBER			Template used to generate the attachment
EMAIL_SUBJECT	VARCHAR2	(2000)		Email Subject
EMAIL_BODY	CLOB	(4000)		Email Text
EMAIL_CONTRACT_STATUS	VARCHAR2	(30)		Contract Status to be updated after sending the email.
CREATED_BY	NUMBER		Yes	ID of the user whom created the record.
CREATION_DATE	DATE		Yes	Date the record was created.
LAST_UPDATED_BY	NUMBER		Yes	ID of the last user who updated the record.
LAST_UPDATE_DATE	DATE		Yes	Date the record was last updated.
LAST_UPDATE_LOGIN	NUMBER			OS ID of the user who last updated the record.

Query Text

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


SELECT EMAIL_ID
,      FROM_ADDRESS
,      TO_ADDRESS
,      CC_ADDRESS
,      BCC_ADDRESS
,      REPLY_TO_ADDRESS
,      MESSAGE_TEMPLATE_ID
,      ATTACHMENT_TEMPLATE_ID
,      EMAIL_SUBJECT
,      EMAIL_BODY
,      EMAIL_CONTRACT_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKS.OKS_EMAIL_DETAILS;

Dependencies

[top of page]

OKS.OKS_EMAIL_DETAILS does not reference any database object

OKS.OKS_EMAIL_DETAILS is referenced by following:

APPS: OKS_EMAIL_DETAILS