Query to get the OM Sales Order summary details

  SELECT h.transactional_curr_code Currency,

         h.conversion_rate Conversion_rate,

         h.conversion_type_code Conversion_Type_Code,

         h.transactional_curr_code use_currency,

         DECODE (SUBSTR (UPPER (:p_order_by), 1, 1), 'S', sr.name, NULL)

            Sales_Person,

         DECODE (SUBSTR (UPPER (:p_order_by), 1, 1), 'O', h.ordered_date, NULL)

            dummy_order_date,

         DECODE (SUBSTR (UPPER (:p_order_by), 1, 1), 'A', agree.name, NULL)

            dummy_agreement,

Retroactive billing report in oracle order management

SELECT DECODE (:p_sort_by, 'O', orig_head.order_number) sort_by_order_number,

       DECODE (

          :p_sort_by,

          'T', oe_retrobill_pvt.invoice_number (orig_head.order_number,

                                                orig_lin.line_id,

                                                orig_head.order_type_id),

          NULL)

          sort_by_invoice_no,

       DECODE (

          SUBSTR (UPPER (:p_item_display), 1, 1),