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: IEM.IEM_MSTEMAIL_ACCOUNTS

Object Details

Object Name:	IEM_MSTEMAIL_ACCOUNTS
Object Type:	TABLE
Owner:	IEM
Subobject Name:
Status:	VALID

Stores email account information (11i11).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEM_MSTEMAIL_ACCOUNTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EMAIL_ACCOUNT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EMAIL_ACCOUNT_ID	NUMBER	(15)	Yes	Email Account Id
EMTA_ID	NUMBER	(15)		EMTA Associated with Account.
EMAIL_ADDRESS	VARCHAR2	(120)	Yes	Email Address of the account.
ACCOUNT_DESC	VARCHAR2	(256)		Account Description
USER_NAME	VARCHAR2	(100)	Yes	Account login user.
ACTIVE_FLAG	VARCHAR2	(1)		Active-Inactive flag.
DELETED_FLAG	VARCHAR2	(1)		Flag if marked as deleted.
TEMPLATE_CATEGORY	NUMBER	(15)		Template category assoc. with account.
SENDER_FLAG	NUMBER	(15)		Send email as Account/Agent flag.
MAILCHECK_DELAY	NUMBER	(15)		Delay between checks for new email.
ACCOUNT_LANGUAGE	VARCHAR2	(50)		Account language.
REPLY_TO_ADDRESS	VARCHAR2	(256)		Reply to address for account.
RETURN_ADDRESS	VARCHAR2	(256)		Return address.
FROM_NAME	VARCHAR2	(256)		From name for account.
IN_HOST	VARCHAR2	(256)		Hostname for Inbound email
OUT_HOST	VARCHAR2	(256)		Outgoing SMTP server name.
IN_PORT	NUMBER	(15)		Port number to connect to for incoming email.
OUT_PORT	NUMBER	(15)		Outgoing email Port.
CUSTOM_ENABLED	VARCHAR2	(1)		Flag for custom flow enabling account.
SC_LANG	VARCHAR2	(30)		Spellcheck Language
ACCOUNT_TYPE	VARCHAR2	(1)		Type of account. Internal/External.
KEM_FLAG	NUMBER	(15)		Flag to indicate keyword extraction method.
CREATED_BY	NUMBER	(15)	Yes	FND Who Columns
CREATION_DATE	DATE		Yes	FND Who Columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	FND Who Columns
LAST_UPDATE_DATE	DATE		Yes	FND Who Columns
LAST_UPDATE_LOGIN	NUMBER	(15)		FND Who Columns
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment column.
SECURITY_GROUP_ID	NUMBER	(15)		Seurity Group Id.
CHERRY_PICK_FLAG	VARCHAR2	(1)		Cherry Pick Enabled Flag
SSL_CONNECTION_FLAG	VARCHAR2	(1)		Indicate SSL connectivity for the account

Query Text

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


SELECT EMAIL_ACCOUNT_ID
,      EMTA_ID
,      EMAIL_ADDRESS
,      ACCOUNT_DESC
,      USER_NAME
,      ACTIVE_FLAG
,      DELETED_FLAG
,      TEMPLATE_CATEGORY
,      SENDER_FLAG
,      MAILCHECK_DELAY
,      ACCOUNT_LANGUAGE
,      REPLY_TO_ADDRESS
,      RETURN_ADDRESS
,      FROM_NAME
,      IN_HOST
,      OUT_HOST
,      IN_PORT
,      OUT_PORT
,      CUSTOM_ENABLED
,      SC_LANG
,      ACCOUNT_TYPE
,      KEM_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      CHERRY_PICK_FLAG
,      SSL_CONNECTION_FLAG
FROM IEM.IEM_MSTEMAIL_ACCOUNTS;

Dependencies

[top of page]

IEM.IEM_MSTEMAIL_ACCOUNTS does not reference any database object

IEM.IEM_MSTEMAIL_ACCOUNTS is referenced by following:

IEM: IEM_MSTEMAIL_ACCOUNTS#