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_REPOSITORIES

Object Details

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

It stores information about the Document Management repository that is used to integrate with EBS. Each row contains the name and description of the node, and the physical URL link information for the repository.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
DOM_REPOSITORIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
DOM_REPOSITORIES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHORT_NAME
DOM_REPOSITORIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SERVICE_URL

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Repository internal id
SHORT_NAME	VARCHAR2	(10)	Yes	Short name for the repository.
NAME	VARCHAR2	(80)	Yes	Name of the repository.
DESCRIPTION	VARCHAR2	(240)		Description of the repository.
PROTOCOL	VARCHAR2	(30)		The protocol used to integrate with EBS. Can be WebDAV or WebServices.
SERVICE_URL	VARCHAR2	(240)		URL pointing to the WebService servlet.
DAV_URL	VARCHAR2	(240)	Yes	Content URL. URL that is used to open an WebDAV (Http) connection with the repository.
SEQUENCE	NUMBER			Sequence in which this repository will show up in the user inteface.
CERTIFICATE_PATH	VARCHAR2	(256)		In case the repository is SSL enabled, the full path to the digital certificate in the E-Business Suite middle tier.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard WHO column

Query Text

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


SELECT ID
,      SHORT_NAME
,      NAME
,      DESCRIPTION
,      PROTOCOL
,      SERVICE_URL
,      DAV_URL
,      SEQUENCE
,      CERTIFICATE_PATH
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM DOM.DOM_REPOSITORIES;

Dependencies

[top of page]

DOM.DOM_REPOSITORIES does not reference any database object

DOM.DOM_REPOSITORIES is referenced by following:

DOM: DOM_REPOSITORIES#