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: DOM.DOM_RELATIONSHIPS

Object Details

Object Name:	DOM_RELATIONSHIPS
Object Type:	TABLE
Owner:	DOM
FND Design Data:	DOM.DOM_RELATIONSHIPS
Subobject Name:
Status:	VALID

This table stores information about how the documents relate to each other.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
DOM_RELATIONSHIPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FROM_ENTITY_NAME FROM_PK1_VALUE FROM_PK2_VALUE FROM_PK3_VALUE FROM_PK4_VALUE FROM_PK5_VALUE
DOM_RELATIONSHIPS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TO_ENTITY_NAME TO_PK1_VALUE TO_PK2_VALUE TO_PK3_VALUE TO_PK4_VALUE TO_PK5_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
FROM_ENTITY_NAME	VARCHAR2	(100)	Yes	From entity name eg. entity could be a document entity
FROM_PK1_VALUE	VARCHAR2	(100)	Yes	Primary key of the from entity
FROM_PK2_VALUE	VARCHAR2	(100)	Yes	Primary key of the from entity
FROM_PK3_VALUE	VARCHAR2	(100)		Primary key of the from entity
FROM_PK4_VALUE	VARCHAR2	(100)		Primary key of the from entity
FROM_PK5_VALUE	VARCHAR2	(100)		Primary key of the from entity
TO_ENTITY_NAME	VARCHAR2	(100)	Yes	To entity name, eg. could be a document entity
TO_PK1_VALUE	VARCHAR2	(100)	Yes	Primary key of the to entity
TO_PK2_VALUE	VARCHAR2	(100)	Yes	Primary key of the to entity
TO_PK3_VALUE	VARCHAR2	(100)		Primary key of the to entity
TO_PK4_VALUE	VARCHAR2	(100)		Primary key of the to entity
TO_PK5_VALUE	VARCHAR2	(100)		Primary key of the to entity
RELATIONSHIP_CODE	VARCHAR2	(100)	Yes	Relationship between the entities
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column
ASSOCIATION_ID	NUMBER		Yes	Associationid between two entities

Query Text

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


SELECT FROM_ENTITY_NAME
,      FROM_PK1_VALUE
,      FROM_PK2_VALUE
,      FROM_PK3_VALUE
,      FROM_PK4_VALUE
,      FROM_PK5_VALUE
,      TO_ENTITY_NAME
,      TO_PK1_VALUE
,      TO_PK2_VALUE
,      TO_PK3_VALUE
,      TO_PK4_VALUE
,      TO_PK5_VALUE
,      RELATIONSHIP_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ASSOCIATION_ID
FROM DOM.DOM_RELATIONSHIPS;

Dependencies

[top of page]

DOM.DOM_RELATIONSHIPS does not reference any database object

DOM.DOM_RELATIONSHIPS is referenced by following:

APPS: DOM_RELATIONSHIPS