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_PRICE_DIFFERENTIALS

Line 667: FROM pon_price_differentials apd

663: p_userid, -- CREATED_BY
664: sysdate, -- LAST_UPDATE_DATE
665: p_userid, -- LAST_UPDATED_BY
666: null -- LAST_UPDATE_LOGIN
667: FROM pon_price_differentials apd
668: WHERE apd.auction_header_id = p_auc_header_id
669: AND apd.line_number BETWEEN p_batch_start AND p_batch_end
670: AND NOT EXISTS
671: (SELECT pbpd.price_differential_number

Line 2300: FROM pon_price_differentials apd,

2296: sysdate, -- LAST_UPDATE_DATE
2297: p_userid, -- LAST_UPDATED_BY
2298: null, -- LAST_UPDATE_LOGIN
2299: decode(p_rebid_flag, 'Y', bpd.multiplier, null) -- OLD_MULTIPLIER
2300: FROM pon_price_differentials apd,
2301: pon_bid_price_differentials bpd,
2302: pon_bid_item_prices bl
2303: WHERE apd.auction_header_id = p_auc_header_id
2304: AND apd.shipment_number = -1 -- only line level differentials

Line 2332: FROM pon_price_differentials apd,

2328: sysdate, -- LAST_UPDATE_DATE
2329: p_userid, -- LAST_UPDATED_BY
2330: null, -- LAST_UPDATE_LOGIN
2331: decode(p_rebid_flag, 'Y', bpd.multiplier, null) -- OLD_MULTIPLIER
2332: FROM pon_price_differentials apd,
2333: pon_bid_price_differentials bpd,
2334: pon_bid_shipments bpb,
2335: pon_bid_item_prices bl
2336: WHERE apd.auction_header_id = p_auc_header_id