[Home] [Help] [Dependency Information]
Object Name: | IEM_EMTA_CONFIGS |
---|---|
Object Type: | TABLE |
Owner: | IEM |
Subobject Name: | |
Status: | VALID |
Stores EMTA configuration info.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEM_EMTA_CONFIGS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EMTA_CONFIG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMTA_CONFIG_ID | NUMBER | (15) | Yes | Unique Id. |
POSTPROC_THREADS | NUMBER | (15) | Number of Post processing workers. | |
PREPROC_SLEEP_DURATION | NUMBER | (15) | Sleep time fir preprocessing workers. | |
POSTPROC_SLEEP_DURATION | NUMBER | (15) | Sleep time for postprocessing workers. | |
BATCH_SIZE | NUMBER | (15) | Batch size for emails downloaded per connection. | |
STATUS_FLAG | VARCHAR2 | (1) | Status flag for EMTA | |
CREATION_DATE | DATE | Yes | FND Who Columns | |
CREATED_BY | NUMBER | (15) | 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 EMTA_CONFIG_ID
, POSTPROC_THREADS
, PREPROC_SLEEP_DURATION
, POSTPROC_SLEEP_DURATION
, BATCH_SIZE
, STATUS_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IEM.IEM_EMTA_CONFIGS;
IEM.IEM_EMTA_CONFIGS does not reference any database object
IEM.IEM_EMTA_CONFIGS is referenced by following:
|
|
|