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

TABLE: APPLSYS.FND_DOCUMENT_CATEGORIES

Object Details
Object Name: FND_DOCUMENT_CATEGORIES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_DOCUMENT_CATEGORIES
Subobject Name:
Status: VALID


FND_DOCUMENT_CATEGORIES stores information about
the categories in which documents are classified. For
example, documents may be considered "Bill of Material
Comments", "WIP Job Comments", etc. Document categories
are used to provide a measure of security on documents.
Each form that enables the attachment feature lists
which categories of documents can be viewed in the form.
This table uses a "duplicate record" model for handling
multi-lingual needs. That is, for each category there
will be one record with the same CATEGORY_ID and
CATEGORY_NAME for each language.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_DOCUMENT_CATEGORIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCATEGORY_ID
ColumnZD_EDITION_NAME
FND_DOCUMENT_CATEGORIES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnNAME
ColumnZD_EDITION_NAME
FND_DOCUMENT_CATEGORIES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnAPPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
CATEGORY_ID NUMBER
Yes Unique identifier sourced from the FND_DOCUMENTS_CATEGORIES_S sequence
APPLICATION_ID NUMBER

ID of the application that 'owns' the category
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
NAME VARCHAR2 (30) Yes Developer name for the category
START_DATE_ACTIVE DATE

Date on which the current category is available for use (a null value indicates the category is available immediately)
END_DATE_ACTIVE DATE

Date on which the current category is no longer available for use (a null value indicates the category is available indefinitely)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
DEFAULT_DATATYPE_ID NUMBER

Default datatype identifier
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT CATEGORY_ID
,      APPLICATION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DEFAULT_DATATYPE_ID
,      ZD_EDITION_NAME
FROM APPLSYS.FND_DOCUMENT_CATEGORIES;

Dependencies

[top of page]

APPLSYS.FND_DOCUMENT_CATEGORIES does not reference any database object

APPLSYS.FND_DOCUMENT_CATEGORIES is referenced by following:

SchemaAPPLSYS
ViewFND_DOCUMENT_CATEGORIES#