[Home] [Help] [Dependency Information]
Object Name: | IEM_RT_PP_QUEUES |
---|---|
Object Type: | TABLE |
Owner: | IEM |
Subobject Name: | |
Status: | VALID |
Stores preprocessed email information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEM_RT_PP_QUEUES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EMAIL_ID |
IEM_RT_PP_QUEUES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
EMAIL_ACCOUNT_ID
MSG_UID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMAIL_ID | NUMBER | (15) | Yes | Unique row id. |
MSG_UID | NUMBER | (15) | Email UID. | |
EMAIL_ACCOUNT_ID | NUMBER | (15) | Email account id. | |
SUBJECT | VARCHAR2 | (2000) | Email subject rfc822 header. | |
FROM_ADDRESS | VARCHAR2 | (2000) | Email from-address rfc822 header. | |
MSG_SIZE | NUMBER | (15) | Email message size. | |
FLAG | VARCHAR2 | (1) | Email flag. | |
RECEIVED_DATE | DATE | Received date. | ||
RETRY_COUNT | NUMBER | (15) | Email retry count. | |
RFC822_MESSAGE_ID | VARCHAR2 | (256) | Rfc822 message Id. | |
ACTION | NUMBER | (15) | Action to be performed on email. | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT EMAIL_ID
, MSG_UID
, EMAIL_ACCOUNT_ID
, SUBJECT
, FROM_ADDRESS
, MSG_SIZE
, FLAG
, RECEIVED_DATE
, RETRY_COUNT
, RFC822_MESSAGE_ID
, ACTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IEM.IEM_RT_PP_QUEUES;
IEM.IEM_RT_PP_QUEUES does not reference any database object
IEM.IEM_RT_PP_QUEUES is referenced by following:
|
|
|