[Home] [Help]
455: SET ba.weighted_score =
456: (SELECT decode(nvl(aa.scoring_type, 'NONE'),
457: 'NONE', null,
458: aa.weight / 100.0 * nvl(ba.score, 0))
459: FROM pon_auction_attributes aa
460: WHERE aa.auction_header_id = ba.auction_header_id
461: AND aa.line_number = ba.line_number
462: AND aa.sequence_number = ba.sequence_number)
463: WHERE ba.bid_number = p_bid_number
484: null, decode(bl.has_bid_flag, 'Y', 100, null),
485: 0, decode(bl.has_bid_flag, 'Y', 100, null),
486: sum(decode(sign(aa.weight), 1, nvl2(ba.value, 1, 0), 0)),
487: sum(aa.weight / 100.0 * nvl(ba.score, 0)), null)
488: FROM pon_bid_attribute_values ba, pon_auction_attributes aa
489: WHERE ba.bid_number = bl.bid_number
490: AND ba.line_number = bl.line_number
491: AND aa.auction_header_id = ba.auction_header_id
492: AND aa.line_number = ba.line_number
3960: ---------------------------------------------------
3961: ---- Supplier Management: Supplier Evaluation -----
3962: , nvl(pbh.evaluation_flag, 'N') s_evaluation_flag
3963: ---------------------------------------------------
3964: FROM pon_bid_attribute_values ba, pon_auction_attributes aa
3965: --added by Allen Yang for Surrogate Bid 2008/09/03
3966: ---------------------------------------------------
3967: , pon_auction_sections pas
3968: ---------------------------------------------------
4133: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, null) s_worksheet_sequence_number,
4134: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ATTRIBUTES', null) s_entity_message_code,
4135: al.line_num_display s_clm_line_num_display
4136: FROM pon_bid_attribute_values ba
4137: , pon_auction_attributes aa
4138: , pon_auction_item_prices_all al
4139: , pon_bid_item_prices bl
4140: , pon_bid_headers pbh
4141: WHERE ba.bid_number = p_bid_number