Skip to content

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

TABLE: QP.QP_DOCUMENTS

Object Details
Object Name: QP_DOCUMENTS
Object Type: TABLE
Owner: QP
Subobject Name:
Status: VALID


This table is used to store formatted price book documents such as .pdf,.rtf files as a blob, along with file name and mime type information. This table may be also used to store any other similar pricing documents in the future.


Storage Details
Tablespace: TablespaceAPPS_TS_MEDIA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QP_DOCUMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_MEDIA ColumnDOCUMENT_ID
SYS_IL0000410491C00002$$ LOB UNIQUE TablespaceAPPS_TS_MEDIA
SYS_IL0000410491C00010$$ LOB UNIQUE TablespaceAPPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER
Yes Primary Key
DOCUMENT_CONTENT BLOB (4000)
Stores the document content
DOCUMENT_CONTENT_TYPE VARCHAR2 (240) Yes MIME type of the document, e.g "application/pdf", etc.
DOCUMENT_NAME VARCHAR2 (240)
Name of the document
CREATION_DATE DATE
Yes standard who columns
CREATED_BY NUMBER
Yes standard who columns
LAST_UPDATE_DATE DATE
Yes standard who columns
LAST_UPDATED_BY NUMBER
Yes standard who columns
LAST_UPDATE_LOGIN NUMBER

standard who columns
XML_CONTENT CLOB (4000)
Query Text

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


SELECT DOCUMENT_ID
,      DOCUMENT_CONTENT
,      DOCUMENT_CONTENT_TYPE
,      DOCUMENT_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      XML_CONTENT
FROM QP.QP_DOCUMENTS;

Dependencies

[top of page]

QP.QP_DOCUMENTS does not reference any database object

QP.QP_DOCUMENTS is referenced by following:

SchemaQP
ViewQP_DOCUMENTS#