eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AUCTION_PKG dependencies on PON_BID_ITEM_PRICES

Line 2369: from pon_bid_item_prices pbip,

2365:
2366:
2367: select count(pbip.line_number)
2368: into x_number_awarded
2369: from pon_bid_item_prices pbip,
2370: pon_auction_item_prices_all paip
2371: where paip.auction_header_id = p_auction_header_id
2372: and paip.line_number = pbip.line_number
2373: and pbip.bid_number = p_bid_id

Line 2379: from pon_bid_item_prices pbip,

2375: and paip.group_type in ('LINE', 'LOT', 'GROUP_LINE');
2376:
2377: select count(pbip.line_number)
2378: into x_number_rejected
2379: from pon_bid_item_prices pbip,
2380: pon_auction_item_prices_all paip
2381: where paip.auction_header_id = p_auction_header_id
2382: and paip.line_number = pbip.line_number
2383: and pbip.bid_number = p_bid_id

Line 4990: from pon_bid_item_prices

4986: Function GetPOTotal( p_po_id IN number) return Number AS
4987: x_amount number;
4988: cursor c1(p_po_id number) is
4989: select sum(AWARD_QUANTITY * BID_CURRENCY_PRICE)
4990: from pon_bid_item_prices
4991: where bid_number = p_po_id
4992: and award_status = 'AWARDED';
4993: Begin
4994: begin