[Home] [Help]
442: SET ba.weighted_score =
443: (SELECT decode(nvl(aa.scoring_type, 'NONE'),
444: 'NONE', null,
445: aa.weight / 100.0 * nvl(ba.score, 0))
446: FROM pon_auction_attributes aa
447: WHERE aa.auction_header_id = ba.auction_header_id
448: AND aa.line_number = ba.line_number
449: AND aa.sequence_number = ba.sequence_number)
450: WHERE ba.bid_number = p_bid_number
471: null, decode(bl.has_bid_flag, 'Y', 100, null),
472: 0, decode(bl.has_bid_flag, 'Y', 100, null),
473: sum(decode(sign(aa.weight), 1, nvl2(ba.value, 1, 0), 0)),
474: sum(aa.weight / 100.0 * nvl(ba.score, 0)), null)
475: FROM pon_bid_attribute_values ba, pon_auction_attributes aa
476: WHERE ba.bid_number = bl.bid_number
477: AND ba.line_number = bl.line_number
478: AND aa.auction_header_id = ba.auction_header_id
479: AND aa.line_number = ba.line_number
3267: --added by Allen Yang for Surrogate Bid 2008/09/03
3268: ---------------------------------------------------
3269: , pas.two_part_section_type s_two_part_section_type
3270: ---------------------------------------------------
3271: FROM pon_bid_attribute_values ba, pon_auction_attributes aa
3272: --added by Allen Yang for Surrogate Bid 2008/09/03
3273: ---------------------------------------------------
3274: , pon_auction_sections pas
3275: ---------------------------------------------------
3431: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_name, null) s_worksheet_name,
3432: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, null) s_worksheet_sequence_number,
3433: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ATTRIBUTES', null) s_entity_message_code
3434: FROM pon_bid_attribute_values ba
3435: , pon_auction_attributes aa
3436: , pon_auction_item_prices_all al
3437: , pon_bid_item_prices bl
3438: , pon_bid_headers pbh
3439: WHERE ba.bid_number = p_bid_number