Loading

Tuesday, June 15, 2010

API To Find Sales Order's Subtotal,discount,charges and Tax (OE_OE_TOTALS_SUMMARY.ORDER_TOTALS)



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;

 DECLARE

  v_HEADER_ID NUMBER;
  v_SUBTOTAL  NUMBER;
  v_DISCOUNT  NUMBER;
  v_CHARGES   NUMBER;
  v_TAX       NUMBER;

BEGIN

  v_HEADER_ID := 5908;

  OE_OE_TOTALS_SUMMARY.ORDER_TOTALS(
    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);

END;

0 Responses to “API To Find Sales Order's Subtotal,discount,charges and Tax (OE_OE_TOTALS_SUMMARY.ORDER_TOTALS)”

Post a Comment

Disclaimer

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.