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.PON_BID_DEFAULTING_PKG dependencies on PON_AUCTION_SHIPMENTS_ALL

Line 237: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip

233: sysdate, -- LAST_UPDATE_DATE
234: p_userid, -- LAST_UPDATED_BY
235: null, -- LAST_UPDATE_LOGIN
236: apb.has_price_differentials_flag -- HAS_PRICE_DIFFERENTIALS_FLAG
237: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip
238: WHERE apb.auction_header_id = p_auc_header_id
239: AND aip.auction_header_id = apb.auction_header_id
240: AND apb.line_number BETWEEN p_batch_start AND p_batch_end
241: AND aip.line_number = apb.line_number

Line 619: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip

615: sysdate, -- LAST_UPDATE_DATE
616: p_userid, -- LAST_UPDATED_BY
617: null, -- LAST_UPDATE_LOGIN
618: apb.has_price_differentials_flag -- HAS_PRICE_DIFFERENTIALS_FLAG
619: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip
620: WHERE apb.auction_header_id = p_auc_header_id
621: AND apb.line_number BETWEEN p_batch_start AND p_batch_end
622: AND aip.auction_header_id = apb.auction_header_id
623: AND aip.line_number = apb.line_number

Line 1913: FROM pon_auction_shipments_all apb,

1909: null, -- LAST_UPDATE_LOGIN
1910: apb.has_price_differentials_flag, -- HAS_PRICE_DIFFERENTIALS_FLAG
1911: null, -- UNIT_PRICE
1912: null -- BID_CURRENCY_UNIT_PRICE
1913: FROM pon_auction_shipments_all apb,
1914: pon_bid_item_prices bl
1915: WHERE apb.auction_header_id = p_auc_header_id
1916: AND bl.bid_number = p_bid_number
1917: AND bl.line_number = apb.line_number