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: SYS.WRI$_ADV_ASA_RECO_DATA

Object Details

Object Name:	WRI$_ADV_ASA_RECO_DATA
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Temporary Table Details

SYS.WRI$_ADV_ASA_RECO_DATA is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
TASK_ID	NUMBER
CTIME	TIMESTAMP(6)	(11)
SEGOWNER	VARCHAR2	(100)
SEGNAME	VARCHAR2	(100)
SEGTYPE	VARCHAR2	(64)
PARTNAME	VARCHAR2	(100)
TSNAME	VARCHAR2	(100)
BENEFIT_TYPE	NUMBER
USP	NUMBER
ALSP	NUMBER
REC	NUMBER
CHCT	NUMBER
CMD_ID	NUMBER
C1	VARCHAR2	(1000)
C2	VARCHAR2	(1000)
C3	VARCHAR2	(1000)

Query Text

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


SELECT TASK_ID
,      CTIME
,      SEGOWNER
,      SEGNAME
,      SEGTYPE
,      PARTNAME
,      TSNAME
,      BENEFIT_TYPE
,      USP
,      ALSP
,      REC
,      CHCT
,      CMD_ID
,      C1
,      C2
,      C3
FROM SYS.WRI$_ADV_ASA_RECO_DATA;

Dependencies

[top of page]

SYS.WRI$_ADV_ASA_RECO_DATA does not reference any database object

SYS.WRI$_ADV_ASA_RECO_DATA is not referenced by any database object