APPS.PON_BUYER_SUMMARY_PKG dependencies on PON_BID_ITEM_PRICES

Line 26: pon_bid_item_prices bl,

22: bh.trading_partner_id,
23: bh.trading_partner_contact_id,
24: bl.rank
25: FROM pon_bid_headers bh,
26: pon_bid_item_prices bl,
27: pon_auction_headers_all ah,
28: po_vendors pv,
29: hz_parties hp
30: WHERE ah.auction_header_id = bh.auction_header_id and

Line 206: from pon_bid_item_prices pbi

202: and nvl(poi.close_bidding_date, poh.close_bidding_date) > sysdate
203: and nvl(poi.number_of_bids,0) > 0
204: and poi.quantity >
205: (select sum(pbi.quantity)
206: from pon_bid_item_prices pbi
207: where pbi.auction_header_id = p_auction_id
208: and pbi.line_number = poi.line_number);
209:
210: select count(*)

Line 220: from pon_bid_item_prices pbi

216: and nvl(poi.close_bidding_date, poh.close_bidding_date) <= sysdate
217: and nvl(poi.number_of_bids,0) > 0
218: and poi.quantity >
219: (select sum(pbi.quantity)
220: from pon_bid_item_prices pbi
221: where pbi.auction_header_id = p_auction_id
222: and pbi.line_number = poi.line_number);
223:
224: select count(*)

Line 234: from pon_bid_item_prices pbi

230: and nvl(poi.close_bidding_date, poh.close_bidding_date) > sysdate
231: and nvl(poi.number_of_bids,0) > 0
232: and poi.quantity <=
233: (select sum(pbi.quantity)
234: from pon_bid_item_prices pbi
235: where pbi.auction_header_id = p_auction_id
236: and pbi.line_number = poi.line_number);
237:
238:

Line 250: from pon_bid_item_prices pbi

246: and nvl(poi.close_bidding_date, poh.close_bidding_date) <= sysdate
247: and nvl(poi.number_of_bids,0) > 0
248: and poi.quantity <=
249: (select sum(pbi.quantity)
250: from pon_bid_item_prices pbi
251: where pbi.auction_header_id = p_auction_id
252: and pbi.line_number = poi.line_number);
253:
254: END;