[Home] [Help]
2267: -- Quantity Based Price Tiers changes
2268: IF x_pdoi_line.award_shipment_number IS NOT NULL THEN
2269:
2270: SELECT BID_CURRENCY_UNIT_PRICE INTO x_price
2271: FROM PON_BID_SHIPMENTS
2272: WHERE LINE_NUMBER = x_pdoi_line.line_number
2273: AND AUCTION_HEADER_ID = x_pdoi_header.auction_header_id
2274: AND BID_NUMBER = p_bid_number
2275: AND SHIPMENT_NUMBER = x_pdoi_line.award_shipment_number;
3012: pon_bid_item_prices pbip,
3013: mtl_units_of_measure mtluom,
3014: pon_bid_headers pbh,
3015: fnd_currencies fc,
3016: pon_bid_shipments pbs
3017: WHERE
3018: pbip.bid_number = p_bid_number and
3019: pbip.auction_header_id = p_auction_header_id and
3020: nvl(pbip.award_status, 'NO') = 'AWARDED' and
3406: pon_bid_item_prices pbip,
3407: mtl_units_of_measure mtluom,
3408: pon_bid_headers pbh,
3409: fnd_currencies fc,
3410: pon_bid_shipments pbs
3411: WHERE pbip.bid_number = p_bid_number and
3412: pbip.auction_header_id = p_auction_header_id and
3413: nvl(pbip.award_status, 'NO') = 'AWARDED' and
3414: paip.auction_header_id = pbip.auction_header_id and
3549: , paip.CLM_IDC_TYPE
3550:
3551: FROM pon_auction_item_prices_all paip,
3552: pon_bid_item_prices pbip,
3553: pon_bid_shipments pbs,
3554: po_lines_interface pli
3555: WHERE pbip.bid_number = p_bid_number and
3556: pbip.auction_header_id = p_auction_header_id and
3557: nvl(pbip.award_status, 'NO') = 'AWARDED' and
3656: (select pbpd.bid_number, pbpd.line_number,
3657: pbpd.shipment_number, pbs.auction_shipment_number,
3658: pbpd.price_differential_number, pbpd.price_type,
3659: pbpd.multiplier, pbpd.auction_header_id
3660: from pon_bid_price_differentials pbpd, pon_bid_shipments pbs
3661: where pbs.bid_number = p_bid_number
3662: and pbs.line_number = pbpd.line_number
3663: and pbs.shipment_number = pbpd.shipment_number) pbpd,
3664: pon_bid_shipments pbs,
3660: from pon_bid_price_differentials pbpd, pon_bid_shipments pbs
3661: where pbs.bid_number = p_bid_number
3662: and pbs.line_number = pbpd.line_number
3663: and pbs.shipment_number = pbpd.shipment_number) pbpd,
3664: pon_bid_shipments pbs,
3665: pon_auction_headers_all pah,
3666: po_lines_interface pli
3667: WHERE pbip.bid_number = p_bid_number
3668: AND nvl(pbip.award_status, 'NO') = 'AWARDED'