Query to get the details of discounts on the orders in Order Management

SELECT   h.transactional_curr_code           Currency2,

      ot.name                       Order_Type,

      DECODE(SUBSTR(UPPER(:P_ORDER_BY),1,1),'C',CUST_ACCT.CUST_ACCOUNT_ID,NULL) CUSTOMER_ID,

      DECODE(SUBSTR(UPPER(:P_ORDER_BY),1,1),'C',PARTY.PARTY_NAME,NULL) CUSTOMER_NAME_2,

      h.order_number                Order_Number,

      PARTY.PARTY_NAME  CUSTOMER_NAME_1, 

      CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER,

            h.ordered_date                Order_Date,