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_VALIDATE_ITEM_PRICES_INT dependencies on PON_BID_ITEM_PRICES

Line 245: from pon_bid_item_prices pbip

241: END IF; --}
242:
243: UPDATE PON_AWARD_ITEMS_INTERFACE PAII
244: set AWARD_SHIPMENT_NUMBER = ( select -1
245: from pon_bid_item_prices pbip
246: where pbip.bid_number = PAII.bid_number
247: and pbip.auction_line_number = PAII.auction_line_number
248: and pbip.has_quantity_tiers = 'Y'
249: )

Line 272: FROM pon_bid_item_prices bp

268: INSERT ALL
269: -- VALIDATION #1:
270: -- Check that the bid number is valid for this auction and this line number
271: WHEN NOT EXISTS (SELECT 'Y'
272: FROM pon_bid_item_prices bp
273: WHERE s_auction_header_id = bp.auction_header_id
274: AND s_auction_line_number = bp.line_number
275: AND s_bid_number = bp.bid_number)
276: THEN