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

265: END IF; --}
266:
267: UPDATE PON_AWARD_ITEMS_INTERFACE PAII
268: set AWARD_SHIPMENT_NUMBER = ( select -1
269: from pon_bid_item_prices pbip
270: where pbip.bid_number = PAII.bid_number
271: and pbip.auction_line_number = PAII.auction_line_number
272: and pbip.has_quantity_tiers = 'Y'
273: )

Line 296: FROM pon_bid_item_prices bp

292: INSERT ALL
293: -- VALIDATION #1:
294: -- Check that the bid number is valid for this auction and this line number
295: WHEN NOT EXISTS (SELECT 'Y'
296: FROM pon_bid_item_prices bp
297: WHERE s_auction_header_id = bp.auction_header_id
298: AND s_auction_line_number = bp.line_number
299: AND s_bid_number = bp.bid_number)
300: THEN