eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.POA_DBI_NEG_F_C dependencies on PON_AUCTION_HEADERS_ALL

Line 159: pon_auction_headers_all ponh,

155: ponh.currency_code txn_cur_code,
156: pgl.currency_code func_cur_code,
157: nvl(trunc(ponh.rate_date),trunc(ponh.creation_date)) rate_date
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

Line 193: pon_auction_headers_all ponh,

189: ponh.currency_code txn_cur_code,
190: pgl.currency_code func_cur_code,
191: nvl(trunc(ponh.rate_date),trunc(ponh.creation_date)) rate_date
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

Line 219: pon_auction_headers_all ponh,

215: ponh.currency_code txn_cur_code,
216: pgl.currency_code func_cur_code,
217: nvl(trunc(ponh.rate_date),trunc(ponh.creation_date)) rate_date
218: FROM
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

Line 502: pon_auction_headers_all ponh,

498: decode(doctype.internal_name, 'REQUEST_FOR_INFORMATION', nvl(ponh.award_complete_date, ponh.last_update_date), null) rfi_complete_date
499: FROM
500: poa_dbi_neg_inc inc,
501: poa_dbi_neg_rates rat,
502: pon_auction_headers_all ponh,
503: pon_auction_item_prices_all ponip,
504: pon_bid_headers ponbh,
505: pon_bid_item_prices ponbip,
506: pon_bidding_parties ponbp,

Line 515: pon_auction_headers_all ponh_multi,

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
519: WHERE

Line 516: pon_auction_headers_all ponh_multi_orig,

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
519: WHERE
520: inc.primary_key = ponh.auction_header_id

Line 517: pon_auction_headers_all ponh_prev,

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
519: WHERE
520: inc.primary_key = ponh.auction_header_id
521: and (ponh.award_complete_date is not null /* Only Published Negotiations are considered */

Line 518: pon_auction_headers_all ponh_next

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
519: WHERE
520: inc.primary_key = ponh.auction_header_id
521: and (ponh.award_complete_date is not null /* Only Published Negotiations are considered */
522: OR (doctype.internal_name = 'REQUEST_FOR_INFORMATION' AND ponh.award_status='QUALIFIED')) /* Only Completed RFIs will be included */

Line 627: pon_auction_headers_all ponh,

623: decode(doctype.internal_name, 'REQUEST_FOR_INFORMATION', nvl(ponh.award_complete_date, ponh.last_update_date), null) rfi_complete_date
624: FROM
625: poa_dbi_neg_inc inc,
626: poa_dbi_neg_rates rat,
627: pon_auction_headers_all ponh,
628: pon_auction_item_prices_all ponip,
629: pon_bid_headers ponbh,
630: pon_bid_item_prices ponbip,
631: pon_bidding_parties ponbp,

Line 640: pon_auction_headers_all ponh_multi,

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
644: WHERE

Line 641: pon_auction_headers_all ponh_multi_orig,

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
644: WHERE
645: inc.primary_key = ponh.auction_header_id

Line 642: pon_auction_headers_all ponh_prev,

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
644: WHERE
645: inc.primary_key = ponh.auction_header_id
646: and (ponh.award_complete_date is not null /* Only Published Negotiations are considered */

Line 643: pon_auction_headers_all ponh_next

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
644: WHERE
645: inc.primary_key = ponh.auction_header_id
646: and (ponh.award_complete_date is not null /* Only Published Negotiations are considered */
647: OR (doctype.internal_name = 'REQUEST_FOR_INFORMATION' AND ponh.award_status='QUALIFIED')) /* Only Completed RFIs will be included */