oracle8.1.6
select i.item_id, p.product_name, nvl(i.price_charged,0) as price_charged, nvl(i.shipping_charged,0) as shipping_charged,
nvl(i.price_tax_charged,0) as price_tax_charged, nvl(i.shipping_tax_charged,0) as shipping_tax_charged
from ec_items i, ec_products p
where i.product_id=p.product_id
and i.item_id in ([join $item_id_list ", "])
select nvl(ec_tax(:tax_price_to_refund, 0, :order_id),0)
from dual
select nvl(ec_tax(0, $shipping_to_refund($item_id), :order_id),0)
from dual
select nvl(shipping_charged,0) - nvl(shipping_refunded,0) as base_shipping, nvl(shipping_tax_charged,0) - nvl(shipping_tax_refunded,0) as base_shipping_tax
from ec_orders
where order_id = :order_id
select nvl(ec_tax(0, :base_shipping, :order_id),0)
from dual
select nvl(ec_cash_amount_to_refund(:total_amount_to_refund, :order_id),0)
from dual