PON_SUPPLIER_ACTIVITIES

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.

Details

• Schema: FUSION

• Object owner: PON

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
PON_SUPPLIER_ACTIVITIES_PK	AUCTION_HEADER_ID_ORIG_AMEND, TRADING_PARTNER_ID, TRADING_PARTNER_CONTACT_ID, LAST_ACTIVITY_TIME, SESSION_ID, LAST_ACTIVITY_CODE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
AUCTION_HEADER_ID_ORIG_AMEND	NUMBER		18	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		18	Yes	Identifier of the Supplier Contact who performed the activity.
VENDOR_SITE_ID	NUMBER		18		Stores the vendor site id of invited vendor from poz_supplier_sites_all_m.
LAST_ACTIVITY_TIME	TIMESTAMP			Yes	Datetime the last activity was performed by the user.
AUCTION_HEADER_ID	NUMBER		18	Yes	Identifier of the negotiation for which this activity is recorded.
TRADING_PARTNER_ID	NUMBER		18	Yes	Identifier of the Supplier whose user last performed this activity.
SESSION_ID	NUMBER		18	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'.
BID_NUMBER	NUMBER		18		Bid number associated with the supplier activity
BID_STATUS	VARCHAR2	25			Bid status
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PON_SUPPLIER_ACTIVITIES	pon_auction_headers_all	AUCTION_HEADER_ID
PON_SUPPLIER_ACTIVITIES	pon_auction_headers_all	AUCTION_HEADER_ID_ORIG_AMEND
PON_SUPPLIER_ACTIVITIES	hz_parties	TRADING_PARTNER_ID
PON_SUPPLIER_ACTIVITIES	hz_parties	TRADING_PARTNER_CONTACT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PON_SUPPLIER_ACTIVITIES_N1	Non Unique	Default	AUCTION_HEADER_ID_ORIG_AMEND, TRADING_PARTNER_ID, AUCTION_HEADER_ID
PON_SUPPLIER_ACTIVITIES_N2	Non Unique	Default	TRADING_PARTNER_ID, LAST_ACTIVITY_TIME
PON_SUPPLIER_ACTIVITIES_U1	Unique	Default	AUCTION_HEADER_ID_ORIG_AMEND, TRADING_PARTNER_ID, TRADING_PARTNER_CONTACT_ID, LAST_ACTIVITY_TIME, SESSION_ID, LAST_ACTIVITY_CODE