PON_AUC_NOTIF_DELIV_V

Details

• Schema: FUSION

• Object owner: PON

• Object type: VIEW

Columns

Name
AUCTION_NUMBER AUCTION_TITLE BID_NUMBER SUPPLIER_PARTY_ID SUPPLIER_CONTACT_ID AUCTION_OPEN_DATE AUCTION_CLOSE_DATE

Query

SQL_Statement

SELECT AH.DOCUMENT_NUMBER AUCTION_NUMBER, AH.AUCTION_TITLE AUCTION_TITLE, BH.BID_NUMBER BID_NUMBER, BH.TRADING_PARTNER_ID SUPPLIER_PARTY_ID,BH.TRADING_PARTNER_CONTACT_ID SUPPLIER_CONTACT_ID, AH.OPEN_BIDDING_DATE AUCTION_OPEN_DATE, AH.CLOSE_BIDDING_DATE AUCTION_CLOSE_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'