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: RRS.RRS_SITE_TMP

Object Details

Object Name:	RRS_SITE_TMP
Object Type:	TABLE
Owner:	RRS
FND Design Data:	RRS.RRS_SITE_TMP
Subobject Name:
Status:	VALID

This table is reserved for integration with Oracle Spatial. Not supported in this release.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000457983C00010$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000457983C00011$$	LOB	UNIQUE	APPS_TS_TX_DATA
RRS_SITE_TMP_N1	DOMAIN	NONUNIQUE		GEOMETRY
RRS_SITE_TMP_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SESSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	VARCHAR2	(30)	Yes	Session Identifier of process creating rows
THEME_ID	VARCHAR2	(30)		Theme ID of the Site used in Oracle Spatial
SITE_ID	NUMBER			Site Identifier
GEOMETRY	SDO_GEOMETRY	(1)

Query Text

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


SELECT SESSION_ID
,      THEME_ID
,      SITE_ID
,      GEOMETRY
FROM RRS.RRS_SITE_TMP;

Dependencies

[top of page]

RRS.RRS_SITE_TMP references the following:

MDSYS: SDO_ELEM_INFO_ARRAY; SDO_GEOMETRY; SDO_ORDINATE_ARRAY
SYS: STANDARD - show dependent code

RRS.RRS_SITE_TMP is referenced by following:

APPS: RRS_SITE_TMP