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.

APPS.PON_BID_DEFAULTING_PKG dependencies on PON_AUC_PAYMENTS_SHIPMENTS

Line 2467: FROM pon_bid_item_prices bl,pon_auc_payments_shipments apmt

2463: apmt.PAYMENT_TYPE_CODE, --PAYMENT_TYPE_CODE,
2464: apmt.QUANTITY, --QUANTITY,
2465: apmt.UOM_CODE, --UOM_CODE,
2466: bl.promised_date --PROMISED_DATE,
2467: FROM pon_bid_item_prices bl,pon_auc_payments_shipments apmt
2468: WHERE bl.auction_header_id = p_auc_header_id
2469: AND bl.bid_number = p_bid_number
2470: AND bl.auction_header_id = apmt.auction_header_id
2471: AND bl.line_number = apmt.line_number

Line 2534: pon_auc_payments_shipments apmt

2530: apmt.QUANTITY, --QUANTITY,
2531: apmt.UOM_CODE, --UOM_CODE,
2532: bl.promised_date --PROMISED_DATE,
2533: FROM pon_bid_item_prices bl,
2534: pon_auc_payments_shipments apmt
2535: WHERE bl.auction_header_id = p_auc_header_id
2536: AND bl.bid_number = p_bid_number
2537: AND bl.auction_header_id = apmt.auction_header_id
2538: AND bl.line_number = apmt.line_number

Line 2593: decode(p_supplier_flag ,'N',(select payment_id from pon_auc_payments_shipments

2589: fnd_global.login_id, --LAST_UPDATE_LOGIN
2590: bpmt.PAYMENT_DISPLAY_NUMBER, --PAYMENT_DISPLAY_NUMBER,
2591: bpmt.PAYMENT_DESCRIPTION, --PAYMENT_DESCRIPTION,
2592: decode(p_new_round_or_amended , 'Y' ,
2593: decode(p_supplier_flag ,'N',(select payment_id from pon_auc_payments_shipments
2594: where auction_header_id=p_auc_header_id
2595: AND line_number = bl.line_number
2596: AND payment_display_number= bpmt.PAYMENT_DISPLAY_NUMBER
2597: )