View: JTF_FM_SERVICE

Product:	JTF - CRM Foundation
Description:	Stores information about the fulfillment servers
Implementation/DBA Data:	APPS.JTF_FM_SERVICE

View Text

SELECT OBJECT_VERSION_NUMBER
, STARTUP_TIME
, SHUTDOWN_TIME
, 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
, 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
FROM JTF_FM_SERVICE_ALL

Columns