[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
DOM_DOC_PUBLISH_HIST_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DOCUMENT_ID
REVISION_ID VERSION_ID PUBLISH_ID |
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 |
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;
DOM.DOM_DOC_PUBLISH_HIST does not reference any database object
DOM.DOM_DOC_PUBLISH_HIST is referenced by following:
|
|
|