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_RESPONSE_PVT dependencies on PON_AUCTION_ATTRIBUTES

Line 1465: FROM pon_auction_attributes paa

1461: -- 3) attributes on lines that have hasBid = N
1462: DELETE FROM pon_bid_attribute_values pbav
1463: WHERE pbav.bid_number = p_bid_number
1464: AND (EXISTS (SELECT null
1465: FROM pon_auction_attributes paa
1466: WHERE pbav.auction_header_id = paa.auction_header_id
1467: AND pbav.line_number = paa.line_number
1468: AND pbav.attribute_name = paa.attribute_name
1469: AND paa.display_only_flag = 'Y')

Line 2247: pon_auction_attributes paa2

2243: SET (pbav1.score, pbav1.weighted_score) =
2244: (SELECT AVG(pbav2.score) score,
2245: AVG(pbav2.score)*paa2.weight/paa2.attr_max_score weighted_score
2246: FROM pon_bid_attribute_values pbav2,
2247: pon_auction_attributes paa2
2248: WHERE pbav2.auction_header_id = p_auction_header_id
2249: AND pbav2.bid_number IN
2250: (SELECT pbh2.bid_number
2251: FROM pon_bid_headers pbh2, pon_bid_headers pbh3

Line 2285: FROM pon_auction_attributes paa1

2281: )
2282: )
2283: AND pbav1.attribute_name IN
2284: (SELECT paa1.attribute_name
2285: FROM pon_auction_attributes paa1
2286: WHERE paa1.auction_header_id = p_auction_header_id
2287: AND paa1.internal_attr_flag = 'Y'
2288: AND paa1.line_number = -1
2289: )