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-
declare
x_subtotal number;
x_discount number;
x_charges number;
x_tax NUMBER;
x_total number:
begin
OE_OE_TOTALS_SUMMARY.Order_Totals
(
p_header_id=>6040357,
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) ;
end;
Regards
ReplyDeleteSridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.
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.
ReplyDelete