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_DOC_PUBLISH_HIST

Object Details

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

This table stores the history of the published document. Each row provides information about publication date, filename, location document was published from and the user who published the document.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
DOM_DOC_PUBLISH_HIST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOCUMENT_ID REVISION_ID VERSION_ID PUBLISH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_CODE	VARCHAR2	(100)		Template code
DOCUMENT_ID	NUMBER			Document internal id
REVISION_ID	NUMBER			Revision id of the document
VERSION_ID	NUMBER			Version id of the document
PUBLISH_ID	NUMBER			Publish id of the document
PUBLISHED_FILE_NAME	VARCHAR2	(100)		Published file name
PUBLISH_DATE	DATE			Date document was published
PUBLISHED_BY	VARCHAR2	(100)		The user who published the document
REPOSITORY_ID	NUMBER			The repository id of the document
PUBLISH_LOCATION	VARCHAR2	(100)		Location document was published from
CONCURRENT_REQUEST_ID	NUMBER			Concurrent request id
PUBLISH_TEMPLATE_ID	VARCHAR2	(100)		Published template id
OUTPUT_FORMAT_ID	VARCHAR2	(100)		Output format
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)		Standard WHO column

Query Text

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


SELECT TEMPLATE_CODE
,      DOCUMENT_ID
,      REVISION_ID
,      VERSION_ID
,      PUBLISH_ID
,      PUBLISHED_FILE_NAME
,      PUBLISH_DATE
,      PUBLISHED_BY
,      REPOSITORY_ID
,      PUBLISH_LOCATION
,      CONCURRENT_REQUEST_ID
,      PUBLISH_TEMPLATE_ID
,      OUTPUT_FORMAT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM DOM.DOM_DOC_PUBLISH_HIST;

Dependencies

[top of page]

DOM.DOM_DOC_PUBLISH_HIST does not reference any database object

DOM.DOM_DOC_PUBLISH_HIST is referenced by following:

APPS: DOM_DOC_PUBLISH_HIST