[Home] [Help]
1928: and pas.attribute_sequence_number = pa.sequence_number
1929: order by pas.attribute_sequence_number,pas.sequence_number
1930: ) as HEADER_ATTRIBUTE_SCORES
1931: from
1932: pon_auction_attributes pa, pon_bid_attribute_values pbav
1933: where
1934: pa.auction_header_id = paa.auction_header_id
1935: --bidpdf: add bid values for attributes from table pon_bid_attribute_values
1936: -- The table has index on bid_number, line_number, sequence_number
1943: and pa.attr_level='HEADER'
1944: and (l_is_buyer_negpdf = 'Y' or pa.internal_attr_flag <> 'Y')
1945: order by pa.attr_disp_seq_number) as HEADER_ATTRIBUTES_DETAILS
1946: from
1947: pon_auction_attributes paa,pon_auction_sections pass
1948: where
1949: pass.auction_header_id = pah.auction_header_id
1950: and pass.auction_header_id = paa.auction_header_id(+)
1951: and pass.section_name = paa.section_name(+)
2012: pal.attr_disp_seq_number,
2013: -- bidpdf: add attribute response value
2014: print_attribute_response_value(pbav.value, pbav.datatype, p_client_time_zone, p_server_time_zone, p_date_format, pbav.sequence_number) attr_bid_value
2015: from
2016: pon_auction_attributes pal,
2017: pon_bid_attribute_values pbav,
2018: fnd_lookups attrGrpFlv
2019: where
2020: pal.auction_header_id = pah.auction_header_id
2041: pas.sequence_number,
2042: get_acceptable_value(pah.show_bidder_scores,pas.attribute_sequence_number,paa.datatype,pas.from_range,pas.to_range,pas.value,pas.score, p_client_time_zone, p_server_time_zone, p_date_format, l_is_buyer_negpdf) display_score
2043: from
2044: pon_attribute_scores pas,
2045: pon_auction_attributes paa
2046: where
2047: pas.auction_header_id = pah.auction_header_id
2048: and paa.auction_header_id = pah.auction_header_id
2049: and paa.line_number = pas.line_number