Wednesday, March 26, 2014

How to calculate total of Oracle Sales Order


Here is the logic/sql to find out total of Oracle Sales Order, I have used this logic to derive total of oracle sales order for reporting purposes-


x_subtotal number;

x_discount number;

x_charges number;

x_tax NUMBER;

x_total number:





                              p_subtotal =>x_subtotal,

                              p_discount =>x_discount,

                              p_charges  =>x_charges,

                              p_tax      =>x_tax


dbms_output.put_line('sagar') ;                            

dbms_output.put_line('x_subtotal:'|| x_subtotal) ;  

dbms_output.put_line('x_discount:'|| x_discount) ;  

dbms_output.put_line('x_charges:'|| x_charges) ;  

dbms_output.put_line('x_tax:'|| x_tax) ; 

x_total:= x_subtotal+ x_charges+ x_tax;

dbms_output.put_line(‘x_total:'|| x_total) ; 


  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.

  2. Simply wish to say your article is as astonishing. The clarity in your post is simply great, and I could assume you are an expert on this subject. Same as your blog i found another one apex oracle .Actually I was looking for the same information on internet for Oracle APEX and came across your blog. I am impressed by the information that you have on this blog. Thanks a million and please keep up the gratifying work.