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 2853: from pon_bid_item_prices pbip,

2849:
2850:
2851: select count(pbip.line_number)
2852: into x_number_awarded
2853: from pon_bid_item_prices pbip,
2854: pon_auction_item_prices_all paip
2855: where paip.auction_header_id = p_auction_header_id
2856: and paip.line_number = pbip.line_number
2857: and pbip.bid_number = p_bid_id

Line 2863: from pon_bid_item_prices pbip,

2859: and paip.group_type in ('LINE', 'LOT', 'GROUP_LINE');
2860:
2861: select count(pbip.line_number)
2862: into x_number_rejected
2863: from pon_bid_item_prices pbip,
2864: pon_auction_item_prices_all paip
2865: where paip.auction_header_id = p_auction_header_id
2866: and paip.line_number = pbip.line_number
2867: and pbip.bid_number = p_bid_id

Line 5586: from pon_bid_item_prices

5582: Function GetPOTotal( p_po_id IN number) return Number AS
5583: x_amount number;
5584: cursor c1(p_po_id number) is
5585: select sum(AWARD_QUANTITY * BID_CURRENCY_PRICE)
5586: from pon_bid_item_prices
5587: where bid_number = p_po_id
5588: and award_status = 'AWARDED';
5589: Begin
5590: begin