APPS.PON_PRINTING_PKG dependencies on PON_AUCTION_SHIPMENTS_ALL

Line 1112: FROM pon_auction_shipments_all

1108: -- determine if there are price breaks
1109: BEGIN
1110: SELECT 'Y'
1111: INTO l_neg_has_price_breaks
1112: FROM pon_auction_shipments_all
1113: WHERE auction_header_id = p_auction_header_id
1114: AND ROWNUM = 1;
1115: EXCEPTION
1116: WHEN no_data_found THEN

Line 2240: FROM pon_auction_shipments_all pas,

2236: pas.differential_response_type,
2237: 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,
2238: pbsm.price_type,
2239: pbsm.price_discount
2240: FROM pon_auction_shipments_all pas,
2241: pon_auction_item_prices_all paip,
2242: hr_locations_all loc,
2243: mtl_parameters mp,
2244: -- bidpdf: add response price for price breaks

Line 2282: FROM pon_auction_shipments_all pas,

2278: pas.differential_response_type,
2279: null bid_currency_price,
2280: null price_type,
2281: null price_discount
2282: FROM pon_auction_shipments_all pas,
2283: pon_auction_item_prices_all paip,
2284: hr_locations_all loc,
2285: mtl_parameters mp
2286: WHERE pas.auction_header_id = pah.auction_header_id

Line 2312: FROM pon_auction_shipments_all pas,

2308: p_requested_supplier_id),l_price_mask, l_price_precision)
2309: , null
2310: ) price,
2311: 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
2312: FROM pon_auction_shipments_all pas,
2313: pon_auction_item_prices_all paip,
2314: pon_bid_shipments pbsm
2315: WHERE pbsm.bid_number = pbhs.bid_number
2316: and pbsm.auction_header_id = pas.auction_header_id(+)

Line 2338: FROM pon_auction_shipments_all pas,

2334: l_price_mask,
2335: l_price_precision
2336: ) price,
2337: null bid_currency_unit_price
2338: FROM pon_auction_shipments_all pas,
2339: pon_auction_item_prices_all paip
2340: WHERE pas.auction_header_id = pah.auction_header_id
2341: AND paip.auction_header_id = pas.auction_header_id
2342: AND paip.line_number = pas.line_number

Line 2527: pon_auction_shipments_all pas,

2523: loc.country country,
2524: loc.region_1 county
2525: from
2526: hr_locations_all loc,
2527: pon_auction_shipments_all pas,
2528: fnd_territories_tl ship_territories_tl
2529: WHERE
2530: pas.auction_header_id = pah.auction_header_id
2531: and l_is_buyer_negpdf = 'N'

Line 2564: FROM pon_auction_shipments_all pas

2560: fnd_territories_tl ship_territories_tl,
2561: mtl_parameters mp ,
2562: ( SELECT
2563: distinct pas.ship_to_organization_id
2564: FROM pon_auction_shipments_all pas
2565: WHERE
2566: pas.auction_header_id = p_auction_header_id
2567: AND l_is_buyer_negpdf = 'N'
2568: AND l_neg_has_price_breaks = 'Y'