[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FND_DOCUMENT_CATEGORIES |
|---|---|
| Object Type: | TABLE |
| Owner: | APPLSYS |
| FND Design Data: |  FND.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.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FND_DOCUMENT_CATEGORIES_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 CATEGORY_ID
|
| FND_DOCUMENT_CATEGORIES_U2 | NORMAL | UNIQUE |
APPS_TS_SEED
|
NAME
|
| FND_DOCUMENT_CATEGORIES_N1 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
APPLICATION_ID
|
| 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 |
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
FROM APPLSYS.FND_DOCUMENT_CATEGORIES;
APPLSYS.FND_DOCUMENT_CATEGORIES does not reference any database object
APPLSYS.FND_DOCUMENT_CATEGORIES is referenced by following:
APPS
FND_DOCUMENT_CATEGORIES
|
|
|
|