4226: ad.pk3_value,
4227: categories_tl.user_name category_name
4228: from pon_auction_headers_all pah,
4229: fnd_documents_vl d,
4230: fnd_attached_documents ad,
4231: fnd_document_categories categories,
4232: fnd_document_categories_tl categories_tl,
4233: pon_auction_item_prices_all paip,
4234: financials_system_params_all fsp
4256: ad.pk2_value,
4257: ad.pk3_value,
4258: categories_tl.user_name category_name
4259: from fnd_documents_vl d,
4260: fnd_attached_documents ad,
4261: fnd_document_categories categories,
4262: fnd_document_categories_tl categories_tl
4263: where d.document_id = ad.document_id
4264: and
4283: ad.pk3_value,
4284: categories_tl.user_name category_name
4285: from pon_bid_headers pbhs,
4286: fnd_documents_vl d,
4287: fnd_attached_documents ad,
4288: fnd_document_categories categories,
4289: fnd_document_categories_tl categories_tl
4290: where d.document_id = ad.document_id
4291: AND
4316: ad.pk3_value,
4317: categories_tl.user_name category_name
4318: from pon_bid_headers pbhs,
4319: fnd_documents_vl d,
4320: fnd_attached_documents ad,
4321: fnd_document_categories categories,
4322: fnd_document_categories_tl categories_tl
4323: where d.document_id = ad.document_id
4324: and pbhs.auction_header_id (+) = p_auction_header_id
4345: (select to_char(bid_payment_id) from PON_BID_PAYMENTS_SHIPMENTS pby where bid_number = p_bid_number and pby.auction_payment_id = to_number(ad.pk3_value)),
4346: ad.pk3_value) pk3_value,
4347: categories_tl.user_name category_name
4348: from fnd_documents_vl d,
4349: fnd_attached_documents ad,
4350: fnd_document_categories categories,
4351: fnd_document_categories_tl categories_tl
4352: where d.document_id = ad.document_id
4353: and