[Home] [Help] [Dependency Information]
Object Name: | IEM_CLASSIFICATIONS |
---|---|
Object Type: | TABLE |
Owner: | IEM |
FND Design Data: | IEM.IEM_CLASSIFICATIONS |
Subobject Name: | |
Status: | VALID |
Incoming email messages are categorized into one of the following classifications based on their content. Classifications can be defined on an email account basis or they can be common to all accounts. The end user enters appropriate classification names.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEM_CLASSIFICATIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CLASSIFICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLASSIFICATION_ID | NUMBER | (15) | Yes | Sequence generated identifier. |
EMAIL_ACCOUNT_ID | NUMBER | (15) | Yes | Sequence generated identifier. Foreign key from IEM_EMAIL_ACCOUNTS. |
CLASSIFICATION | VARCHAR2 | (50) | Arbitrary name. User defined. | |
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 CLASSIFICATION_ID
, EMAIL_ACCOUNT_ID
, CLASSIFICATION
, 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_CLASSIFICATIONS;
IEM.IEM_CLASSIFICATIONS does not reference any database object
IEM.IEM_CLASSIFICATIONS is referenced by following:
|
|
|