Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - DOM Tables and Views

TABLE - DOM.DOM_ATTACHMENT_ENTITIES
TABLE - DOM.DOM_CATEGORY_LIFECYCLES
TABLE - DOM.DOM_CATEGORY_PUB_TEMPL
TABLE - DOM.DOM_DOCUMENTS
TABLE - DOM.DOM_DOCUMENTS_IMTEXT_TL
TABLE - DOM.DOM_DOCUMENTS_TL
TABLE - DOM.DOM_DOCUMENT_CATALOGS
TABLE - DOM.DOM_DOCUMENT_CATALOGS_TL
TABLE - DOM.DOM_DOCUMENT_CATEGORIES
TABLE - DOM.DOM_DOCUMENT_CATEGORIES_TL
TABLE - DOM.DOM_DOCUMENT_REVISIONS
TABLE - DOM.DOM_DOCUMENT_REVISIONS_TL
TABLE - DOM.DOM_DOC_ALT_CAT_ASSOC
TABLE - DOM.DOM_DOC_PUBLISH_FILES
TABLE - DOM.DOM_DOC_PUBLISH_HIST
TABLE - DOM.DOM_DOC_REV_VERSIONS
TABLE - DOM.DOM_DOC_REV_VERSIONS_EXT_B
TABLE - DOM.DOM_DOC_REV_VERSIONS_EXT_TL
TABLE - DOM.DOM_DOC_REV_VERSIONS_TL
TABLE - DOM.DOM_FILE_EXT
TABLE - DOM.DOM_FOLDER_ATTACHMENTS
TABLE - DOM.DOM_FOLDER_FILE_MEMBERSHIPS
TABLE - DOM.DOM_FOLDER_FILE_ROLE_MAP
TABLE - DOM.DOM_OCS_SYNC_PENDING_DATA
TABLE - DOM.DOM_RELATIONSHIPS
TABLE - DOM.DOM_REPOSITORIES
TABLE - DOM.DOM_REPOSITORIES_TL
VIEW - APPS.DOM_DOCUMENTS_VL
VIEW - APPS.DOM_DOCUMENT_CATALOGS_VL
VIEW - APPS.DOM_DOCUMENT_CATEGORIES_VL
VIEW - APPS.DOM_DOCUMENT_ICV
VIEW - APPS.DOM_DOCUMENT_OCV
VIEW - APPS.DOM_DOCUMENT_REVISIONS_VL
VIEW - APPS.DOM_DOC_REV_VERSIONS_EXT_VL
VIEW - APPS.DOM_DOC_REV_VERSIONS_VL
VIEW - APPS.DOM_REPOSITORIES_VL

Table: DOM_ATTACHMENT_ENTITIES

Description: This table holds the security and where-used related apis/sqls for the business entity
Comments

This table stores the security and where-used related apis/sqls for the business entity.

Indexes
Index Type Tablespace Column
DOM_ATTACHMENT_ENTITIES_U1 UNIQUE APPS_TS_TX_IDX ENTITY_NAME
Columns
Name Datatype Length Mandatory Comments
ENTITY_NAME VARCHAR2 (30) Y Business entity Identifier
GET_ROLE_NAMES_SQL VARCHAR2 (2000)
Query that returns the roles associated to the business entity
GET_USERS_PLSQL_API VARCHAR2 (255)
Additional security API for users
GET_ROLE_USERS_PLSQL_API VARCHAR2 (255)
Additional security API for user roles
GET_ATTACH_ACCESS_PLSQL_API VARCHAR2 (255)
API that returns the access on the given attachment for this user.
GET_INSTANCE_NAME_SQL VARCHAR2 (2000)
Business Entity Instance name
INSTANCE_DETAIL_PAGE_URL VARCHAR2 (2000)
Business Entity detail page URL
INSTANCE_WHEREUSED_PAGE_URL VARCHAR2 (2000)
Business Entity where-used page URL
GET_INSTANCE_DESCRIPTION_SQL VARCHAR2 (2000)
Query that returns the description of the associated business entity

[top of page]

DOM.DOM_ATTACHMENT_ENTITIES does not reference any database object

DOM.DOM_ATTACHMENT_ENTITIES is referenced by following:

APPS
SYNONYM - DOM_ATTACHMENT_ENTITIES

[top of page]

Table: DOM_CATEGORY_LIFECYCLES

Description: This table stores the lifecycle of the document categories
Comments

This table stores lifecycle information of the Document Category.

Indexes
Index Type Tablespace Column
DOM_CATEGORY_LIFECYCLES_U1 UNIQUE APPS_TS_TX_IDX CATEGORY_ID
LIFECYCLE_ID
Columns
Name Datatype Length Mandatory Comments
CATEGORY_ID NUMBER (15) Y Category internal id
LIFECYCLE_ID NUMBER (15) Y Lifecycle internal id
END_DATE DATE

Inactive date
CREATION_DATE DATE
Y Standard WHO column
CREATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard WHO column

[top of page]

DOM.DOM_CATEGORY_LIFECYCLES does not reference any database object

DOM.DOM_CATEGORY_LIFECYCLES is referenced by following:

APPS
SYNONYM - DOM_CATEGORY_LIFECYCLES

[top of page]

Table: DOM_CATEGORY_PUB_TEMPL

Description: Document category template intersection table
Comments

This table stores information about the templates associated with the Document Category.

Indexes
Index Type Tablespace Column
DOM_CATEGORY_PUB_TEMPL_U1 UNIQUE APPS_TS_TX_IDX CATEGORY_ID
TEMPLATE_ID
Columns
Name Datatype Length Mandatory Comments
CATEGORY_ID NUMBER (15) Y Category internal identifier
TEMPLATE_ID NUMBER (15) Y Template internal identifier
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_CATEGORY_PUB_TEMPL does not reference any database object

DOM.DOM_CATEGORY_PUB_TEMPL is referenced by following:

APPS
SYNONYM - DOM_CATEGORY_PUB_TEMPL

[top of page]

Table: DOM_DOCUMENTS

Description: Stores document information
Comments

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

Indexes
Index Type Tablespace Column
DOM_DOCUMENTS_U1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
DOM_DOCUMENTS_U2 UNIQUE APPS_TS_TX_IDX DOC_NUMBER
DOM_DOCUMENTS_N1 NONUNIQUE APPS_TS_TX_IDX CATEGORY_ID
DOM_DOCUMENTS_N2 NONUNIQUE APPS_TS_TX_IDX LIFECYCLE_ID
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Document internal id
CATEGORY_ID NUMBER (15) Y Category internal id
DOC_NUMBER VARCHAR2 (50) Y 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) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOCUMENTS does not reference any database object

DOM.DOM_DOCUMENTS is referenced by following:

APPS
SYNONYM - DOM_DOCUMENTS

[top of page]

Table: DOM_DOCUMENTS_IMTEXT_TL

Description:
Comments

This table stores translated Document Text information.

Indexes
Index Type Tablespace Column
DOM_DOCUMENTS_IMTEXT_TL_U1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER
Y Document internal identifier
LANGUAGE VARCHAR2 (4) Y Installed language
TEXT VARCHAR2 (1) Y Text
CREATED_BY NUMBER
Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER
Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column

[top of page]

DOM.DOM_DOCUMENTS_IMTEXT_TL does not reference any database object

DOM.DOM_DOCUMENTS_IMTEXT_TL is referenced by following:

APPS
SYNONYM - DOM_DOCUMENTS_IMTEXT_TL

[top of page]

Table: DOM_DOCUMENTS_TL

Description: Translation table to store document information
Comments

This table stores translated name and description of the Document.

Indexes
Index Type Tablespace Column
DOM_DOCUMENTS_TL_U1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Document internal id
NAME VARCHAR2 (50) Y Document name
DESCRIPTION VARCHAR2 (4000)
Document description
LANGUAGE VARCHAR2 (4) Y Installed language
SOURCE_LANG VARCHAR2 (4) Y Base language
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOCUMENTS_TL does not reference any database object

DOM.DOM_DOCUMENTS_TL is referenced by following:

APPS
SYNONYM - DOM_DOCUMENTS_TL

[top of page]

Table: DOM_DOCUMENT_CATALOGS

Description: Stores the document catalog information
Comments

This table stores Document Catalog information.

Indexes
Index Type Tablespace Column
DOM_DOCUMENT_CATALOGS_U1 UNIQUE APPS_TS_TX_IDX CATALOG_ID
DOM_DOCUMENT_CATALOGS_U2 UNIQUE APPS_TS_TX_IDX INTERNAL_NAME
Columns
Name Datatype Length Mandatory Comments
CATALOG_ID NUMBER (15) Y Catalog internal id
INTERNAL_NAME VARCHAR2 (100)
Internal name
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOCUMENT_CATALOGS does not reference any database object

DOM.DOM_DOCUMENT_CATALOGS is referenced by following:

APPS
SYNONYM - DOM_DOCUMENT_CATALOGS

[top of page]

Table: DOM_DOCUMENT_CATALOGS_TL

Description: Translated catalog information
Comments

This table stores translated name and description of the Document Catalog.

Indexes
Index Type Tablespace Column
DOM_DOCUMENT_CATALOGS_TL_U1 UNIQUE APPS_TS_TX_IDX CATALOG_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
CATALOG_ID NUMBER (15) Y Catalog internal id
INTERNAL_NAME VARCHAR2 (100)
Internal name
NAME VARCHAR2 (50)
Translated name
DESCRIPTION VARCHAR2 (1000)
Translated description
LANGUAGE VARCHAR2 (4) Y Installed language
SOURCE_LANG VARCHAR2 (4) Y Base language
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOCUMENT_CATALOGS_TL does not reference any database object

DOM.DOM_DOCUMENT_CATALOGS_TL is referenced by following:

APPS
SYNONYM - DOM_DOCUMENT_CATALOGS_TL

[top of page]

Table: DOM_DOCUMENT_CATEGORIES

Description: Stores document categories
Comments

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.

Indexes
Index Type Tablespace Column
DOM_DOCUMENT_CATEGORIES_U1 UNIQUE APPS_TS_TX_IDX CATEGORY_ID
DOM_DOCUMENT_CATEGORIES_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_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) Y Catalog internal id
CATEGORY_ID NUMBER (15) Y 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) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOCUMENT_CATEGORIES does not reference any database object

DOM.DOM_DOCUMENT_CATEGORIES is referenced by following:

APPS
SYNONYM - DOM_DOCUMENT_CATEGORIES

[top of page]

Table: DOM_DOCUMENT_CATEGORIES_TL

Description: Translated table for document categories
Comments

This table captures translated name and description of the Document Category.

Indexes
Index Type Tablespace Column
DOM_DOCUMENT_CATEGORIES_TL_U1 UNIQUE APPS_TS_TX_IDX CATEGORY_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
CATALOG_ID NUMBER (15) Y Catalog internal id
CATEGORY_ID NUMBER (15) Y Category internal id
LANGUAGE VARCHAR2 (4) Y Installed language
SOURCE_LANG VARCHAR2 (4) Y Base language
NAME VARCHAR2 (80) Y Translated category name
DESCRIPTION VARCHAR2 (240)
Translated category description
CREATION_DATE DATE
Y Standard WHO column
CREATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOCUMENT_CATEGORIES_TL does not reference any database object

DOM.DOM_DOCUMENT_CATEGORIES_TL is referenced by following:

APPS
SYNONYM - DOM_DOCUMENT_CATEGORIES_TL

[top of page]

Table: DOM_DOCUMENT_REVISIONS

Description: Stores document revision information
Comments

This table stores Document Revision information. Each row provides information about revision status, check out information and associated life cycle phase.

Indexes
Index Type Tablespace Column
DOM_DOCUMENT_REVISIONS_U1 UNIQUE APPS_TS_TX_IDX REVISION_ID
DOM_DOCUMENT_REVISIONS_U2 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
REVISION_ID
DOM_DOCUMENT_REVISIONS_N1 NONUNIQUE APPS_TS_TX_IDX LIFECYCLE_TRACKING_ID
DOM_DOCUMENT_REVISIONS_N2 NONUNIQUE APPS_TS_TX_IDX DOCUMENT_ID
DOM_DOCUMENT_REVISIONS_N3 NONUNIQUE APPS_TS_TX_IDX LIFECYCLE_PHASE_ID
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Document internal id
REVISION_ID NUMBER (15) Y Document revision internal id
CATEGORY_ID NUMBER (15) Y Category in which the document revision belongs to
REVISION VARCHAR2 (25) Y Revision label
CHECKOUT_STATUS VARCHAR2 (20)
Status indicating if the revision has been checked out
CHECKED_OUT_BY NUMBER (15)
User who checked out the revision
STATUS_CODE VARCHAR2 (30)
Status of the revision
CREATION_REASON VARCHAR2 (50)
Reason the revision was created
COMMENTS VARCHAR2 (1000)
Any other comments
LIFECYCLE_PHASE_ID NUMBER (15)
Lifecycle phase id
LIFECYCLE_TRACKING_ID NUMBER (15)
Lifecycle tracking id
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOCUMENT_REVISIONS does not reference any database object

DOM.DOM_DOCUMENT_REVISIONS is referenced by following:

APPS
SYNONYM - DOM_DOCUMENT_REVISIONS

[top of page]

Table: DOM_DOCUMENT_REVISIONS_TL

Description: Translated table that stores document revisions
Comments

This table stores translated information of the revision.

Indexes
Index Type Tablespace Column
DOM_DOCUMENT_REVISIONS_TL_U1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
REVISION_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Document internal id
REVISION_ID NUMBER (15) Y Revision id
CATEGORY_ID NUMBER (15) Y Category Id
LANGUAGE VARCHAR2 (4) Y Installed language
SOURCE_LANG VARCHAR2 (4) Y Base language
COMMENTS VARCHAR2 (1000)
Comments
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOCUMENT_REVISIONS_TL does not reference any database object

DOM.DOM_DOCUMENT_REVISIONS_TL is referenced by following:

APPS
SYNONYM - DOM_DOCUMENT_REVISIONS_TL

[top of page]

Table: DOM_DOC_ALT_CAT_ASSOC

Description: Stores document alternate category association
Comments

This table stores information about alternate category associated with the document.

Indexes
Index Type Tablespace Column
DOM_DOC_ALT_CAT_ASSOC_U1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
ALT_CATEGORY_SET_ID
ALT_CATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Document internal id
ALT_CATEGORY_ID NUMBER (15) Y Alternate category internal id
ALT_CATEGORY_SET_ID NUMBER (15) Y Alternate category set internal id
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOC_ALT_CAT_ASSOC does not reference any database object

DOM.DOM_DOC_ALT_CAT_ASSOC is referenced by following:

APPS
SYNONYM - DOM_DOC_ALT_CAT_ASSOC

[top of page]

Table: DOM_DOC_PUBLISH_FILES

Description: Stores document publish information
Comments

This table stores information about publication details of the Document. Each row stores information about URL of the published document and publication mode.

Indexes
Index Type Tablespace Column
DOM_DOC_PUBLISH_FILES_U1 UNIQUE APPS_TS_TX_IDX PUBLISH_ID
ATTACHMENT_ID
Columns
Name Datatype Length Mandatory Comments
PUBLISH_ID NUMBER (15)
Publish internal id
ATTACHMENT_ID NUMBER (15)
Attachment internal id
PUBLISH_MODE VARCHAR2 (100)
Mode document was published
PUBLISHED_FILE_URL VARCHAR2 (100)
URL of the published file
MERGE_SEQUENCE NUMBER (15)
MERGE_SEQUENCE
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOC_PUBLISH_FILES does not reference any database object

DOM.DOM_DOC_PUBLISH_FILES is referenced by following:

APPS
SYNONYM - DOM_DOC_PUBLISH_FILES

[top of page]

Table: DOM_DOC_PUBLISH_HIST

Description: Stores document publish history
Comments

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.

Indexes
Index Type Tablespace Column
DOM_DOC_PUBLISH_HIST_U1 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) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOC_PUBLISH_HIST does not reference any database object

DOM.DOM_DOC_PUBLISH_HIST is referenced by following:

APPS
SYNONYM - DOM_DOC_PUBLISH_HIST

[top of page]

Table: DOM_DOC_REV_VERSIONS

Description: Stores the versions of document revisions
Comments

This table stores the revision version number of the Document.

Indexes
Index Type Tablespace Column
DOM_DOC_REV_VERSIONS_U1 UNIQUE APPS_TS_TX_IDX REVISION_ID
VERSION_ID
DOM_DOC_REV_VERSIONS_U2 UNIQUE APPS_TS_TX_IDX VERSION_ID
DOM_DOC_REV_VERSIONS_N1 NONUNIQUE APPS_TS_TX_IDX DOCUMENT_ID
DOM_DOC_REV_VERSIONS_N2 NONUNIQUE APPS_TS_TX_IDX REVISION_ID
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Document internal id
REVISION_ID NUMBER (15) Y Revision internal id
VERSION_ID NUMBER (15) Y Version id
VERSION NUMBER (15) Y Version label
COMMENTS VARCHAR2 (1000)
Comments
STATUS_CODE VARCHAR2 (30)
Status code
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOC_REV_VERSIONS does not reference any database object

DOM.DOM_DOC_REV_VERSIONS is referenced by following:

APPS
SYNONYM - DOM_DOC_REV_VERSIONS

[top of page]

Table: DOM_DOC_REV_VERSIONS_EXT_B

Description: Stores document revision versions supporting extensible attributes
Comments

This table stores extensible attributes supporting revision versions.

Indexes
Index Type Tablespace Column
DOM_DOC_REV_VERSIONS_EXT_B_U1 UNIQUE APPS_TS_TX_IDX EXTENSION_ID
DOM_DOC_REV_VERSIONS_EXT_B_N1 NONUNIQUE APPS_TS_TX_IDX DOCUMENT_ID
REVISION_ID
VERSION_ID
Columns
Name Datatype Length Mandatory Comments
ATTR_GROUP_ID NUMBER (15)
Attribute group internal id
CATEGORY_ID NUMBER (15)
Category id
DOCUMENT_ID NUMBER (15) Y Document internal id
REVISION_ID NUMBER (15) Y Revision id
VERSION_ID NUMBER (15) Y Version id
EXTENSION_ID NUMBER
Y Extension id
C_EXT_ATTR1 VARCHAR2 (100)
Character extension column
C_EXT_ATTR2 VARCHAR2 (100)
Character extension column
C_EXT_ATTR3 VARCHAR2 (100)
Character extension column
C_EXT_ATTR4 VARCHAR2 (100)
Character extension column
C_EXT_ATTR5 VARCHAR2 (100)
Character extension column
C_EXT_ATTR6 VARCHAR2 (100)
Character extension column
C_EXT_ATTR7 VARCHAR2 (100)
Character extension column
C_EXT_ATTR8 VARCHAR2 (100)
Character extension column
C_EXT_ATTR9 VARCHAR2 (100)
Character extension column
C_EXT_ATTR10 VARCHAR2 (100)
Character extension column
C_EXT_ATTR11 VARCHAR2 (100)
Character extension column
C_EXT_ATTR12 VARCHAR2 (100)
Character extension column
C_EXT_ATTR13 VARCHAR2 (100)
Character extension column
C_EXT_ATTR14 VARCHAR2 (100)
Character extension column
C_EXT_ATTR15 VARCHAR2 (100)
Character extension column
C_EXT_ATTR16 VARCHAR2 (100)
Character extension column
C_EXT_ATTR17 VARCHAR2 (100)
Character extension column
C_EXT_ATTR18 VARCHAR2 (100)
Character extension column
C_EXT_ATTR19 VARCHAR2 (100)
Character extension column
C_EXT_ATTR20 VARCHAR2 (100)
Character extension column
C_EXT_ATTR21 VARCHAR2 (100)
Character extension column
C_EXT_ATTR22 VARCHAR2 (100)
Character extension column
C_EXT_ATTR23 VARCHAR2 (100)
Character extension column
C_EXT_ATTR24 VARCHAR2 (100)
Character extension column
C_EXT_ATTR25 VARCHAR2 (100)
Character extension column
C_EXT_ATTR26 VARCHAR2 (100)
Character extension column
C_EXT_ATTR27 VARCHAR2 (100)
Character extension column
C_EXT_ATTR28 VARCHAR2 (100)
Character extension column
C_EXT_ATTR29 VARCHAR2 (100)
Character extension column
C_EXT_ATTR30 VARCHAR2 (100)
Character extension column
C_EXT_ATTR31 VARCHAR2 (100)
Character extension column
C_EXT_ATTR32 VARCHAR2 (100)
Character extension column
C_EXT_ATTR33 VARCHAR2 (100)
Character extension column
C_EXT_ATTR34 VARCHAR2 (100)
Character extension column
C_EXT_ATTR35 VARCHAR2 (100)
Character extension column
C_EXT_ATTR36 VARCHAR2 (100)
Character extension column
C_EXT_ATTR37 VARCHAR2 (100)
Character extension column
C_EXT_ATTR38 VARCHAR2 (100)
Character extension column
C_EXT_ATTR39 VARCHAR2 (100)
Character extension column
C_EXT_ATTR40 VARCHAR2 (100)
Character extension column
N_EXT_ATTR1 NUMBER

Number extension column
N_EXT_ATTR2 NUMBER

Number extension column
N_EXT_ATTR3 NUMBER

Number extension column
N_EXT_ATTR4 NUMBER

Number extension column
N_EXT_ATTR5 NUMBER

Number extension column
N_EXT_ATTR6 NUMBER

Number extension column
N_EXT_ATTR7 NUMBER

Number extension column
N_EXT_ATTR8 NUMBER

Number extension column
N_EXT_ATTR9 NUMBER

Number extension column
N_EXT_ATTR10 NUMBER

Number extension column
N_EXT_ATTR11 NUMBER

Number extension column
N_EXT_ATTR12 NUMBER

Number extension column
N_EXT_ATTR13 NUMBER

Number extension column
N_EXT_ATTR14 NUMBER

Number extension column
N_EXT_ATTR15 NUMBER

Number extension column
N_EXT_ATTR16 NUMBER

Number extension column
N_EXT_ATTR17 NUMBER

Number extension column
N_EXT_ATTR18 NUMBER

Number extension column
N_EXT_ATTR19 NUMBER

Number extension column
N_EXT_ATTR20 NUMBER

Number extension column
D_EXT_ATTR1 DATE

Date extension column
D_EXT_ATTR2 DATE

Date extension column
D_EXT_ATTR3 DATE

Date extension column
D_EXT_ATTR4 DATE

Date extension column
D_EXT_ATTR5 DATE

Date extension column
D_EXT_ATTR6 DATE

Date extension column
D_EXT_ATTR7 DATE

Date extension column
D_EXT_ATTR8 DATE

Date extension column
D_EXT_ATTR9 DATE

Date extension column
D_EXT_ATTR10 DATE

Date extension column
UOM_EXT_ATTR1 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR1
UOM_EXT_ATTR2 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR2
UOM_EXT_ATTR3 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR3
UOM_EXT_ATTR4 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR4
UOM_EXT_ATTR5 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR5
UOM_EXT_ATTR6 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR6
UOM_EXT_ATTR7 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR7
UOM_EXT_ATTR8 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR8
UOM_EXT_ATTR9 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR9
UOM_EXT_ATTR10 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR10
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
UOM_EXT_ATTR11 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR11
UOM_EXT_ATTR12 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR12
UOM_EXT_ATTR13 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR13
UOM_EXT_ATTR14 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR14
UOM_EXT_ATTR15 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR15
UOM_EXT_ATTR16 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR16
UOM_EXT_ATTR17 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR17
UOM_EXT_ATTR18 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR18
UOM_EXT_ATTR19 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR19
UOM_EXT_ATTR20 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR20

[top of page]

DOM.DOM_DOC_REV_VERSIONS_EXT_B does not reference any database object

DOM.DOM_DOC_REV_VERSIONS_EXT_B is referenced by following:

APPS
SYNONYM - DOM_DOC_REV_VERSIONS_EXT_B

[top of page]

Table: DOM_DOC_REV_VERSIONS_EXT_TL

Description: Translated table for document revision versions extensions
Comments

This table stores translated extension attributes of the revision versions.

Indexes
Index Type Tablespace Column
DOM_DOC_REV_VERSIONS_EXT_TL_U1 UNIQUE APPS_TS_TX_IDX EXTENSION_ID
LANGUAGE
DOM_DOC_REV_VERSIONS_EXT_TL_N1 NONUNIQUE APPS_TS_TX_IDX DOCUMENT_ID
REVISION_ID
VERSION_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SOURCE_LANG VARCHAR2 (30)
Base language
ATTR_GROUP_ID NUMBER (15)
Attribute group internal id
CATEGORY_ID NUMBER (15)
Category id
DOCUMENT_ID NUMBER (15) Y Document id
REVISION_ID NUMBER (15) Y Revision id
VERSION_ID NUMBER (15) Y Version id
EXTENSION_ID NUMBER (15) Y Extension id
LANGUAGE VARCHAR2 (30) Y Language
TL_EXT_ATTR1 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR2 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR3 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR4 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR5 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR6 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR7 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR8 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR9 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR10 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR11 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR12 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR13 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR14 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR15 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR16 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR17 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR18 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR19 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR20 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR21 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR22 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR23 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR24 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR25 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR26 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR27 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR28 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR29 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR30 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR31 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR32 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR33 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR34 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR35 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR36 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR37 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR38 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR39 VARCHAR2 (1000)
Column name of extensible attribute
TL_EXT_ATTR40 VARCHAR2 (1000)
Column name of extensible attribute
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOC_REV_VERSIONS_EXT_TL does not reference any database object

DOM.DOM_DOC_REV_VERSIONS_EXT_TL is referenced by following:

APPS
SYNONYM - DOM_DOC_REV_VERSIONS_EXT_TL

[top of page]

Table: DOM_DOC_REV_VERSIONS_TL

Description: Translated table to store document revision versions
Comments

This table stores translated information of the revision versions.

Indexes
Index Type Tablespace Column
DOM_DOC_REV_VERSIONS_TL_U1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
REVISION_ID
VERSION_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Document id
REVISION_ID NUMBER (15) Y Revision id
VERSION_ID NUMBER (15) Y Version id
LANGUAGE VARCHAR2 (4) Y Installed language
SOURCE_LANG VARCHAR2 (4) Y Base language
COMMENTS VARCHAR2 (1000)
Comments
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

DOM.DOM_DOC_REV_VERSIONS_TL does not reference any database object

DOM.DOM_DOC_REV_VERSIONS_TL is referenced by following:

APPS
SYNONYM - DOM_DOC_REV_VERSIONS_TL

[top of page]

Table: DOM_FILE_EXT

Description: Stores the status of webservices document
Comments

Stores the status of webservices document

Indexes
Index Type Tablespace Column
DOM_FILE_EXT_U1 UNIQUE APPS_TS_TX_IDX VERSION_ID
REPOSITORY_ID
Columns
Name Datatype Length Mandatory Comments
REPOSITORY_ID NUMBER (15)
Repository id
VERSION_ID NUMBER (15)
Version id of the document
STATUS VARCHAR2 (30)
Status of the document

[top of page]

DOM.DOM_FILE_EXT does not reference any database object

DOM.DOM_FILE_EXT is referenced by following:

APPS
SYNONYM - DOM_FILE_EXT

[top of page]

Table: DOM_FOLDER_ATTACHMENTS

Description: This table specifies whether the attached folder is the default folder
Comments

This table specifies whether the attached folder is the default folder.

Indexes
Index Type Tablespace Column
DOM_FOLDER_ATTACHMENTS_U1 UNIQUE APPS_TS_TX_IDX ATTACHMENT_ID
Columns
Name Datatype Length Mandatory Comments
ATTACHMENT_ID NUMBER (15) Y Attachment Identifier
DEFAULT_FOLDER VARCHAR2 (1)
Flag indicating whether this is the default folder

[top of page]

DOM.DOM_FOLDER_ATTACHMENTS does not reference any database object

DOM.DOM_FOLDER_ATTACHMENTS is referenced by following:

APPS
SYNONYM - DOM_FOLDER_ATTACHMENTS

[top of page]

Table: DOM_FOLDER_FILE_MEMBERSHIPS

Description: Stores the folder and file memberships
Comments

Stores the folder and file memberships

Columns
Name Datatype Length Mandatory Comments
REPOSITORY_ID NUMBER

Repository identifier
REPOSITORY_ITEM_ID NUMBER (15) Y Repository item id
REPOSITORY_ITEM_TYPE VARCHAR2 (15)
Type of the item
ENTITY_NAME VARCHAR2 (30) Y Entity name
PK1_VALUE VARCHAR2 (255) Y Primary key of the entity
PK2_VALUE VARCHAR2 (255)
Primary key of the entity
PK3_VALUE VARCHAR2 (255)
Primary key of the entity
PK4_VALUE VARCHAR2 (255)
Primary key of the entity
PK5_VALUE VARCHAR2 (255)
Primary key of the entity
PARTY_TYPE VARCHAR2 (15)
Party type
PARTY_ID NUMBER (15)
Party identifier
EBS_ROLE VARCHAR2 (30)
EBS Role
OFO_ROLE VARCHAR2 (30)
OFO role
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard WHO column

[top of page]

DOM.DOM_FOLDER_FILE_MEMBERSHIPS does not reference any database object

DOM.DOM_FOLDER_FILE_MEMBERSHIPS is referenced by following:

APPS
SYNONYM - DOM_FOLDER_FILE_MEMBERSHIPS

[top of page]

Table: DOM_FOLDER_FILE_ROLE_MAP

Description: Stores mapping information about folder and files
Comments

Stores mapping information about folder and files

Columns
Name Datatype Length Mandatory Comments
REPOSITORY_ID NUMBER

Repository identifier
REPOSITORY_ITEM_ID NUMBER (15) Y Repository item id
REPOSITORY_ITEM_TYPE VARCHAR2 (15)
Repository item type
ENTITY_NAME VARCHAR2 (30) Y Entity Name
PK1_VALUE VARCHAR2 (255) Y Primary key of the entity
PK2_VALUE VARCHAR2 (255)
Primary key of the entity
PK3_VALUE VARCHAR2 (255)
Primary key of the entity
PK4_VALUE VARCHAR2 (255)
Primary key of the entity
PK5_VALUE VARCHAR2 (255)
Primary key of the entity
EBS_ROLE VARCHAR2 (30)
EBS Role
OFO_ROLE VARCHAR2 (30)
OFO Role
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard WHO column

[top of page]

DOM.DOM_FOLDER_FILE_ROLE_MAP does not reference any database object

DOM.DOM_FOLDER_FILE_ROLE_MAP is referenced by following:

APPS
SYNONYM - DOM_FOLDER_FILE_ROLE_MAP

[top of page]

Table: DOM_OCS_SYNC_PENDING_DATA

Description: DOM_OCS_SYNC_PENDING_DATA
Comments

DOM_OCS_SYNC_PENDING_DATA

Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15)
Standard WHO column
PROCESS_ID NUMBER (15) Y Process internal id
CAT_ID NUMBER (15)
Category id
DOC_ID NUMBER (15)
Document id
REV_ID NUMBER (15)
Revision id
CHANGE_ID NUMBER (15)
Change Id
USER_ID NUMBER (15)
User id
GRP_ID NUMBER (15)
Group id
EBS_ROLE NUMBER (15)
EBS Role id
OCS_ROLE VARCHAR2 (30)
OCS Role id
ST_DATE DATE

Start date
ED_DATE DATE

End Date
REP_ID NUMBER (15)
REp_ID
PROCESS_FLAG VARCHAR2 (30)
Flag to indicate if the data has been processed or approved
CREATION_DATE DATE

Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column

[top of page]

DOM.DOM_OCS_SYNC_PENDING_DATA does not reference any database object

DOM.DOM_OCS_SYNC_PENDING_DATA is referenced by following:

APPS
SYNONYM - DOM_OCS_SYNC_PENDING_DATA

[top of page]

Table: DOM_RELATIONSHIPS

Description: Stores how the documents relate to each other
Comments

This table stores information about how the documents relate to each other.

Indexes
Index Type Tablespace Column
DOM_RELATIONSHIPS_N1 NONUNIQUE APPS_TS_TX_IDX FROM_ENTITY_NAME
FROM_PK1_VALUE
FROM_PK2_VALUE
FROM_PK3_VALUE
FROM_PK4_VALUE
FROM_PK5_VALUE
DOM_RELATIONSHIPS_N2 NONUNIQUE APPS_TS_TX_IDX TO_ENTITY_NAME
TO_PK1_VALUE
TO_PK2_VALUE
TO_PK3_VALUE
TO_PK4_VALUE
TO_PK5_VALUE
Columns
Name Datatype Length Mandatory Comments
FROM_ENTITY_NAME VARCHAR2 (100) Y From entity name eg. entity could be a document entity
FROM_PK1_VALUE VARCHAR2 (100) Y Primary key of the from entity
FROM_PK2_VALUE VARCHAR2 (100) Y Primary key of the from entity
FROM_PK3_VALUE VARCHAR2 (100)
Primary key of the from entity
FROM_PK4_VALUE VARCHAR2 (100)
Primary key of the from entity
FROM_PK5_VALUE VARCHAR2 (100)
Primary key of the from entity
TO_ENTITY_NAME VARCHAR2 (100) Y To entity name, eg. could be a document entity
TO_PK1_VALUE VARCHAR2 (100) Y Primary key of the to entity
TO_PK2_VALUE VARCHAR2 (100) Y Primary key of the to entity
TO_PK3_VALUE VARCHAR2 (100)
Primary key of the to entity
TO_PK4_VALUE VARCHAR2 (100)
Primary key of the to entity
TO_PK5_VALUE VARCHAR2 (100)
Primary key of the to entity
RELATIONSHIP_CODE VARCHAR2 (100) Y Relationship between the entities
CREATION_DATE DATE
Y Standard WHO column
CREATED_BY NUMBER
Y Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
ASSOCIATION_ID NUMBER
Y Associationid between two entities

[top of page]

DOM.DOM_RELATIONSHIPS does not reference any database object

DOM.DOM_RELATIONSHIPS is referenced by following:

APPS
SYNONYM - DOM_RELATIONSHIPS

[top of page]

Table: DOM_REPOSITORIES

Description: DOM_REPOSITORIES 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.
Comments

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.

Indexes
Index Type Tablespace Column
DOM_REPOSITORIES_U1 UNIQUE APPS_TS_TX_IDX ID
DOM_REPOSITORIES_U2 UNIQUE APPS_TS_TX_IDX SHORT_NAME
DOM_REPOSITORIES_N1 NONUNIQUE APPS_TS_TX_IDX SERVICE_URL
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y Repository internal id
SHORT_NAME VARCHAR2 (10) Y Short name for the repository.
NAME VARCHAR2 (80) Y 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) Y 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) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard WHO column

[top of page]

DOM.DOM_REPOSITORIES does not reference any database object

DOM.DOM_REPOSITORIES is referenced by following:

APPS
SYNONYM - DOM_REPOSITORIES

[top of page]

Table: DOM_REPOSITORIES_TL

Description: This table holds the translated name of the repository.
Comments

This table stores translated name and description of the Document Repository.

Indexes
Index Type Tablespace Column
DOM_REPOSITORIES_TL_U1 UNIQUE APPS_TS_TX_IDX ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y Repository identifier
NAME VARCHAR2 (80) Y Repository Name
DESCRIPTION VARCHAR2 (240)
Description of the repository
LANGUAGE VARCHAR2 (30) Y Language
SOURCE_LANG VARCHAR2 (4) Y Base language
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

DOM.DOM_REPOSITORIES_TL does not reference any database object

DOM.DOM_REPOSITORIES_TL is referenced by following:

APPS
SYNONYM - DOM_REPOSITORIES_TL

[top of page]

View: DOM_DOCUMENTS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Document id
CATEGORY_ID NUMBER (15) Y Category id
NAME VARCHAR2 (50) Y Document name
DOC_NUMBER VARCHAR2 (50) Y Document number
DESCRIPTION VARCHAR2 (4000)
Document description
DEF_REP_ID NUMBER (15)
DEF_REP_ID
DEF_FOLDER_ID NUMBER (15)
Default folder id
LOCK_STATUS VARCHAR2 (15)
Status of the document if it is locked
LOCKED_BY NUMBER (15)
Locked by which user
LIFECYCLE_ID NUMBER (15)
Document lifecycle id
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

APPS.DOM_DOCUMENTS_VL references the following:

APPS
SYNONYM - DOM_DOCUMENTS
SYNONYM - DOM_DOCUMENTS_TL
APPS.DOM_DOCUMENTS_VL is referenced by following:

APPS
PACKAGE BODY - DOM_ASSOCIATIONS_UTIL
PACKAGE BODY - ENG_DOCUMENT_UTIL

[top of page]

View: DOM_DOCUMENT_CATALOGS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
CATALOG_ID NUMBER (15) Y Catalog internal id
INTERNAL_NAME VARCHAR2 (100)
Catalog internal name
NAME VARCHAR2 (50)
Display name
DESCRIPTION VARCHAR2 (1000)
Description
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

APPS.DOM_DOCUMENT_CATALOGS_VL references the following:

APPS
SYNONYM - DOM_DOCUMENT_CATALOGS
SYNONYM - DOM_DOCUMENT_CATALOGS_TL

APPS.DOM_DOCUMENT_CATALOGS_VL is not referenced by any database object

[top of page]

View: DOM_DOCUMENT_CATEGORIES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
DOC_NUM_DBSEQ_NAME VARCHAR2 (30)
Document number database sequence name
DOC_REV_DBSEQ_NAME VARCHAR2 (30)
Document revision db sequence name
CATALOG_ID NUMBER (15) Y Catalog identifier
CATEGORY_ID NUMBER (15) Y Category identifier
PARENT_CATEGORY_ID NUMBER (15)
Parent category identifier
DOC_CREATION_ALLOWED VARCHAR2 (1)
Flag to indicate if document creation is allowed
INACTIVE_ON DATE

Date inactivated
DEFAULT_FOLDER_OPTION VARCHAR2 (250)
Default folder option
DEFAULT_REPOSITORY_ID NUMBER (12)
Default repository identifier
DEFAULT_FOLDER_LOCATION VARCHAR2 (250)
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
DOC_NUM_SCHEME VARCHAR2 (20)
Document numbering scheme
DOC_NUM_PREFIX VARCHAR2 (10)
Document number 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 identifier
DOC_REV_SCHEME VARCHAR2 (25)
Document revision numbering 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 name scheme
DOC_NAME_FUNC_ACTION_ID NUMBER (15)
Document name function action id
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
NAME VARCHAR2 (80) Y Category Name
DESCRIPTION VARCHAR2 (240)
Category description

[top of page]

APPS.DOM_DOCUMENT_CATEGORIES_VL references the following:

APPS
SYNONYM - DOM_DOCUMENT_CATEGORIES
SYNONYM - DOM_DOCUMENT_CATEGORIES_TL

APPS.DOM_DOCUMENT_CATEGORIES_VL is not referenced by any database object

[top of page]

View: DOM_DOCUMENT_ICV

Comments
View Type

A Business Intelligence System view

View used internally in the code

Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Document internal identifier

[top of page]

APPS.DOM_DOCUMENT_ICV references the following:

APPS
SYNONYM - DOM_DOCUMENTS

APPS.DOM_DOCUMENT_ICV is not referenced by any database object

[top of page]

View: DOM_DOCUMENT_OCV

Comments
View Type

A Business Intelligence System view

View used internally in the code

Columns
Name Datatype Length Mandatory Comments
CODE NUMBER (15) Y It is the category Id for the document
LANGUAGE VARCHAR2 (52)
This column signifies the Language Code
MEANING VARCHAR2 (80) Y Column signifies the meaning of the code

[top of page]

APPS.DOM_DOCUMENT_OCV references the following:

APPS
SYNONYM - DOM_DOCUMENT_CATEGORIES_TL

APPS.DOM_DOCUMENT_OCV is not referenced by any database object

[top of page]

View: DOM_DOCUMENT_REVISIONS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Document internal identifier
REVISION_ID NUMBER (15) Y Revision identifier
CATEGORY_ID NUMBER (15) Y Category identifier
REVISION VARCHAR2 (25) Y Revision label
CHECKOUT_STATUS VARCHAR2 (20)
Checkout status
CHECKED_OUT_BY NUMBER (15)
Checked out by which user
STATUS_CODE VARCHAR2 (30)
Status of the document revision
CREATION_REASON VARCHAR2 (50)
Reason for creating the new revision
COMMENTS VARCHAR2 (1000)
Comments
LIFECYCLE_TRACKING_ID NUMBER (15)
Lifecycle tracking identifier
LIFECYCLE_PHASE_ID NUMBER (15)
Lifecycle phase identifier
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

APPS.DOM_DOCUMENT_REVISIONS_VL references the following:

APPS
SYNONYM - DOM_DOCUMENT_REVISIONS
SYNONYM - DOM_DOCUMENT_REVISIONS_TL

APPS.DOM_DOCUMENT_REVISIONS_VL is not referenced by any database object

[top of page]

View: DOM_DOC_REV_VERSIONS_EXT_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Document identifier
REVISION_ID NUMBER (15) Y Revision identifier
VERSION_ID NUMBER (15) Y Version identifier
EXTENSION_ID NUMBER
Y Extension identifier
ATTR_GROUP_ID NUMBER (15)
Attribute group identifier
C_EXT_ATTR1 VARCHAR2 (100)
Character extension attribute
C_EXT_ATTR2 VARCHAR2 (100)
Character extension attribute
C_EXT_ATTR3 VARCHAR2 (100)
Character extension attribute
C_EXT_ATTR4 VARCHAR2 (100)
Character extension attribute
C_EXT_ATTR5 VARCHAR2 (100)
Character extension attribute
C_EXT_ATTR6 VARCHAR2 (100)
Character extension attribute
C_EXT_ATTR7 VARCHAR2 (100)
Character extension attribute
C_EXT_ATTR8 VARCHAR2 (100)
Character extension attribute
C_EXT_ATTR9 VARCHAR2 (100)
Character extension attribute
C_EXT_ATTR10 VARCHAR2 (100)
Character extension attribute
C_EXT_ATTR11 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR12 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR13 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR14 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR15 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR16 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR17 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR18 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR19 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR20 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR21 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR22 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR23 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR24 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR25 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR26 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR27 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR28 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR29 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR30 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR31 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR32 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR33 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR34 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR35 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR36 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR37 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR38 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR39 VARCHAR2 (100)
Character extensible attribute
C_EXT_ATTR40 VARCHAR2 (100)
Character extensible attribute
N_EXT_ATTR1 NUMBER

Numeric extensible attribute
N_EXT_ATTR2 NUMBER

Numeric extensible attribute
N_EXT_ATTR3 NUMBER

Numeric extensible attribute
N_EXT_ATTR4 NUMBER

Numeric extensible attribute
N_EXT_ATTR5 NUMBER

Numeric extensible attribute
N_EXT_ATTR6 NUMBER

Numeric extensible attribute
N_EXT_ATTR7 NUMBER

Numeric extensible attribute
N_EXT_ATTR8 NUMBER

Numeric extensible attribute
N_EXT_ATTR9 NUMBER

Numeric extensible attribute
N_EXT_ATTR10 NUMBER

Numeric extensible attribute
N_EXT_ATTR11 NUMBER

Numeric extensible attribute
N_EXT_ATTR12 NUMBER

Numeric extensible attribute
N_EXT_ATTR13 NUMBER

Numeric extensible attribute
N_EXT_ATTR14 NUMBER

Numeric extensible attribute
N_EXT_ATTR15 NUMBER

Numeric extensible attribute
N_EXT_ATTR16 NUMBER

Numeric extensible attribute
N_EXT_ATTR17 NUMBER

Numeric extensible attribute
N_EXT_ATTR18 NUMBER

Numeric extensible attribute
N_EXT_ATTR19 NUMBER

Numeric extensible attribute
N_EXT_ATTR20 NUMBER

Numeric extensible attribute
D_EXT_ATTR1 DATE

Date extensible attribute
D_EXT_ATTR2 DATE

Date extensible attribute
D_EXT_ATTR3 DATE

Date extensible attribute
D_EXT_ATTR4 DATE

Date extensible attribute
D_EXT_ATTR5 DATE

Date extensible attribute
D_EXT_ATTR6 DATE

Date extensible attribute
D_EXT_ATTR7 DATE

Date extensible attribute
D_EXT_ATTR8 DATE

Date extensible attribute
D_EXT_ATTR9 DATE

Date extensible attribute
D_EXT_ATTR10 DATE

Date extensible attribute
UOM_EXT_ATTR1 VARCHAR2 (30)
Unit of measure extensible attribute mapped to Numeric extensible attribute
UOM_EXT_ATTR2 VARCHAR2 (30)
Unit of measure extensible attribute mapped to Numeric extensible attribute
UOM_EXT_ATTR3 VARCHAR2 (30)
Unit of measure extensible attribute mapped to Numeric extensible attribute
UOM_EXT_ATTR4 VARCHAR2 (30)
Unit of measure extensible attribute mapped to Numeric extensible attribute
UOM_EXT_ATTR5 VARCHAR2 (30)
Unit of measure extensible attribute mapped to Numeric extensible attribute
UOM_EXT_ATTR6 VARCHAR2 (30)
Unit of measure extensible attribute mapped to Numeric extensible attribute
UOM_EXT_ATTR7 VARCHAR2 (30)
Unit of measure extensible attribute mapped to Numeric extensible attribute
UOM_EXT_ATTR8 VARCHAR2 (30)
Unit of measure extensible attribute mapped to Numeric extensible attribute
UOM_EXT_ATTR9 VARCHAR2 (30)
Unit of measure extensible attribute mapped to Numeric extensible attribute
UOM_EXT_ATTR10 VARCHAR2 (30)
Unit of measure extensible attribute mapped to Numeric extensible attribute
UOM_EXT_ATTR11 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR11
UOM_EXT_ATTR12 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR12
UOM_EXT_ATTR13 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR13
UOM_EXT_ATTR14 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR14
UOM_EXT_ATTR15 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR15
UOM_EXT_ATTR16 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR16
UOM_EXT_ATTR17 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR17
UOM_EXT_ATTR18 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR18
UOM_EXT_ATTR19 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR19
UOM_EXT_ATTR20 VARCHAR2 (30)
Unit of measurement for N_EXT_ATTR20
TL_EXT_ATTR1 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR2 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR3 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR4 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR5 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR6 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR7 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR8 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR9 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR10 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR11 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR12 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR13 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR14 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR15 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR16 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR17 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR18 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR19 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR20 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR21 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR22 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR23 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR24 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR25 VARCHAR2 (1000)
Tranlation value of the extensible attribute
TL_EXT_ATTR26 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR27 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR28 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR29 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR30 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR31 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR32 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR33 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR34 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR35 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR36 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR37 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR38 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR39 VARCHAR2 (1000)
Tranlated value of the extensible attribute
TL_EXT_ATTR40 VARCHAR2 (1000)
Tranlated value of the extensible attribute
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LANGUAGE VARCHAR2 (30) Y Language
SOURCE_LANG VARCHAR2 (30)
Base language
CATEGORY_ID NUMBER (15)
Category identifier

[top of page]

APPS.DOM_DOC_REV_VERSIONS_EXT_VL references the following:

APPS
SYNONYM - DOM_DOC_REV_VERSIONS_EXT_B
SYNONYM - DOM_DOC_REV_VERSIONS_EXT_TL

APPS.DOM_DOC_REV_VERSIONS_EXT_VL is not referenced by any database object

[top of page]

View: DOM_DOC_REV_VERSIONS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Document identifier
REVISION_ID NUMBER (15) Y Revision identifier
VERSION_ID NUMBER (15) Y Version identifier
VERSION NUMBER (15) Y Version label
COMMENTS VARCHAR2 (1000)
Comments
STATUS_CODE VARCHAR2 (30)
Status code
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

APPS.DOM_DOC_REV_VERSIONS_VL references the following:

APPS
SYNONYM - DOM_DOC_REV_VERSIONS
SYNONYM - DOM_DOC_REV_VERSIONS_TL

APPS.DOM_DOC_REV_VERSIONS_VL is not referenced by any database object

[top of page]

View: DOM_REPOSITORIES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
ID NUMBER
Y Repository id
SHORT_NAME VARCHAR2 (10) Y Repository short name
NAME VARCHAR2 (80) Y Translated name
DESCRIPTION VARCHAR2 (240)
Description
PROTOCOL VARCHAR2 (30)
Protocol used
SERVICE_URL VARCHAR2 (240)
Service URL
DAV_URL VARCHAR2 (240) Y WebDAV URL
SEQUENCE NUMBER

Sequence number
CERTIFICATE_PATH VARCHAR2 (256)
Ceritificate path
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard WHO column

[top of page]

APPS.DOM_REPOSITORIES_VL references the following:

APPS
SYNONYM - DOM_REPOSITORIES
SYNONYM - DOM_REPOSITORIES_TL

APPS.DOM_REPOSITORIES_VL is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract