DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PON_BID_ATTRIBUTE_VALUES

Line 3130: pon_bid_attribute_values pbav,

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
3134: AND pal.line_number = line_num

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 3839: --bidpdf: add bid values for attributes from table pon_bid_attribute_values

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
3841: and pbav.auction_header_id(+) = pa.auction_header_id
3842: and pbav.bid_number(+) = p_bid_number
3843: and pbav.line_number(+) = pa.line_number