ORDER DETAILS QUERY

SELECT   hp.party_name customer_name, c.account_number,
         a.order_number sales_number,
         TO_CHAR (a.ordered_date, 'DD-MON-YYYY') ordered_date, a.order_type,
         a.cust_po_number, b.line_number, b.ordered_item, ordered_quantity,
         b.unit_list_price, a.price_list, a.agreement, a.salesrep_id,
         b.flow_status_code
    FROM oe_order_headers_v a,
         oe_order_lines_v b,
         hz_cust_accounts_all c,
         hz_parties hp
   WHERE a.header_id = b.header_id
     AND a.sold_to_org_id = c.cust_account_id
     AND c.party_id = hp.party_id
     AND TO_CHAR (a.creation_date, 'MON-YYYY') = 'JUL-2013'
     AND a.order_type NOT LIKE '%RETURN%'
ORDER BY 3, 7