PON_SUPPLIER_MANAGE_DELIV_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: PON
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
BID_NUMBER PARTY_ID |
問合せ
| SQL_Statement |
|---|
|
SELECT bh.bid_number bid_number, hzp.party_id party_id FROM pon_auction_headers_all ah, pon_bid_headers bh, hz_parties hzp 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 hzp.party_id = bh.trading_partner_contact_id |