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_SUPPLIER_ACTIVITIES

Object Details

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

PON_SUPPLIER_ACTIVITIES will contain a row for each distinct activity performed by a Supplier User on the Negotiation as he/she navigates through the bidding flow.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_SUPPLIER_ACTIVITIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AUCTION_HEADER_ID_ORIG_AMEND TRADING_PARTNER_CONTACT_ID LAST_ACTIVITY_TIME TRADING_PARTNER_ID SESSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AUCTION_HEADER_ID_ORIG_AMEND	NUMBER		Yes	Contains the identifier of the first negotiation in a series of amendments. If this is the first in the series, then it is the same as the identifier of the negotiation.
TRADING_PARTNER_CONTACT_ID	NUMBER		Yes	Identifier of the Supplier Contact who performed the activity.
LAST_ACTIVITY_TIME	DATE		Yes	Datetime the last activity was performed by the user.
AUCTION_HEADER_ID	NUMBER		Yes	Identifier of the negotiation for which this activity is recorded.
TRADING_PARTNER_ID	NUMBER		Yes	Identifier of the Supplier whose user last performed this activity.
SESSION_ID	NUMBER		Yes	Identifier of the session for the Supplier user when the activity was logged. The session identifier is used to determine whether the user has logged off the application.
LAST_ACTIVITY_CODE	VARCHAR2	(30)	Yes	Abbreviated code designating the activity performed. From FND_LOOKUPS with LOOKUP_TYPE = 'PON_SUPPLIER_ACTIVITY'
LAST_ACTION_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if this is the last activity performed by the supplier user. Earlier records will have a value of 'N'.
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
BID_NUMBER	NUMBER

Query Text

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


SELECT AUCTION_HEADER_ID_ORIG_AMEND
,      TRADING_PARTNER_CONTACT_ID
,      LAST_ACTIVITY_TIME
,      AUCTION_HEADER_ID
,      TRADING_PARTNER_ID
,      SESSION_ID
,      LAST_ACTIVITY_CODE
,      LAST_ACTION_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      BID_NUMBER
FROM PON.PON_SUPPLIER_ACTIVITIES;

Dependencies

[top of page]

PON.PON_SUPPLIER_ACTIVITIES does not reference any database object

PON.PON_SUPPLIER_ACTIVITIES is referenced by following:

PON: PON_SUPPLIER_ACTIVITIES#