[Home] [Help] [Dependency Information]
Object Name: | PRP_EMAIL_RECIPIENTS |
---|---|
Object Type: | TABLE |
Owner: | PRP |
FND Design Data: | PRP.PRP_EMAIL_RECIPIENTS |
Subobject Name: | |
Status: | VALID |
This table stores the information about the recipients of the email. Email can be sent to the contacts of the party of type 'ORGANIZATION' or to the party itself in case of party of type 'PERSON'. This table also stores the information of the recipients for whom the email was specified in a free-form manner, that is, the recipients are not recognized by the application as party or some other entity.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PRP_EMAIL_RECIPIENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EMAIL_RECIPIENT_ID |
PRP_EMAIL_RECIPIENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EMAIL_HISTORY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMAIL_RECIPIENT_ID | NUMBER | Yes | Email recipient identifier. This is a primary key column. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object version number |
EMAIL_HISTORY_ID | NUMBER | Yes | Email History Identifier | |
PARTY_ID | NUMBER | This column is obsoleted. Uses CONTACT_POINT_ID to identify the email address of the party. | ||
ADDRESSED_AS | VARCHAR2 | (30) | Yes | This field identifies how the recipient was addressed as in the email. |
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 | ||
PROGRAM_ID | NUMBER | Concurrent Program Standard Who column | ||
PROGRAM_LOGIN_ID | NUMBER | Concurrent Program Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program Standard Who column | ||
REQUEST_ID | NUMBER | Concurrent Program Standard Who column | ||
EMAIL_ADDRESS | VARCHAR2 | (2000) | This column stores the email address of the recipients to whom email was sent in a free-form manner. In case of email sent to party, this column stores NULL value, that is, it does not store the email address of the party. | |
CONTACT_POINT_ID | NUMBER | Contact Point Identifier. |
Cut, paste (and edit) the following text to query this object:
SELECT EMAIL_RECIPIENT_ID
, OBJECT_VERSION_NUMBER
, EMAIL_HISTORY_ID
, PARTY_ID
, ADDRESSED_AS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
, EMAIL_ADDRESS
, CONTACT_POINT_ID
FROM PRP.PRP_EMAIL_RECIPIENTS;
PRP.PRP_EMAIL_RECIPIENTS does not reference any database object
PRP.PRP_EMAIL_RECIPIENTS is referenced by following:
|
|
|