[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
DOM.DOM_RELATIONSHIPS does not reference any database object
DOM.DOM_RELATIONSHIPS is referenced by following:
|
|
|