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: ORDSYS.ORDDCM_ANON_RULES_WRK

Object Details

Object Name:	ORDDCM_ANON_RULES_WRK
Object Type:	TABLE
Owner:	ORDSYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: ORDDCM_ANON_RULES_W_PK1

DOC_ID
RULE_TYPE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
ORDDCM_ANON_RULES_W_PK1	NORMAL	UNIQUE	SYSTEM	DOC_ID RULE_TYPE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
ORDDCM_ANON_RULES_WRK	ORDDCM_ANON_ACTION_TYPES	ORDDCM_ANON_RULES_WRK ANON_ACTION_TYPE_ID
ORDDCM_ANON_RULES_WRK	ORDDCM_ANON_RULE_TYPES	ORDDCM_ANON_RULES_WRK RULE_TYPE_ID
ORDDCM_ANON_RULES_WRK	ORDDCM_DOCS_WRK	ORDDCM_ANON_RULES_WRK DOC_ID

Columns

Name	Datatype	Length	Mandatory
DOC_ID	NUMBER	(38)	Yes
RULE_TYPE_ID	NUMBER		Yes
ANON_ACTION_TYPE_ID	NUMBER		Yes
ANON_VALUE	VARCHAR2	(128)

Query Text

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


SELECT DOC_ID
,      RULE_TYPE_ID
,      ANON_ACTION_TYPE_ID
,      ANON_VALUE
FROM ORDSYS.ORDDCM_ANON_RULES_WRK;

Dependencies

[top of page]

ORDSYS.ORDDCM_ANON_RULES_WRK does not reference any database object

ORDSYS.ORDDCM_ANON_RULES_WRK is not referenced by any database object