[Home] [Help]
View: PON_AUC_NOTIF_DELIV_V
Product: | PON - Sourcing |
Description: | This is the view used by contract team about active bids and the associated auction information. |
Implementation/DBA Data: |
APPS.PON_AUC_NOTIF_DELIV_V
|
View Text
SELECT AH.DOCUMENT_NUMBER
, AH.AUCTION_TITLE
, BH.BID_NUMBER
, BH.TRADING_PARTNER_ID
, BH.TRADING_PARTNER_NAME
, BH.TRADING_PARTNER_CONTACT_ID
, BH.TRADING_PARTNER_CONTACT_NAME
, AH.OPEN_BIDDING_DATE
, AH.CLOSE_BIDDING_DATE
FROM PON_AUCTION_HEADERS_ALL AH
, PON_BID_HEADERS BH
WHERE AH.AUCTION_HEADER_ID = BH.AUCTION_HEADER_ID AND BH.BID_STATUS = 'ACTIVE'
Columns
Name |
AUCTION_NUMBER |
AUCTION_TITLE |
BID_NUMBER |
SUPPLIER_PARTY_ID |
SUPPLIER_PARTY_NAME |
SUPPLIER_CONTACT_ID |
SUPPLIER_CONTACT_USER_NAME |
AUCTION_OPEN_DATE |
AUCTION_CLOSE_DATE |