Select orde.no orde_no,
       orli.no orli_no,
       TO_CHAR(orde.created_date, 'DD/MON/YYYY') created_date,
       DECODE(orli.status,
              'V',
              'Voided',
              'R',
              'Regular',
              'F',
              'Foreign Shipment Pending',
              'C',
              'Cancelled',
              'B',
              'Back Ordered') orli_status,
       orli.prod_prds_product_code product_code,
       orli.prod_item_number item_number,
       prod.full_title prod_description,
       sum(orli.quantity) quantity,
       sum(orli.licensed_quantity) licensed_quantity,
       sum(orli.product_charge) product_charge,
       DECODE(orli.standing_order_flag, 'N', 'NO', 'Y', 'YES') standing_order_flag,
       TO_CHAR(orli.gds_date, 'DD/MON/YYYY') gds_date,
       inli.invo_no invoice_number,
       sum(ilac.net_amount) net_amount,
       orde.acco_no account_number
  From orders                        orde,
       Order_line_items              orli,
       Products                      prod,
       Invoice_line_items            inli,
       Invoice_line_item_adj_cancels ilac
 Where (trunc(orde.created_date) > add_months(trunc(sysdate), -24) And
       orli.orde_no = orde.no And
       prod.prds_product_code = orli.prod_prds_product_code And
       prod.item_number = orli.prod_item_number And
       prod.product_type not in ('BBSB', 'BBSS', 'SUB', 'PARU', 'SUBS') And
       inli.orli_orde_no(+) = orli.orde_no And inli.orli_no(+) = orli.no And
       ilac.inli_invo_no(+) = inli.invo_no And ilac.inli_no(+) = inli.no)
    OR ((orli.created_date >= &p_date or orli.modified_date >= &p_date) or
       (inli.created_date >= &p_date or inli.modified_date >= &p_date));