DBA Data[Home] [Help] [Dependency Information]

TABLE: DOM.DOM_DOCUMENTS

Object Details
Object Name: DOM_DOCUMENTS
Object Type: TABLE
Owner: DOM
FND Design Data: TableDOM.DOM_DOCUMENTS
Subobject Name:
Status: VALID


This table stores the information about the Document. Each row provides information about Document number,Document lock status, folder information and associated life cycle.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DOM_DOCUMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOCUMENT_ID
DOM_DOCUMENTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOC_NUMBER
DOM_DOCUMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCATEGORY_ID
DOM_DOCUMENTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIFECYCLE_ID
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Yes Document internal id
CATEGORY_ID NUMBER (15) Yes Category internal id
DOC_NUMBER VARCHAR2 (50) Yes Document number
DEF_REP_ID NUMBER (15)
DEF_REP_ID
DEF_FOLDER_ID NUMBER (15)
Default folder id
LOCK_STATUS VARCHAR2 (15)
Status indicating if the document is locked by another user
LOCKED_BY NUMBER (15)
Locked by user id
LIFECYCLE_ID NUMBER (15)
Lifecycle id of the document
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 DOCUMENT_ID
,      CATEGORY_ID
,      DOC_NUMBER
,      DEF_REP_ID
,      DEF_FOLDER_ID
,      LOCK_STATUS
,      LOCKED_BY
,      LIFECYCLE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM DOM.DOM_DOCUMENTS;

Dependencies

[top of page]

DOM.DOM_DOCUMENTS does not reference any database object

DOM.DOM_DOCUMENTS is referenced by following:

SchemaAPPS
SynonymDOM_DOCUMENTS