Tuesday, June 15, 2010
Below script will help you to find Sales Order's subtotal, discount, charges and Tax through API OE_OE_TOTALS_SUMMARY.ORDER_TOTALS
This script was tested in R12.1.1
SET SERVEROUTPUT ON;
v_HEADER_ID := 5908;
P_HEADER_ID => v_HEADER_ID,
P_SUBTOTAL => v_SUBTOTAL,
P_DISCOUNT => v_DISCOUNT,
P_CHARGES => v_CHARGES,
P_TAX => V_TAX
DBMS_OUTPUT.PUT_LINE('SUBTOTAL = ' || v_SUBTOTAL);
DBMS_OUTPUT.PUT_LINE('DISCOUNT = ' || v_DISCOUNT);
DBMS_OUTPUT.PUT_LINE('CHARGES = ' || v_CHARGES);
DBMS_OUTPUT.PUT_LINE('TAX = ' || v_TAX);
Do you think this Article is useful?
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.