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

TABLE: APPLSYS.FND_LOBS_DOCUMENT

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


- WebDB 2.5 populates (inserts into) these document tables during upload.
- GFM then moves the rows to the FND_LOBS table and clears these document tables.
- These document tables are basically temporary resting points for data and should
always end up with zero rows


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000034093C00007$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000034093C00008$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (256) Yes the document file name
MIME_TYPE VARCHAR2 (48)
the mime type (ie: text/html)
DOC_SIZE NUMBER

document length
DAD_CHARSET VARCHAR2 (128)
DAD charset
LAST_UPDATED DATE

timestamp
CONTENT_TYPE VARCHAR2 (128)
interMedia (TEXT or BINARY)
BLOB_CONTENT BLOB (4000)
the document itself
CONTENT BLOB (4000)
(not used)
Query Text

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


SELECT NAME
,      MIME_TYPE
,      DOC_SIZE
,      DAD_CHARSET
,      LAST_UPDATED
,      CONTENT_TYPE
,      BLOB_CONTENT
,      CONTENT
FROM APPLSYS.FND_LOBS_DOCUMENT;

Dependencies

[top of page]

APPLSYS.FND_LOBS_DOCUMENT does not reference any database object

APPLSYS.FND_LOBS_DOCUMENT is referenced by following:

SchemaAPPLSYS
ViewFND_LOBS_DOCUMENT#