FND Design Data [Home] [Help]

Table: PON_SUPPLIER_ACCESS

Product: PON - Sourcing
Description: This table will record the lock status for a supplier. As the negotiation proceeds the user might lock a supplier out of the negotiation from the 'Manage Supplier Activities' screen. At that point in time we will flag the supplier as 'Lo
Implementation/DBA Data: TablePON.PON_SUPPLIER_ACCESS
Primary Key: PON_SUPPLIER_ACCESS_PK1
  1. ColumnAUCTION_HEADER_ID_ORIG_AMEND
  2. ColumnSUPPLIER_TRADING_PARTNER_ID
  3. ColumnLOCK_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
PON_SUPPLIER_ACCESS FK Joins to TablePON_AUCTION_HEADERS_ALL PON_SUPPLIER_ACCESS.AUCTION_HEADER_ID_ORIG_AMEND
PON_SUPPLIER_ACCESS FK Joins to TablePON_AUCTION_HEADERS_ALL PON_SUPPLIER_ACCESS.AUCTION_HEADER_ID
PON_SUPPLIER_ACCESS FK Joins to TableHZ_PARTIES PON_SUPPLIER_ACCESS.SUPPLIER_TRADING_PARTNER_ID
PON_SUPPLIER_ACCESS FK Joins to TableHZ_PARTIES PON_SUPPLIER_ACCESS.BUYER_TP_CONTACT_ID