[Home] [Help] [Dependency Information]
Object Name: | IEM_EMAIL_ICNTR_MAPS |
---|---|
Object Type: | TABLE |
Owner: | IEM |
FND Design Data: | IEM.IEM_EMAIL_ICNTR_MAPS |
Subobject Name: | |
Status: | VALID |
An email account can potentially be accessed and serviced by agents from all over the world. However we have the following constraints. Emails are routed to agents through an MCM and a routing server that routes emails to agents belonging to its Interaction Center. MCM or the routing server has no knowledge of agents in other Interaction Centers. Hence, for now, an email account is uniquely tied to an Interaction Center. This mapping id is inserted into JTF_RS_RESOURCE_VALUES to tie an agent to an Interaction Center and a specific Email Account.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEM_EMAIL_ICNTR_MAPS_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | EMAIL_ICNTR_MAP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMAIL_ICNTR_MAP_ID | NUMBER | (15) | Yes | Sequence generated identifier. |
EMAIL_ACCOUNT_ID | NUMBER | (15) | Yes | Foreign key from IEM_EMAIL_ACCOUNTS. |
SERVER_GROUP_ID | NUMBER | (15) | Yes | Foreign key from IEM_SERVER_GROUPS. |
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_ICNTR_MAP_ID
, EMAIL_ACCOUNT_ID
, SERVER_GROUP_ID
, 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_ICNTR_MAPS;
IEM.IEM_EMAIL_ICNTR_MAPS does not reference any database object
IEM.IEM_EMAIL_ICNTR_MAPS is referenced by following:
|
|
|