237: decode(nvl(to_char(oh.end_customer_id),'X'),'X',l_expert_no,l_expert_yes) end_cust_exist,
238: oh.price_list_id,
239: oh.tax_exempt_flag,
240: oh.sales_channel_code,
241: oe_oe_totals_summary.prt_order_total(oh.header_id) total,
242: oe_oe_totals_summary.price_adjustments(oh.header_id) total_adjusted_amount,
243: oe_oe_totals_summary.get_order_amount(oh.header_id) total_list_price,
244: bh.header_id blanket_header_id,
245: -- XY
238: oh.price_list_id,
239: oh.tax_exempt_flag,
240: oh.sales_channel_code,
241: oe_oe_totals_summary.prt_order_total(oh.header_id) total,
242: oe_oe_totals_summary.price_adjustments(oh.header_id) total_adjusted_amount,
243: oe_oe_totals_summary.get_order_amount(oh.header_id) total_list_price,
244: bh.header_id blanket_header_id,
245: -- XY
246: oh.order_number,
239: oh.tax_exempt_flag,
240: oh.sales_channel_code,
241: oe_oe_totals_summary.prt_order_total(oh.header_id) total,
242: oe_oe_totals_summary.price_adjustments(oh.header_id) total_adjusted_amount,
243: oe_oe_totals_summary.get_order_amount(oh.header_id) total_list_price,
244: bh.header_id blanket_header_id,
245: -- XY
246: oh.order_number,
247: oh.quote_number,