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_ATTRS_WRK

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: ORDDCM_ANON_ATTRS_W_PK1

AAID

Unique Key: ORDDCM_ANON_ATTRS_W_UK1

DOC_ID
TAG

Indexes

Index	Type	Uniqueness	Tablespace	Column
ORDDCM_ANON_ATTRS_W_PK1	NORMAL	UNIQUE	SYSTEM	AAID
ORDDCM_ANON_ATTRS_W_UK1	NORMAL	UNIQUE	SYSTEM	DOC_ID TAG

Foreign Keys

Table	Foreign Table	Foreign Key Column
ORDDCM_ANON_ATTRS_WRK	ORDDCM_ANON_ACTION_TYPES	ORDDCM_ANON_ATTRS_WRK ANON_ACTION_TYPE_ID
ORDDCM_ANON_ATTRS_WRK	ORDDCM_DICT_ATTRS_WRK	ORDDCM_ANON_ATTRS_WRK DA_ID
ORDDCM_ANON_ATTRS_WRK	ORDDCM_DOCS_WRK	ORDDCM_ANON_ATTRS_WRK DOC_ID

Columns

Name	Datatype	Length	Mandatory
AAID	NUMBER	(38)	Yes
DOC_ID	NUMBER	(38)	Yes
TAG	VARCHAR2	(1999)	Yes
DA_ID	NUMBER	(38)	Yes
ANON_ACTION_TYPE_ID	NUMBER		Yes
ANON_VALUE	VARCHAR2	(128)
TAG_DESC	VARCHAR2	(1999)

Query Text

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


SELECT AAID
,      DOC_ID
,      TAG
,      DA_ID
,      ANON_ACTION_TYPE_ID
,      ANON_VALUE
,      TAG_DESC
FROM ORDSYS.ORDDCM_ANON_ATTRS_WRK;

Dependencies

[top of page]

ORDSYS.ORDDCM_ANON_ATTRS_WRK does not reference any database object

ORDSYS.ORDDCM_ANON_ATTRS_WRK is not referenced by any database object