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: SYSTEM.REPCAT$_TEMPLATE_STATUS

Object Details

Object Name:	REPCAT$_TEMPLATE_STATUS
Object Type:	TABLE
Owner:	SYSTEM
Subobject Name:
Status:	VALID

Table for template status and template status codes.

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: REPCAT$_TEMPLATE_STATUS_PK

TEMPLATE_STATUS_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
REPCAT$_TEMPLATE_STATUS_PK	NORMAL	UNIQUE	SYSTEM	TEMPLATE_STATUS_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
REPCAT$_REFRESH_TEMPLATES		REPCAT$_TEMPLATE_STATUS	REPCAT$_REFRESH_TEMPLATES TEMPLATE_STATUS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_STATUS_ID	NUMBER		Yes	Internal primary key for the template status table.
STATUS_TYPE_NAME	VARCHAR2	(100)	Yes	User friendly name for the template status.

Query Text

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


SELECT TEMPLATE_STATUS_ID
,      STATUS_TYPE_NAME
FROM SYSTEM.REPCAT$_TEMPLATE_STATUS;

Dependencies

[top of page]

SYSTEM.REPCAT$_TEMPLATE_STATUS does not reference any database object

SYSTEM.REPCAT$_TEMPLATE_STATUS is not referenced by any database object