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
2245: pon_bid_shipments pbsm
2246: WHERE pbsm.bid_number = pbhs.bid_number
2247: and pbsm.auction_header_id = pas.auction_header_id(+)
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
2287: AND l_neg_has_price_breaks = 'Y'
2288: AND paip.auction_header_id = pas.auction_header_id
2289: AND paip.line_number = pas.line_number
2557: from
2558: hr_locations_all loc,
2559: hr_all_organization_units haou,
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