PON_BUYER_MANAGE_DELIV_V

Details

• Schema: FUSION

• Object owner: PON

• Object type: VIEW

Columns

Name
BID_NUMBER PERSON_ID

Query

SQL_Statement

SELECT bh.bid_number bid_number, pp.person_id FROM pon_auction_headers_all ah, pon_bid_headers bh , per_persons pp WHERE (ah.auction_status = 'ACTIVE' OR ah.auction_status ='AUCTION_CLOSED') AND bh.auction_header_id = ah.auction_header_id AND bh.bid_status = 'ACTIVE' AND ((ah.bid_visibility_code = 'OPEN_BIDDING' OR ah.bid_visibility_code ='SEALED_BIDDING' ) OR (ah.bid_visibility_code = 'SEALED_AUCTION' AND ((nvl(ah.two_part_flag, 'N') = 'N' and nvl(ah.sealed_auction_status, 'LOCKED') <> 'LOCKED' ) OR (nvl(ah.two_part_flag, 'N') = 'Y' and ah.technical_lock_status in ('UNLOCKED', 'ACTIVE'))))) AND (ah.person_id = pp.person_id OR EXISTS (SELECT team.person_id FROM pon_neg_team_members team WHERE team.auction_header_id = ah.auction_header_id AND team.person_id = pp.person_id AND team.access_type = 'FULL') OR (NOT EXISTS (SELECT team.person_id FROM pon_neg_team_members team WHERE team.auction_header_id = ah.auction_header_id AND team.person_id = pp.person_id) AND EXISTS (SELECT poAgent.agent_id FROM po_agent_accesses poAgent WHERE poAgent.access_others_level_code ='FULL' AND poAgent.access_action_code = 'MANAGE_NEGOTIATIONS' AND poAgent.agent_id = pp.person_id AND poAgent.prc_bu_id = ah.prc_bu_id AND poAgent.allowed_flag = 'Y' AND poAgent.active_flag = 'Y')))