PON_AUC_NOTIF_DELIV_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: PON
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
AUCTION_NUMBER AUCTION_TITLE BID_NUMBER SUPPLIER_PARTY_ID SUPPLIER_CONTACT_ID AUCTION_OPEN_DATE AUCTION_CLOSE_DATE |
問合せ
| 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' |