[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
1519: pah.supplier_enterable_pymt_flag,
1520: pah.project_id sourcing_project_id,
1521: pah.bid_decrement_method,
1522: proj.segment1 sourcing_project_number,
1523: DECODE(pah.contract_type, 'STANDARD', DECODE(progress_payment_type,'NONE','N','Y'),'N') complex_services_enabled,
1524: postyl.advances_flag,
1525: postyl.retainage_flag,
1526: postyl.progress_payment_flag,
1527: postyl.contract_financing_flag,
1566: 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,
1567: pon_printing_pkg.format_number(pbip.quantity) bid_quantity,
1568: 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,
1569: --in MAS case, pbip.quantity is null, use paip.quantity instead
1570: to_char(decode(p_user_view_type, 'BUYER',pbip.price, pbip.bid_currency_price)*decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,decode(pah.contract_type, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)), l_amount_mask) bid_amount,
1571: --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,
1572: --bidpdf: Bid Minimum Release Amount
1573: 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,
1574: --bidpdf: MAS Score