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

TABLE: APPLSYS.FND_OAM_DOC_CATEGORY_ASSOC

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


This table will contain information about association between document categories


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_OAM_DOC_CATEGORY_ASSOC_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCATEGORY_TYPE
ColumnCATEGORY_KEY
FND_OAM_DOC_CATEGORY_ASSOC_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_CATEGORY_TYPE
ColumnPARENT_CATEGORY_KEY
Columns
Name Datatype Length Mandatory Comments
CATEGORY_KEY VARCHAR2 (40) Yes key for the category
CATEGORY_TYPE VARCHAR2 (30) Yes type of category
PARENT_CATEGORY_KEY VARCHAR2 (40) Yes Key for the parent category
PARENT_CATEGORY_TYPE VARCHAR2 (30) Yes Type for the parent category
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column
Query Text

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


SELECT CATEGORY_KEY
,      CATEGORY_TYPE
,      PARENT_CATEGORY_KEY
,      PARENT_CATEGORY_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPLSYS.FND_OAM_DOC_CATEGORY_ASSOC;

Dependencies

[top of page]

APPLSYS.FND_OAM_DOC_CATEGORY_ASSOC does not reference any database object

APPLSYS.FND_OAM_DOC_CATEGORY_ASSOC is referenced by following:

SchemaAPPLSYS
ViewFND_OAM_DOC_CATEGORY_ASSOC#