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: CSI.CSI_BATCH_TXN_LINES

Object Details

Object Name:	CSI_BATCH_TXN_LINES
Object Type:	TABLE
Owner:	CSI
Subobject Name:
Status:	VALID

This table contains data which is used by concurrent program to proces order details.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSI_BATCH_TXN_LINES_N01	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	Batch Identifier
PROCESSED_FLAG	NUMBER		Yes	Will mark the rows as processed by worker
ORDER_HEADER_ID	NUMBER		Yes	Order Header Identifier
ORDER_LINE_ID	NUMBER		Yes	Order Line Identifier
TRANSACTION_TYPE	VARCHAR2	(30)	Yes	Transaction Type
TRANSACTION_TYPE_ID	NUMBER		Yes	Transaction Type Identifier
TRANSACTION_ID	NUMBER			Transaction Identifier
CREATION_DATE	DATE		Yes	Date of creation for the batch
CREATED_BY	NUMBER		Yes	Will store the User ID of the User who has created
LAST_UPDATE_DATE	DATE		Yes	Last updated date for the batch
LAST_UPDATED_BY	NUMBER		Yes	Will store the User ID for User who has updated the batch

Query Text

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


SELECT BATCH_ID
,      PROCESSED_FLAG
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      TRANSACTION_TYPE
,      TRANSACTION_TYPE_ID
,      TRANSACTION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM CSI.CSI_BATCH_TXN_LINES;

Dependencies

[top of page]

CSI.CSI_BATCH_TXN_LINES does not reference any database object

CSI.CSI_BATCH_TXN_LINES is referenced by following:

APPS: CSI_BATCH_TXN_LINES