[Home] [Help]
198: END IF;
199: END IF;
200:
201: SELECT sum(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,
202: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
203: nvl(pbip.bid_currency_price,0)) bid_total
204: INTO v_bid_total
205: FROM pon_bid_item_prices pbip,
206: pon_auction_item_prices_all paip
2471: pah.supplier_enterable_pymt_flag,
2472: pah.project_id sourcing_project_id,
2473: pah.bid_decrement_method,
2474: proj.segment1 sourcing_project_number,
2475: DECODE(pah.contract_type, 'STANDARD', DECODE(progress_payment_type,'NONE','N','Y'),'N') complex_services_enabled,
2476: postyl.advances_flag,
2477: postyl.retainage_flag,
2478: postyl.progress_payment_flag,
2479: postyl.contract_financing_flag,
2711: decode(p_user_view_type, 'BUYER', pon_printing_pkg.format_price(pbip.price, l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbip.bid_currency_price, l_price_mask, l_price_precision)) bid_currency_price,
2712: pon_printing_pkg.format_number(pbip.quantity) bid_quantity,
2713: pon_oa_util_pkg.display_date_time(pbip.promised_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') bid_promised_date,
2714: --in MAS case, pbip.quantity is null, use paip.quantity instead
2715: to_char(decode(p_user_view_type, 'BUYER',pbip.price, pbip.bid_currency_price)*decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,decode(l_contract_type, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)), l_amount_mask) bid_amount,
2716: --response/inquiry/server/ViewBidItemsVORowImpl.java:getBidTotalDisplay(): exchange_rate * PON_TRANSFORM_BIDDING_PKG.calculate_quote_amount (paip.auction_header_id, pbip.line_number, pbip.bid_number, 'TRANSFORMED', 12637, 12438, -1) bid_amount,
2717: --bidpdf: Bid Minimum Release Amount
2718: decode(p_user_view_type, 'BUYER', to_char(pbip.po_min_rel_amount, l_amount_mask), to_char(pbip.po_bid_min_rel_amount, l_amount_mask)) bid_min_rel_amount,
2719: --bidpdf: MAS Score