[Home] [Help]
1784:
1785: FROM
1786: pon_auction_item_prices_all paip,
1787: pon_bid_item_prices pbip,
1788: mtl_units_of_measure mtluom,
1789: pon_bid_headers pbh,
1790: fnd_currencies fc
1791: WHERE pbip.bid_number = p_bid_number and
1792: pbip.auction_header_id = p_auction_header_id and
2507:
2508: FROM
2509: pon_auction_item_prices_all paip,
2510: pon_bid_item_prices pbip,
2511: mtl_units_of_measure mtluom,
2512: pon_bid_headers pbh,
2513: fnd_currencies fc,
2514: pon_bid_shipments pbs
2515: WHERE
2592:
2593: nvl2(bpys.uom_code, mtluom.unit_of_measure,
2594: decode(paip.order_type_lookup_code, 'QUANTITY',
2595: (select unit_of_measure from
2596: mtl_units_of_measure where uom_code=
2597: paip.uom_code),
2598: null
2599: )
2600: ) , -- unit_of_measure.Populate this for RATE and Qty Milestone
2645: pon_bid_item_prices pbip,
2646: pon_bid_payments_shipments bpys,
2647: pon_auc_payments_shipments apys,
2648: po_lines_interface pli,
2649: mtl_units_of_measure mtluom
2650: WHERE pbip.bid_number = p_bid_number and
2651: pbip.auction_header_id = p_auction_header_id and
2652: nvl(pbip.award_status, 'NO') = 'AWARDED' and
2653: paip.auction_header_id = pbip.auction_header_id and
2828: 'FIXED PRICE', round(pbip.bid_currency_unit_price, fc.precision),
2829: null) -- amount
2830: FROM pon_auction_item_prices_all paip,
2831: pon_bid_item_prices pbip,
2832: mtl_units_of_measure mtluom,
2833: pon_bid_headers pbh,
2834: fnd_currencies fc,
2835: pon_bid_shipments pbs
2836: WHERE pbip.bid_number = p_bid_number and