PON_SUPPLIER_MANAGE_DELIV_V

Details

• Schema: FUSION

• Object owner: PON

• Object type: VIEW

Columns

Name
BID_NUMBER PARTY_ID

Query

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