eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PON.PON_TE_RECIPIENTS

Object Details

Object Name:	PON_TE_RECIPIENTS
Object Type:	TABLE
Owner:	PON
FND Design Data:	PON.PON_TE_RECIPIENTS
Subobject Name:
Status:	VALID

Its is denormalized to allow multiple recipients, which can be important depending on the viewing/posting rules for the thread.When it is inserted, a broadcast message will only have rows in the table as users read the message. Howevere, each unique reader will get his own row, to keep track of who read and/or replied to the message. For a broadcast message, the TO_ID will normally be the person who posted the message. The PK is TO_ID + Message_ID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_TE_RECIPIENTS_N3	NORMAL	UNIQUE	APPS_TS_TX_IDX	TO_ID ENTRY_ID
PON_TE_RECIPIENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTRY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TO_ID	NUMBER	(15)	Yes	FK to HZ_PARTIES for the PARTY_ID of the recipient. Part of the PK for the table, with ENTRY_ID.
READ_FLAG	VARCHAR2	(1)	Yes	'Y' if the user has read the entry, 'N' otherwise
REPLIED_FLAG	VARCHAR2	(1)	Yes	'Y' if the user has replied to the entry, 'N' otherwise.
ENTRY_ID	NUMBER	(15)	Yes	The message for which the recipient is being listed. FK to PON_THREAD_ENTRIES, and also part of the PK for this table with TO_ID.
TO_FIRST_NAME	VARCHAR2	(150)		Stores receipient's first name
TO_LAST_NAME	VARCHAR2	(150)		Stores recipient's last name
TO_COMPANY_NAME	VARCHAR2	(360)		Stores recipient's company name
TO_COMPANY_ID	NUMBER			Stores recipient company's trading partner id

Query Text

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


SELECT TO_ID
,      READ_FLAG
,      REPLIED_FLAG
,      ENTRY_ID
,      TO_FIRST_NAME
,      TO_LAST_NAME
,      TO_COMPANY_NAME
,      TO_COMPANY_ID
FROM PON.PON_TE_RECIPIENTS;

Dependencies

[top of page]

PON.PON_TE_RECIPIENTS does not reference any database object

PON.PON_TE_RECIPIENTS is referenced by following:

APPS: PON_TE_RECIPIENTS