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

TABLE: APPLSYS.FND_DOC_CATEGORY_USAGES

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


FND_DOC_CATEGORY_USAGES stores the relationships
between categories and forms or form functions.
ENABLED_FLAG=Y if category is enabled for the
form/function and vice versa.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_DOC_CATEGORY_USAGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOC_CATEGORY_USAGE_ID
FND_DOC_CATEGORY_USAGES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnATTACHMENT_FUNCTION_ID
ColumnCATEGORY_ID
FND_DOC_CATEGORY_USAGES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
DOC_CATEGORY_USAGE_ID NUMBER
Yes Unique identifier
CATEGORY_ID NUMBER
Yes Unique identifier sourced from the FND_DOCUMENTS_CATEGORIES_S sequence
ATTACHMENT_FUNCTION_ID NUMBER
Yes Attachment function identifier
ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating whether attachment functionality is enabled for the form or form function
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
FORMAT VARCHAR2 (1)
FORMAT
Query Text

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


SELECT DOC_CATEGORY_USAGE_ID
,      CATEGORY_ID
,      ATTACHMENT_FUNCTION_ID
,      ENABLED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FORMAT
FROM APPLSYS.FND_DOC_CATEGORY_USAGES;

Dependencies

[top of page]

APPLSYS.FND_DOC_CATEGORY_USAGES does not reference any database object

APPLSYS.FND_DOC_CATEGORY_USAGES is referenced by following:

SchemaAPPS
SynonymFND_DOC_CATEGORY_USAGES