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_PRINTING_PKG dependencies on PON_AUCTION_SHIPMENTS_ALL

Line 2059: FROM pon_auction_shipments_all

2055: -- determine if there are price breaks
2056: BEGIN
2057: SELECT 'Y'
2058: INTO l_neg_has_price_breaks
2059: FROM pon_auction_shipments_all
2060: WHERE auction_header_id = p_auction_header_id
2061: AND ROWNUM = 1;
2062: EXCEPTION
2063: WHEN no_data_found THEN

Line 3319: FROM pon_auction_shipments_all pas,

3315: pas.differential_response_type,
3316: decode(p_user_view_type, 'BUYER',pon_printing_pkg.format_price(pbsm.price,l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbsm.bid_currency_price,l_price_mask, l_price_precision)) bid_currency_price,
3317: pbsm.price_type,
3318: pbsm.price_discount
3319: FROM pon_auction_shipments_all pas,
3320: pon_auction_item_prices_all paip,
3321: hr_locations_all loc,
3322: mtl_parameters mp,
3323: -- bidpdf: add response price for price breaks

Line 3360: FROM pon_auction_shipments_all pas,

3356: pas.differential_response_type,
3357: null bid_currency_price,
3358: null price_type,
3359: null price_discount
3360: FROM pon_auction_shipments_all pas,
3361: pon_auction_item_prices_all paip,
3362: hr_locations_all loc,
3363: mtl_parameters mp
3364: WHERE pas.auction_header_id = p_auction_header_id

Line 3440: FROM pon_auction_shipments_all pas,

3436: p_requested_supplier_id),l_price_mask, l_price_precision)
3437: , null
3438: ) price,
3439: decode(p_user_view_type, 'BUYER',pon_printing_pkg.format_price(pbsm.unit_price,l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbsm.bid_currency_unit_price,l_price_mask, l_price_precision)) bid_currency_unit_price
3440: FROM pon_auction_shipments_all pas,
3441: pon_auction_item_prices_all paip,
3442: pon_bid_shipments pbsm
3443: WHERE pbsm.bid_number = p_bid_number
3444: AND pbsm.line_number = line_num

Line 3465: FROM pon_auction_shipments_all pas,

3461: l_price_mask,
3462: l_price_precision
3463: ) price,
3464: null bid_currency_unit_price
3465: FROM pon_auction_shipments_all pas,
3466: pon_auction_item_prices_all paip
3467: WHERE pas.auction_header_id = p_auction_header_id
3468: AND pas.line_number = line_num
3469: AND paip.auction_header_id = pas.auction_header_id

Line 4113: pon_auction_shipments_all pas,

4109: loc.country country,
4110: loc.region_1 county
4111: from
4112: hr_locations_all loc,
4113: pon_auction_shipments_all pas,
4114: fnd_territories_tl ship_territories_tl
4115: WHERE
4116: pas.auction_header_id = p_auction_header_id
4117: and l_is_buyer_negpdf = 'N'

Line 4150: FROM pon_auction_shipments_all pas

4146: fnd_territories_tl ship_territories_tl,
4147: mtl_parameters mp ,
4148: ( SELECT
4149: distinct pas.ship_to_organization_id
4150: FROM pon_auction_shipments_all pas
4151: WHERE
4152: pas.auction_header_id = p_auction_header_id
4153: AND l_is_buyer_negpdf = 'N'
4154: AND l_neg_has_price_breaks = 'Y'