[Home] [Help]
2956: p_user_id, -- created_by
2957: fnd_global.login_id -- last_update_login
2958: FROM pon_price_differentials ppd,
2959: pon_bid_item_prices pbip,
2960: pon_bid_price_differentials pbpd,
2961: pon_auction_headers_all pah,
2962: po_lines_interface pli
2963: WHERE pbip.bid_number = p_bid_number
2964: AND nvl(pbip.award_status, 'NO') = 'AWARDED'
3013: (select pbpd.bid_number, pbpd.line_number,
3014: pbpd.shipment_number, pbs.auction_shipment_number,
3015: pbpd.price_differential_number, pbpd.price_type,
3016: pbpd.multiplier, pbpd.auction_header_id
3017: from pon_bid_price_differentials pbpd, pon_bid_shipments pbs
3018: where pbs.bid_number = p_bid_number
3019: and pbs.line_number = pbpd.line_number
3020: and pbs.shipment_number = pbpd.shipment_number) pbpd,
3021: pon_bid_shipments pbs,