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: APPLSYS.FND_OAM_CSA_COLLECTIONS

Object Details

Object Name:	FND_OAM_CSA_COLLECTIONS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_OAM_CSA_COLLECTIONS
Subobject Name:
Status:	VALID

Table is for storing XML data files generated by Client System Analyzer tool

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: FND_OAM_CSA_COLLECTIONS_PK

USER_NAME
COLLECTION_TIME

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_OAM_CSA_COLLECTIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_DATA	USER_NAME COLLECTION_TIME
SYS_IL0000319292C00003$$	LOB	UNIQUE	APPS_TS_SEED

Columns

Name	Datatype	Length	Mandatory	Comments
USER_NAME	VARCHAR2	(512)	Yes	Stores username (Primary Key)
COLLECTION_TIME	DATE		Yes	Stores collection time (Primary Key)
DATA_FILE	CLOB	(4000)	Yes	Stores xml data file
LAST_UPDATE_DATE	DATE		Yes	Stores last updated timestamp
LAST_UPDATED_BY	NUMBER	(15)	Yes	Stores last updated by user id
CREATION_DATE	DATE		Yes	Stores creation date of this row
CREATED_BY	NUMBER	(15)	Yes	Stores created by user id
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Stores last updated by user id

Query Text

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


SELECT USER_NAME
,      COLLECTION_TIME
,      DATA_FILE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPLSYS.FND_OAM_CSA_COLLECTIONS;

Dependencies

[top of page]

APPLSYS.FND_OAM_CSA_COLLECTIONS does not reference any database object

APPLSYS.FND_OAM_CSA_COLLECTIONS is referenced by following:

APPLSYS: FND_OAM_CSA_COLLECTIONS#