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

TABLE: DOM.DOM_DOCUMENT_CATEGORIES

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


This table stores information about Document Category. Each row provides information about Default Folder information,Document Numbering information,Document Revision scheme and Document Name scheme.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DOM_DOCUMENT_CATEGORIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCATEGORY_ID
DOM_DOCUMENT_CATEGORIES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_CATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
DOC_REV_DBSEQ_NAME VARCHAR2 (30)
Document revision database sequence name
DOC_NUM_DBSEQ_NAME VARCHAR2 (30)
Document number database sequence name
CATALOG_ID NUMBER (15) Yes Catalog internal id
CATEGORY_ID NUMBER (15) Yes Category internal id
NAME VARCHAR2 (50)
Category name
DESCRIPTION VARCHAR2 (50)
Category description
PARENT_CATEGORY_ID NUMBER (15)
Parent category id
DOC_CREATION_ALLOWED VARCHAR2 (1)
Flag to indicate if document creation is allowed within the category
INACTIVE_ON DATE

Date when the category is inactive
DEFAULT_FOLDER_OPTION VARCHAR2 (250)
Default folder option
DEFAULT_REPOSITORY_ID NUMBER (12)
The default repository id
DEFAULT_FOLDER_LOCATION VARCHAR2 (250)
The default folder location
DEF_FOLDER_NAMING_METHOD VARCHAR2 (250)
Default folder naming method
DEF_FOLDER_PREFIX VARCHAR2 (250)
Default folder prefix
DEF_FOLDER_SUFFIX VARCHAR2 (250)
Default folder suffix if any
DOC_NUM_SCHEME VARCHAR2 (20)
Document numering scheme
DOC_NUM_PREFIX VARCHAR2 (10)
Document numbering prefix
DOC_NUM_START_NUMBER NUMBER (15)
Document numbering start number
DOC_NUM_INCR NUMBER (15)
Document numbering increment
DOC_NUM_SUFFIX VARCHAR2 (25)
Document numbering suffix
DOC_NUM_FUNC_ACTION_ID NUMBER (15)
Document numbering function action internal id
DOC_REV_SCHEME VARCHAR2 (25)
Document revision scheme
DOC_REV_SEEDED_SEQ_CODE VARCHAR2 (15)
Document revision seeded sequence code
DOC_REV_PREFIX VARCHAR2 (14)
Document revision prefix
DOC_REV_START_NUMBER NUMBER (15)
Document revision start number
DOC_REV_INCR NUMBER (15)
Document revision increment
DOC_REV_SUFFIX VARCHAR2 (25)
Document revision suffix
DOC_REV_FUNC_ACTION_ID NUMBER (15)
Document revision function action id
DOC_NAME_SCHEME VARCHAR2 (25)
Document naming scheme
DOC_NAME_FUNC_ACTION_ID NUMBER (15)
Document name function action id
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 DOC_REV_DBSEQ_NAME
,      DOC_NUM_DBSEQ_NAME
,      CATALOG_ID
,      CATEGORY_ID
,      NAME
,      DESCRIPTION
,      PARENT_CATEGORY_ID
,      DOC_CREATION_ALLOWED
,      INACTIVE_ON
,      DEFAULT_FOLDER_OPTION
,      DEFAULT_REPOSITORY_ID
,      DEFAULT_FOLDER_LOCATION
,      DEF_FOLDER_NAMING_METHOD
,      DEF_FOLDER_PREFIX
,      DEF_FOLDER_SUFFIX
,      DOC_NUM_SCHEME
,      DOC_NUM_PREFIX
,      DOC_NUM_START_NUMBER
,      DOC_NUM_INCR
,      DOC_NUM_SUFFIX
,      DOC_NUM_FUNC_ACTION_ID
,      DOC_REV_SCHEME
,      DOC_REV_SEEDED_SEQ_CODE
,      DOC_REV_PREFIX
,      DOC_REV_START_NUMBER
,      DOC_REV_INCR
,      DOC_REV_SUFFIX
,      DOC_REV_FUNC_ACTION_ID
,      DOC_NAME_SCHEME
,      DOC_NAME_FUNC_ACTION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM DOM.DOM_DOCUMENT_CATEGORIES;

Dependencies

[top of page]

DOM.DOM_DOCUMENT_CATEGORIES does not reference any database object

DOM.DOM_DOCUMENT_CATEGORIES is referenced by following:

SchemaAPPS
SynonymDOM_DOCUMENT_CATEGORIES