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: CS.CS_INCIDENTS_PURGE_STAGING

Object Details

Object Name:	CS_INCIDENTS_PURGE_STAGING
Object Type:	TABLE
Owner:	CS
FND Design Data:	CS.CS_INCIDENTS_PURGE_STAGING
Subobject Name:
Status:	VALID

This table is used as a staging table that would store all the SRs that need to be purged for a set of parameters.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_INCIDENTS_PURGE_STAGING_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INCIDENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INCIDENT_ID	NUMBER		Yes	Service request id that needs to be purged.
WORKER_ID	NUMBER			ID of the worker thread that will perform purge for this Service Request.
CONCURRENT_REQUEST_ID	NUMBER			ID of the worker thread that will perform purge for this Service Request.
PURGE_STATUS	VARCHAR2	(3)		Status after the purge has been attempted for this Service Request.
PURGE_ERROR_MESSAGE	VARCHAR2	(4000)		Error message if the purge for this Service Request failed.

Query Text

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


SELECT INCIDENT_ID
,      WORKER_ID
,      CONCURRENT_REQUEST_ID
,      PURGE_STATUS
,      PURGE_ERROR_MESSAGE
FROM CS.CS_INCIDENTS_PURGE_STAGING;

Dependencies

[top of page]

CS.CS_INCIDENTS_PURGE_STAGING does not reference any database object

CS.CS_INCIDENTS_PURGE_STAGING is referenced by following:

APPS: CS_INCIDENTS_PURGE_STAGING