FND Design Data [Home] [Help]

Table: PON_SUPPLIER_ACTIVITIES

Product: PON - Sourcing
Description: This table will contain a row for each distinct activity performed by a Supplier User on the Negotiation as he/she navigates through the bidding flow. The latest activity will be indicated as such by the last_action_flag.
Implementation/DBA Data: TablePON.PON_SUPPLIER_ACTIVITIES
Primary Key: PON_SUPPLIER_ACTIVITIES_PK
  1. ColumnAUCTION_HEADER_ID_ORIG_AMEND
  2. ColumnTRADING_PARTNER_ID
  3. ColumnTRADING_PARTNER_CONTACT_ID
  4. ColumnLAST_ACTIVITY_TIME
  5. ColumnSESSION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PON_SUPPLIER_ACTIVITIES FK Joins to TablePON_AUCTION_HEADERS_ALL PON_SUPPLIER_ACTIVITIES.AUCTION_HEADER_ID
PON_SUPPLIER_ACTIVITIES FK Joins to TablePON_AUCTION_HEADERS_ALL PON_SUPPLIER_ACTIVITIES.AUCTION_HEADER_ID_ORIG_AMEND
PON_SUPPLIER_ACTIVITIES FK Joins to TableHZ_PARTIES PON_SUPPLIER_ACTIVITIES.TRADING_PARTNER_ID
PON_SUPPLIER_ACTIVITIES FK Joins to TableHZ_PARTIES PON_SUPPLIER_ACTIVITIES.TRADING_PARTNER_CONTACT_ID
PON_SUPPLIER_ACTIVITIES FK Joins to TableICX_SESSIONS PON_SUPPLIER_ACTIVITIES.SESSION_ID