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_MAPPED_PATHS_WRK

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: ORDDCM_MAPPED_PATHS_W_PK1

MPID

Unique Key: ORDDCM_MAPPED_PATHS_W_UK1

DOC_ID
ATTR_TAG

Indexes

Index	Type	Uniqueness	Tablespace	Column
ORDDCM_MAPPED_PATHS_W_PK1	NORMAL	UNIQUE	SYSTEM	MPID
ORDDCM_MAPPED_PATHS_W_UK1	NORMAL	UNIQUE	SYSTEM	DOC_ID ATTR_TAG

Foreign Keys

Table		Foreign Table	Foreign Key Column
ORDDCM_MAPPED_PATHS_WRK		ORDDCM_DICT_ATTRS_WRK	ORDDCM_MAPPED_PATHS_WRK DA_ID
ORDDCM_MAPPED_PATHS_WRK		ORDDCM_MAPPING_DOCS_WRK	ORDDCM_MAPPED_PATHS_WRK DOC_ID

Columns

Name	Datatype	Length	Mandatory
MPID	NUMBER	(38)	Yes
ATTR_TAG	VARCHAR2	(1999)	Yes
DA_ID	NUMBER	(38)	Yes
DOC_ID	NUMBER	(38)	Yes
REL_PATH	VARCHAR2	(1999)	Yes
OCCURS	NUMBER	(1)	Yes
NOT_EMPTY	NUMBER	(1)	Yes
WRITE_TAG	NUMBER	(1)	Yes
WRITE_DEFINER	NUMBER	(1)	Yes
WRITE_NAME	NUMBER	(1)	Yes
WRITE_RAW_VALUE	NUMBER	(1)	Yes

Query Text

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


SELECT MPID
,      ATTR_TAG
,      DA_ID
,      DOC_ID
,      REL_PATH
,      OCCURS
,      NOT_EMPTY
,      WRITE_TAG
,      WRITE_DEFINER
,      WRITE_NAME
,      WRITE_RAW_VALUE
FROM ORDSYS.ORDDCM_MAPPED_PATHS_WRK;

Dependencies

[top of page]

ORDSYS.ORDDCM_MAPPED_PATHS_WRK does not reference any database object

ORDSYS.ORDDCM_MAPPED_PATHS_WRK is not referenced by any database object