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

TABLE: APPLSYS.FND_OAM_METALINK_DOCS

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


This table will contain information about Metalink documents


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_OAM_METALINK_DOCS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOC_ID
SYS_IL0000319252C00009$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
DOC_ID VARCHAR2 (30) Yes Id of the metalink document
TITLE VARCHAR2 (1024) Yes Title of the document
DOC_LAST_UPDATE_DATE DATE
Yes Date on which the document was last updated
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
UPDATE_SUMMARY CLOB (4000)
Contains the summary of the changes made to the last revision of the corresponding document.
DOC_LAST_UPDATE_DETECTED_DATE DATE

Contains the date at which the Catalog Refresher Program last updated this row after it detected that the document had changed on Metalink.
Query Text

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


SELECT DOC_ID
,      TITLE
,      DOC_LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      UPDATE_SUMMARY
,      DOC_LAST_UPDATE_DETECTED_DATE
FROM APPLSYS.FND_OAM_METALINK_DOCS;

Dependencies

[top of page]

APPLSYS.FND_OAM_METALINK_DOCS does not reference any database object

APPLSYS.FND_OAM_METALINK_DOCS is referenced by following:

SchemaAPPS
SynonymFND_OAM_METALINK_DOCS