[Home] [Help]
158: FROM
159: pon_auction_headers_all ponh,
160: financials_system_params_all pfsp,
161: gl_sets_of_books pgl,
162: pon_auc_doctypes doctype
163: WHERE
164: ponh.auction_status = 'AUCTION_CLOSED'
165: and ponh.auction_type = 'REVERSE' /* Only Reverse (Buyer) auctions considered */
166: and (ponh.award_complete_date is not null /* Only Award Complete Negotiations are considered */
192: FROM
193: pon_auction_headers_all ponh,
194: financials_system_params_all pfsp,
195: gl_sets_of_books pgl,
196: pon_auc_doctypes doctype
197: WHERE
198: nvl(ponh.auction_status,'DRAFT') <> 'DRAFT'
199: and ponh.auction_type = 'REVERSE' /* Forward Auctions not considered */
200: and (ponh.award_complete_date is not null /* Only Award Complete Negotiations are considered */
219: pon_auction_headers_all ponh,
220: pon_bid_headers ponbh,
221: financials_system_params_all pfsp,
222: gl_sets_of_books pgl,
223: pon_auc_doctypes doctype
224: WHERE
225: nvl(ponh.auction_status,'DRAFT') <> 'DRAFT'
226: and ponh.auction_type = 'REVERSE' /* Forward Auctions not considered */
227: and ponh.award_complete_date is not null /* Only Award Complete Negotiations are considered */
510: mtl_system_items pitem,
511: gl_sets_of_books pgl,
512: hz_parties hz,
513: mtl_units_of_measure uom,
514: pon_auc_doctypes doctype,
515: pon_auction_headers_all ponh_multi,
516: pon_auction_headers_all ponh_multi_orig,
517: pon_auction_headers_all ponh_prev,
518: pon_auction_headers_all ponh_next
635: mtl_system_items pitem,
636: gl_sets_of_books pgl,
637: hz_parties hz,
638: mtl_units_of_measure uom,
639: pon_auc_doctypes doctype,
640: pon_auction_headers_all ponh_multi,
641: pon_auction_headers_all ponh_multi_orig,
642: pon_auction_headers_all ponh_prev,
643: pon_auction_headers_all ponh_next