APPS.PON_PRINTING_PKG dependencies on PON_AUCTION_ATTRIBUTES

Line 3117: pon_auction_attributes paa

3113: 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
3114: FROM
3115: pon_auction_headers_all pah,
3116: pon_attribute_scores pas,
3117: pon_auction_attributes paa
3118: where
3119: pah.auction_header_id = p_auction_header_id
3120: AND pas.auction_header_id = pah.auction_header_id
3121: AND pas.line_number = line_num

Line 3129: pon_auction_attributes pal,

3125: and paa.sequence_number = pas.attribute_sequence_number
3126: and NVL(paa.attr_level,'LINE')='LINE'
3127: order by pas.line_number,pas.attribute_sequence_number,pas.sequence_number) AS LINE_ATTRIBUTE_SCORES
3128: from
3129: pon_auction_attributes pal,
3130: pon_bid_attribute_values pbav,
3131: fnd_lookups attrGrpFlv
3132: where
3133: pal.auction_header_id = p_auction_header_id

Line 3836: pon_auction_attributes pa, pon_bid_attribute_values pbav

3832: and pas.attribute_sequence_number = pa.sequence_number
3833: order by pas.attribute_sequence_number,pas.sequence_number
3834: ) as HEADER_ATTRIBUTE_SCORES
3835: from
3836: pon_auction_attributes pa, pon_bid_attribute_values pbav
3837: where
3838: pa.auction_header_id = paa.auction_header_id
3839: --bidpdf: add bid values for attributes from table pon_bid_attribute_values
3840: -- The table has index on bid_number, line_number, sequence_number

Line 3851: pon_auction_attributes paa,pon_auction_sections pass

3847: and pa.attr_level='HEADER'
3848: and (l_is_buyer_negpdf = 'Y' or pa.internal_attr_flag <> 'Y')
3849: order by pa.attr_disp_seq_number) as HEADER_ATTRIBUTES_DETAILS
3850: from
3851: pon_auction_attributes paa,pon_auction_sections pass
3852: where
3853: pass.auction_header_id = p_auction_header_id
3854: and pass.auction_header_id = paa.auction_header_id(+)
3855: and pass.section_name = paa.section_name(+)