[Home] [Help] [Dependency Information]
Object Name: | IEM_EMAIL_SERVER_TYPES |
---|---|
Object Type: | TABLE |
Owner: | IEM |
FND Design Data: | IEM.IEM_EMAIL_SERVER_TYPES |
Subobject Name: | |
Status: | VALID |
There are myriad types of email servers. We deal mainly with IMAP and SMTP protocols. This table is seeded with the above two values to indicate default implementations shipped with IM. The configuration can be extended to include IMAPs that implement SSL and POP3 servers. Different implementations of the protocols above would need to be differentiated by the functionality offered.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEM_EMAIL_SERVER_TYPES_U1 | NORMAL | UNIQUE | APPS_TS_SEED | EMAIL_SERVER_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMAIL_SERVER_TYPE_ID | NUMBER | (15) | Yes | Sequence generated identifier. |
EMAIL_SERVER_TYPE | VARCHAR2 | (20) | Server type. IMAP, SMTP or any other implementation. | |
IS_SECURE | VARCHAR2 | (1) | Y or N. Y if this server implements some encryption algorithm to scramble messages. N if it does not. | |
TYPE_DESCRIPTION | VARCHAR2 | (400) | User defined text, 5 lines of additional information. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
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 | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT EMAIL_SERVER_TYPE_ID
, EMAIL_SERVER_TYPE
, IS_SECURE
, TYPE_DESCRIPTION
, 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
FROM IEM.IEM_EMAIL_SERVER_TYPES;
IEM.IEM_EMAIL_SERVER_TYPES does not reference any database object
IEM.IEM_EMAIL_SERVER_TYPES is referenced by following:
|
|
|