eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: JTF.JTF_FM_SERVICE_ALL

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_FM_SERVICE_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SERVER_ID ZD_EDITION_NAME
SYS_IL0000084262C00003$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

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
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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;

Dependencies

[top of page]

JTF.JTF_FM_SERVICE_ALL does not reference any database object

JTF.JTF_FM_SERVICE_ALL is referenced by following:

JTF: JTF_FM_SERVICE_ALL#