View: PON_SUPPLIER_MANAGE_DELIV_V

Product:	PON - Sourcing
Description:	This is the view of active bids and their suppliers' user id.
Implementation/DBA Data:	APPS.PON_SUPPLIER_MANAGE_DELIV_V

View Text

SELECT BH.BID_NUMBER BID_NUMBER
, FU1.USER_ID USER_ID
FROM PON_AUCTION_HEADERS_ALL AH
, PON_BID_HEADERS BH
, FND_USER FU1
WHERE BH.AUCTION_HEADER_ID = AH.AUCTION_HEADER_ID
AND BH.BID_STATUS = 'ACTIVE' AND AH.AUCTION_STATUS <> 'DRAFT' AND AH.AUCTION_STATUS <> 'CANCELLED' AND AH.AUCTION_STATUS <> 'DELETED' AND AH.AUCTION_STATUS <> 'AMENDED' AND FU1.USER_NAME = BH.TRADING_PARTNER_CONTACT_NAME

Columns