[Home] [Help] [Dependency Information]

TABLE: ORDSYS.ORDDCM_DOCS_WRK

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: ORDDCM_DOCS_W_PK

1. DOC_ID

Unique Key: ORDDCM_DOCS_W_UK1

1. DOC_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
ORDDCM_DOCS_W_PK	NORMAL	UNIQUE	SYSTEM	DOC_ID
ORDDCM_DOCS_W_UK1	NORMAL	UNIQUE	SYSTEM	DOC_NAME
SYS_IL0000488138C00005$$	LOB	UNIQUE	SYSTEM

Foreign Keys

Table		Foreign Table	Foreign Key Column
ORDDCM_DOCS_WRK		ORDDCM_DOC_TYPES	ORDDCM_DOCS_WRK DOC_TYPE_ID
ORDDCM_ANON_ATTRS_WRK		ORDDCM_DOCS_WRK	ORDDCM_ANON_ATTRS_WRK DOC_ID
ORDDCM_ANON_RULES_WRK		ORDDCM_DOCS_WRK	ORDDCM_ANON_RULES_WRK DOC_ID
ORDDCM_CT_DAREFS_WRK		ORDDCM_DOCS_WRK	ORDDCM_CT_DAREFS_WRK DOC_ID
ORDDCM_DOC_REFS_WRK		ORDDCM_DOCS_WRK	ORDDCM_DOC_REFS_WRK DOC_ID
ORDDCM_DOC_REFS_WRK		ORDDCM_DOCS_WRK	ORDDCM_DOC_REFS_WRK REF_BY_DOC_ID
ORDDCM_DOC_REFS_WRK		ORDDCM_DOCS_WRK	ORDDCM_DOC_REFS_WRK DOC_NAME
ORDDCM_DOC_REFS_WRK		ORDDCM_DOCS_WRK	ORDDCM_DOC_REFS_WRK REF_BY_DOC_NAME
ORDDCM_MAPPING_DOCS_WRK		ORDDCM_DOCS_WRK	ORDDCM_MAPPING_DOCS_WRK DOC_ID
ORDDCM_PRV_ATTRS_WRK		ORDDCM_DOCS_WRK	ORDDCM_PRV_ATTRS_WRK DOC_ID
ORDDCM_RT_PREF_PARAMS_WRK		ORDDCM_DOCS_WRK	ORDDCM_RT_PREF_PARAMS_WRK DOC_ID
ORDDCM_STD_ATTRS_WRK		ORDDCM_DOCS_WRK	ORDDCM_STD_ATTRS_WRK DOC_ID
ORDDCM_UID_DEFS_WRK		ORDDCM_DOCS_WRK	ORDDCM_UID_DEFS_WRK DOC_ID

Columns

Query Text

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

SELECT DOC_ID
,      DOC_NAME
,      DOC_TYPE_ID
,      DOC_CONTENT
,      ORACLE_INSTALL
,      CREATE_DATE
FROM ORDSYS.ORDDCM_DOCS_WRK;

Dependencies

[top of page]

SYS

STANDARD - show dependent code

XMLTYPE

ORDSYS.ORDDCM_DOCS_WRK is not referenced by any database object