[Home] [Help] [Dependency Information]
Object Name: | JTF_FM_SERVICE_ALL# |
---|---|
Object Type: | VIEW |
Owner: | JTF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STARTUP_TIME | DATE | |||
SHUTDOWN_TIME | DATE | |||
XML_DTD | CLOB | (4000) | ||
STATUS | VARCHAR2 | (20) | ||
SERVER_ID | NUMBER | Yes | ||
DEQUEUE_WAIT_INTERVAL | NUMBER | (30) | ||
OPTIMUM_WRKR_THRDS | NUMBER | (30) | ||
MAX_WRKR_THRDS | NUMBER | (30) | ||
INPUT_QUEUE_THRESHOLD | NUMBER | (30) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | ||
F_DELETEDFLAG | VARCHAR2 | (1) | ||
SERVICE_DESCRIPTION | VARCHAR2 | (500) | ||
DISPATCHER_QUEUE_NAME | VARCHAR2 | (50) | ||
REQUEST_QUEUE_NAME | VARCHAR2 | (50) | ||
ERROR_QUEUE_NAME | VARCHAR2 | (50) | ||
RESPONSE_QUEUE_NAME | VARCHAR2 | (50) | ||
SERVER_NAME | VARCHAR2 | (100) | ||
OBJECT_VERSION_NUMBER | NUMBER | |||
SECURITY_GROUP_ID | NUMBER | |||
IH_OUTCOME_ID | NUMBER | |||
IH_SUCCESS_RESULT_ID | NUMBER | |||
IH_FAILURE_RESULT_ID | NUMBER | |||
BATCH_REQUEST_Q | VARCHAR2 | (50) | ||
MASS_REQUEST_Q | VARCHAR2 | (50) | ||
BATCH_PAUSE_Q | VARCHAR2 | (50) | ||
MASS_PAUSE_Q | VARCHAR2 | (50) | ||
STATUS_REFRESH_RATE | NUMBER | |||
UNSUBSCRIBE_FLAG | VARCHAR2 | (1) | ||
TRACK_OPEN_EMAIL | VARCHAR2 | (1) | ||
RETURN_ADDRESS | VARCHAR2 | (240) | ||
FROM_ADDRESS | VARCHAR2 | (240) | ||
RETURN_PATH | VARCHAR2 | (240) | ||
ENABLE_BOUNCEBACK | VARCHAR2 | (1) | ||
IMAP_HOST | VARCHAR2 | (200) | ||
IMAP_PORT | NUMBER | |||
ACCOUNT_NAME | VARCHAR2 | (100) | ||
ACCOUNT_PASSWORD | VARCHAR2 | (120) | ||
RUN_FREQUENCY | NUMBER | |||
FROM_NAME | VARCHAR2 | (200) | ||
RUN_FREQ_TIME_UNIT | VARCHAR2 | (15) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT STARTUP_TIME
, SHUTDOWN_TIME
, XML_DTD
, STATUS
, SERVER_ID
, DEQUEUE_WAIT_INTERVAL
, OPTIMUM_WRKR_THRDS
, MAX_WRKR_THRDS
, INPUT_QUEUE_THRESHOLD
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ORG_ID
, F_DELETEDFLAG
, SERVICE_DESCRIPTION
, DISPATCHER_QUEUE_NAME
, REQUEST_QUEUE_NAME
, ERROR_QUEUE_NAME
, RESPONSE_QUEUE_NAME
, SERVER_NAME
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, IH_OUTCOME_ID
, IH_SUCCESS_RESULT_ID
, IH_FAILURE_RESULT_ID
, BATCH_REQUEST_Q
, MASS_REQUEST_Q
, BATCH_PAUSE_Q
, MASS_PAUSE_Q
, STATUS_REFRESH_RATE
, UNSUBSCRIBE_FLAG
, TRACK_OPEN_EMAIL
, RETURN_ADDRESS
, FROM_ADDRESS
, RETURN_PATH
, ENABLE_BOUNCEBACK
, IMAP_HOST
, IMAP_PORT
, ACCOUNT_NAME
, ACCOUNT_PASSWORD
, RUN_FREQUENCY
, FROM_NAME
, RUN_FREQ_TIME_UNIT
, ZD_EDITION_NAME
FROM JTF.JTF_FM_SERVICE_ALL#;
|
|
|