订单相关金额API

declare
  x_subtotal number;
  x_discount number;
  x_charges number;
  x_tax number;
begin
oe_oe_totals_summary.ORDER_TOTALS(p_header_id => 190978
                                ,p_subtotal => x_subtotal
                                ,p_discount => x_discount
                                ,p_charges => x_charges
                                ,p_tax => x_tax);
dbms_output.put_line('subtotal:'||x_subtotal);  
dbms_output.put_line('discount:'||x_discount);
dbms_output.put_line('charges:'||x_charges);
dbms_output.put_line('tax:'||x_tax);                            
end;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13387766/viewspace-766973/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13387766/viewspace-766973/