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

VIEW: APPS.DOM_DOCUMENT_CATEGORIES_VL

Object Details
Object Name: DOM_DOCUMENT_CATEGORIES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewDOM.DOM_DOCUMENT_CATEGORIES_VL
Subobject Name:
Status: VALID

View Type

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

[View Source]

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) Yes Catalog identifier
CATEGORY_ID NUMBER (15) Yes 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) 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
NAME VARCHAR2 (80) Yes Category Name
DESCRIPTION VARCHAR2 (240)
Category description
Query Text

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


SELECT ROW_ID
,      DOC_NUM_DBSEQ_NAME
,      DOC_REV_DBSEQ_NAME
,      CATALOG_ID
,      CATEGORY_ID
,      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
,      NAME
,      DESCRIPTION
FROM APPS.DOM_DOCUMENT_CATEGORIES_VL;

Dependencies

[top of page]

APPS.DOM_DOCUMENT_CATEGORIES_VL references the following:

SchemaAPPS
SynonymDOM_DOCUMENT_CATEGORIES
SynonymDOM_DOCUMENT_CATEGORIES_TL

APPS.DOM_DOCUMENT_CATEGORIES_VL is not referenced by any database object