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

TABLE: PRP.PRP_EMAIL_ATTACHMENTS

Object Details
Object Name: PRP_EMAIL_ATTACHMENTS
Object Type: TABLE
Owner: PRP
Subobject Name:
Status: VALID


This table contains the details of the attachment files sent to customers through email.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PRP_EMAIL_ATTACHMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEMAIL_ATTACHMENT_ID
PRP_EMAIL_ATTACHMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEMAIL_HISTORY_ID
Columns
Name Datatype Length Mandatory Comments
EMAIL_ATTACHMENT_ID NUMBER
Yes Emai Attachment Identifier. Primary Key for the table.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object Version Number.
CONTENT_TYPE VARCHAR2 (30) Yes Type of content attached to the email. This column is based on the lookup type "PRP_ATTACHMENT_CONTENT_TYPE" of FND lookups.
CONTENT_ID NUMBER
Yes Identifier of the content sent as an attachment of an email.
EMAIL_HISTORY_ID NUMBER
Yes Email History Identifier.
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
Query Text

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


SELECT EMAIL_ATTACHMENT_ID
,      OBJECT_VERSION_NUMBER
,      CONTENT_TYPE
,      CONTENT_ID
,      EMAIL_HISTORY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM PRP.PRP_EMAIL_ATTACHMENTS;

Dependencies

[top of page]

PRP.PRP_EMAIL_ATTACHMENTS does not reference any database object

PRP.PRP_EMAIL_ATTACHMENTS is referenced by following:

SchemaAPPS
SynonymPRP_EMAIL_ATTACHMENTS