[Home] [Help] [Dependency Information]
Object Name: | JTF_FM_SERVICE_ALL |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_FM_SERVICE_ALL |
Subobject Name: | |
Status: | VALID |
This table stores information about the fulfillment servers
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_FM_SERVICE_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SERVER_ID |
SYS_IL0000084262C00003$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STARTUP_TIME | DATE | server start time | ||
SHUTDOWN_TIME | DATE | server shutdown time | ||
XML_DTD | CLOB | (4000) | The DTD for the fulfillment request. This field not being used in this version | |
STATUS | VARCHAR2 | (20) | Status of the fulfillment request | |
SERVER_ID | NUMBER | Yes | Server Identifier | |
DEQUEUE_WAIT_INTERVAL | NUMBER | (30) | Server dequeue wait interval | |
OPTIMUM_WRKR_THRDS | NUMBER | (30) | optimum no of threads | |
MAX_WRKR_THRDS | NUMBER | (30) | maximum no of threads | |
INPUT_QUEUE_THRESHOLD | NUMBER | (30) | server input queue threshold | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
ORG_ID | NUMBER | (15) | Organization identifier | |
F_DELETEDFLAG | VARCHAR2 | (1) | Flag to indicate HTML components that the record has been deleted | |
SERVICE_DESCRIPTION | VARCHAR2 | (500) | fulfillment engine description | |
DISPATCHER_QUEUE_NAME | VARCHAR2 | (50) | dispatcher queue name | |
REQUEST_QUEUE_NAME | VARCHAR2 | (50) | request queue name | |
ERROR_QUEUE_NAME | VARCHAR2 | (50) | error queue name | |
RESPONSE_QUEUE_NAME | VARCHAR2 | (50) | response queue name | |
SERVER_NAME | VARCHAR2 | (100) | Fulfillment server Name | |
OBJECT_VERSION_NUMBER | NUMBER | Sequential number used for database locking control when using HTML as a user interface | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
IH_OUTCOME_ID | NUMBER | Default IH Outcome Id | ||
IH_SUCCESS_RESULT_ID | NUMBER | Default Success Result Id | ||
IH_FAILURE_RESULT_ID | NUMBER | Default Failure Result Id | ||
BATCH_REQUEST_Q | VARCHAR2 | (50) | Request Queue Name for Batch Requests | |
MASS_REQUEST_Q | VARCHAR2 | (50) | Request Queue Name for Mass Requests | |
BATCH_PAUSE_Q | VARCHAR2 | (50) | Queue Name for Paused Batch Requests | |
MASS_PAUSE_Q | VARCHAR2 | (50) | Queue Name for Paused Mass Requests | |
STATUS_REFRESH_RATE | NUMBER | Rate at which the status of a request is updated. | ||
UNSUBSCRIBE_FLAG | VARCHAR2 | (1) | This flag should be set if Unsubscribe message has to be embedded in the body of the email | |
TRACK_OPEN_EMAIL | VARCHAR2 | (1) | This flag is to be set if open emails are to be tracked | |
RETURN_ADDRESS | VARCHAR2 | (240) | return adress | |
FROM_ADDRESS | VARCHAR2 | (240) | from address | |
RETURN_PATH | VARCHAR2 | (240) | If present, overrides the default email return path | |
ENABLE_BOUNCEBACK | VARCHAR2 | (1) | Flag to state if Bounceback is Enabled | |
IMAP_HOST | VARCHAR2 | (200) | IMAP Host for bounceback | |
IMAP_PORT | NUMBER | IMAP port for bounceback email | ||
ACCOUNT_NAME | VARCHAR2 | (100) | Account Name for Bounceback server | |
ACCOUNT_PASSWORD | VARCHAR2 | (120) | Account Password for bounceback server | |
RUN_FREQUENCY | NUMBER | Frequency at which the Bounceback email needs to be checked | ||
FROM_NAME | VARCHAR2 | (200) | From Name for Emails | |
RUN_FREQ_TIME_UNIT | VARCHAR2 | (15) | Stores the Time Unit (minutes or hours ) for the Run Frequency |
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
FROM JTF.JTF_FM_SERVICE_ALL;
JTF.JTF_FM_SERVICE_ALL does not reference any database object
JTF.JTF_FM_SERVICE_ALL is referenced by following:
|
|
|