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: CN.CN_SCA_PROCESS_BATCHES_ALL

Object Details

Object Name:	CN_SCA_PROCESS_BATCHES_ALL
Object Type:	TABLE
Owner:	CN
FND Design Data:	CN.CN_SCA_PROCESS_BATCHES_ALL
Subobject Name:
Status:	VALID

Credit Rules Engine uses parallel workers concept. Before processing, transactions will split into multiple batches and these batches will be executed simultaneously.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CN_SCA_PROCESS_BATCHES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SCA_PROCESS_BATCH_ID ORG_ID
CN_SCA_PROCESS_BATCHES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOGICAL_BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SCA_PROCESS_BATCH_ID	NUMBER		Yes	Primary key
START_ID	VARCHAR2	(20)	Yes	Start ID of the batch
END_ID	VARCHAR2	(20)	Yes	End ID of the batch
TYPE	VARCHAR2	(15)	Yes	Batch type
LOGICAL_BATCH_ID	NUMBER		Yes	Logical batch ID
ORG_ID	NUMBER			Organization Identifier
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
REQUEST_ID	NUMBER			Concurrent request ID
STATUS	VARCHAR2	(10)		Status of the batch
CREATED_BY	NUMBER			Standard who column
CREATION_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER			Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
SECURITY_GROUP_ID	NUMBER	(15)		Security group ID

Query Text

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


SELECT SCA_PROCESS_BATCH_ID
,      START_ID
,      END_ID
,      TYPE
,      LOGICAL_BATCH_ID
,      ORG_ID
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
,      STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM CN.CN_SCA_PROCESS_BATCHES_ALL;

Dependencies

[top of page]

CN.CN_SCA_PROCESS_BATCHES_ALL does not reference any database object

CN.CN_SCA_PROCESS_BATCHES_ALL is referenced by following:

APPS: CN_SCA_PROCESS_BATCHES; CN_SCA_PROCESS_BATCHES_ALL