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

TABLE: ITG.ITG_BATCH_ITEM

Object Details
Object Name: ITG_BATCH_ITEM
Object Type: TABLE
Owner: ITG
Subobject Name:
Status: VALID


This table tracks individual batch items within a request


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BATCH_REQUEST_ID NUMBER
Yes This is the foreign key reference to the batch request this item is within.
TRANSACTION_ID NUMBER

This is the transaction ID (i.e. the CLN ID) for this request item. It is used to get back to the collaboration record after all batch processing is done.
ITEM_INFO VARCHAR2 (200)
User data for returning to the original interface rows of the request, or similar. Use of this field is optional, and implementation dependent. (The Sync Item implementation puts or or two (separated) rowid values to re-access the inport interface rows, which are left undeleted in case of errors.)
Query Text

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


SELECT BATCH_REQUEST_ID
,      TRANSACTION_ID
,      ITEM_INFO
FROM ITG.ITG_BATCH_ITEM;

Dependencies

[top of page]

ITG.ITG_BATCH_ITEM does not reference any database object

ITG.ITG_BATCH_ITEM is referenced by following:

SchemaAPPS
SynonymITG_BATCH_ITEM