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_THREADS

Object Details

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

The PK is DISCUSSION_ID + THREAD_NUMBER

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_THREADS_N2	NORMAL	UNIQUE	APPS_TS_TX_IDX	THREAD_NUMBER DISCUSSION_ID
PON_THREADS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUBJECT

Columns

Name	Datatype	Length	Mandatory	Comments
THREAD_NUMBER	NUMBER	(15)	Yes	Part of the PK for the table (with DISCUSSION_ID), this will be indexed as part of the Primary key.It will be sequential on insertion, based on the highest existing thread_number for the given Discussion_id.
DISCUSSION_ID	NUMBER	(15)	Yes	FK to PON_DISCUSSIONS, and also part of the PK for this table.
SUBJECT	VARCHAR2	(2000)	Yes	The header for the thread
LANGUAGE_CODE	VARCHAR2	(4)	Yes	This is in case we need to support language striping by thread is necessary.
LAST_UPDATE_DATE	DATE		Yes	As in PON_DISCUSSIONS, this is a denormalization to make polling easier.
OWNER_PARTY_ID	NUMBER	(15)	Yes	This is a FK to HZ_PARTIES for the owner of the thread.

Query Text

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


SELECT THREAD_NUMBER
,      DISCUSSION_ID
,      SUBJECT
,      LANGUAGE_CODE
,      LAST_UPDATE_DATE
,      OWNER_PARTY_ID
FROM PON.PON_THREADS;

Dependencies

[top of page]

PON.PON_THREADS does not reference any database object

PON.PON_THREADS is referenced by following:

APPS: PON_THREADS