[Home] [Help] [Dependency Information]
Object Name: | IEM_ARCH_REQUESTS |
---|---|
Object Type: | TABLE |
Owner: | IEM |
Subobject Name: | |
Status: | VALID |
Stores Archival requests and status.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEM_ARCH_REQUESTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | (15) | Yes | Unique request identifier |
ARCH_CRITERIA | VARCHAR2 | (2000) | Archival criteria | |
EMAIL_ACCOUNT_ID | NUMBER | (15) | Email account id to which the archive belongs to | |
FOLDER_NAME | VARCHAR2 | (100) | Name of archive folder | |
ARCH_FOLDER_ID | NUMBER | Archive folder id | ||
ARCH_COUNT | NUMBER | Number of messages in archive folder | ||
ARCH_SIZE | NUMBER | Last known archive size | ||
STATUS | VARCHAR2 | (1) | 'S' scheduled, 'E' error/failure, 'I' in progress, 'C' completed | |
ARCH_COMMENT | VARCHAR2 | (500) | Description of processing requests. | |
REQUEST_TYPE | VARCHAR2 | (1) | Archive 'A', Purge 'P' | |
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 | |
SECURITY_GROUP_ID | NUMBER | (15) | Security group identification |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, ARCH_CRITERIA
, EMAIL_ACCOUNT_ID
, FOLDER_NAME
, ARCH_FOLDER_ID
, ARCH_COUNT
, ARCH_SIZE
, STATUS
, ARCH_COMMENT
, REQUEST_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM IEM.IEM_ARCH_REQUESTS;
IEM.IEM_ARCH_REQUESTS does not reference any database object
IEM.IEM_ARCH_REQUESTS is referenced by following:
|
|
|