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

VIEW: IEM.IEM_MSTEMAIL_ACCOUNTS#

Object Details
Object Name: IEM_MSTEMAIL_ACCOUNTS#
Object Type: VIEW
Owner: IEM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
EMAIL_ACCOUNT_ID NUMBER (15) Yes
EMTA_ID NUMBER (15)
EMAIL_ADDRESS VARCHAR2 (120) Yes
ACCOUNT_DESC VARCHAR2 (256)
USER_NAME VARCHAR2 (100) Yes
ACTIVE_FLAG VARCHAR2 (1)
DELETED_FLAG VARCHAR2 (1)
TEMPLATE_CATEGORY NUMBER (15)
SENDER_FLAG NUMBER (15)
MAILCHECK_DELAY NUMBER (15)
ACCOUNT_LANGUAGE VARCHAR2 (50)
REPLY_TO_ADDRESS VARCHAR2 (256)
RETURN_ADDRESS VARCHAR2 (256)
FROM_NAME VARCHAR2 (256)
IN_HOST VARCHAR2 (256)
OUT_HOST VARCHAR2 (256)
IN_PORT NUMBER (15)
OUT_PORT NUMBER (15)
CUSTOM_ENABLED VARCHAR2 (1)
SC_LANG VARCHAR2 (30)
ACCOUNT_TYPE VARCHAR2 (1)
KEM_FLAG NUMBER (15)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SECURITY_GROUP_ID NUMBER (15)
CHERRY_PICK_FLAG VARCHAR2 (1)
SSL_CONNECTION_FLAG VARCHAR2 (1)
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# references the following:

SchemaIEM
TableIEM_MSTEMAIL_ACCOUNTS
IEM.IEM_MSTEMAIL_ACCOUNTS# is referenced by following:

SchemaAPPS
SynonymIEM_MSTEMAIL_ACCOUNTS