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: ITG.ITG_BATCH_REQUEST

Object Details

Object Name:	ITG_BATCH_REQUEST
Object Type:	TABLE
Owner:	ITG
Subobject Name:
Status:	VALID

This table tracks batch requests within a class. Batch requests have a state, one of OPEN, PENDING or RUNNING. There is at most only one record (per class) that is is the OPEN or RUNNING states. Any number of records can be in the PENDING state "in between" the OPEN and RUNNING states. The PENDING records are seqenced by the value of batch_request_id - so processing of items is serialized.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_REQUEST_ID	NUMBER		Yes	The key of a batch request, the value comes from the sequence itg_batch_request_s. In addition to being the primary key of the record, the value is used for ordering PENDING batches.
BATCH_CLASS_ID	NUMBER		Yes	This is the foreign key reference to the batch class the request is for.
STATUS	VARCHAR2	(10)	Yes	The status if this request, one of: 'OPEN', 'PENDING' or 'RUNNING'
PROCESS_SET_ID	NUMBER		Yes	The process set id value for this request (interface-specific). Open-interface API's (like Sync Item's INCOIN process) can have a number that refers to the set of interface records to process. This variable stores that value on behalf of the client, and it is acquired from and passed back as callback arguments.
CCM_REQUEST_ID	NUMBER			The CCM request ID of the interface import program (like Sync Item's INCOIN process).
REQUEST_CNT	NUMBER			The number of request items currently in this batch. This is the value that is checked aginst the itg_batch_class.limit_cnt value to find out if the batch should be closed.
LAST_REQUEST	DATE			The date field containing the last time a request item was added to the batch. This value is checked aginst the current time minus the itg_batch_class.timeout value to find out if the batch has timed out and should be closed.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_REQUEST_ID
,      BATCH_CLASS_ID
,      STATUS
,      PROCESS_SET_ID
,      CCM_REQUEST_ID
,      REQUEST_CNT
,      LAST_REQUEST
FROM ITG.ITG_BATCH_REQUEST;

Dependencies

[top of page]

ITG.ITG_BATCH_REQUEST does not reference any database object

ITG.ITG_BATCH_REQUEST is referenced by following:

APPS: ITG_BATCH_REQUEST