Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

WITH t(INVOICE_NUM, INVOICE_DATE, ORDER_CODE, ORDER_COST) AS
(
  SELECT   509, date'2020-02-14', 'ORD001', 34.99 FROM DUAL UNION ALL
  SELECT   509, date'2020-02-14', 'ORD002', 14.99 FROM DUAL UNION ALL
  SELECT   509, date'2020-02-14', 'ORD003', 59.99 FROM DUAL UNION ALL
  SELECT   428, date'2020-01-16', 'ORD001', 34.99 FROM DUAL UNION ALL
  SELECT   428, date'2020-01-16', 'ORD002', 14.99 FROM DUAL UNION ALL
  SELECT   306, date'2019-12-14', 'ORD001', 34.99 FROM DUAL UNION ALL
  SELECT   306, date'2019-12-14', 'ORD002', 14.99 FROM DUAL UNION ALL
  SELECT   201, date'2019-11-15', 'ORD001', 34.99 FROM DUAL UNION ALL
  SELECT   108, date'2019-10-16', 'ORD001', 34.99 FROM DUAL
)  
SELECT order_code, 
       SUM(CASE WHEN invoice_num = 509 then order_cost END ) AS current_invoice_total,
       SUM(CASE WHEN to_char(sysdate,'yyyy') = to_char(invoice_date,'yyyy') then
                  order_cost
              END ) AS ytd_total,
       SUM(CASE WHEN invoice_date 
             BETWEEN to_date(to_char(sysdate,'yyyy')-1||'-11-01','yyyy-mm-dd')
                 AND to_date(to_char(sysdate,'yyyy')||'-10-31'  ,'yyyy-mm-dd')
             THEN
                  order_cost
              END ) AS fiscal_ytd_total              
  FROM t
 GROUP BY order_code
 ORDER BY order_code

ORDER_CODE	CURRENT_INVOICE_TOTAL	YTD_TOTAL	FISCAL_YTD_TOTAL
ORD001	34.99	69.98	139.96
ORD002	14.99	29.98	44.97
ORD003	59.99	59.99	59.99

WITH t(INVOICE_NUM, INVOICE_DATE, ORDER_CODE, ORDER_COST) AS
(
  SELECT   509, date'2020-02-14', 'ORD001', 34.99 FROM DUAL UNION ALL
  SELECT   509, date'2020-02-14', 'ORD002', 14.99 FROM DUAL UNION ALL
  SELECT   509, date'2020-02-14', 'ORD003', 59.99 FROM DUAL UNION ALL
  SELECT   428, date'2020-01-16', 'ORD001', 34.99 FROM DUAL UNION ALL
  SELECT   428, date'2020-01-16', 'ORD002', 14.99 FROM DUAL UNION ALL
  SELECT   306, date'2019-12-14', 'ORD001', 34.99 FROM DUAL UNION ALL
  SELECT   306, date'2019-12-14', 'ORD002', 14.99 FROM DUAL UNION ALL
  SELECT   201, date'2019-11-15', 'ORD001', 34.99 FROM DUAL UNION ALL
  SELECT   108, date'2019-10-16', 'ORD001', 34.99 FROM DUAL
)
SELECT t.order_code, 
       SUM(CASE WHEN invoice_num = 509 THEN order_cost END ) 
             AS current_invoice_total,
       SUM(CASE WHEN invoice_date 
             BETWEEN TRUNC(invoice_date2,'yyyy')
                 AND invoice_date2
                THEN
                     order_cost
                END ) AS ytd_total,
       SUM(CASE WHEN invoice_date 
             BETWEEN to_date(to_char(invoice_date2,'yyyy')-1||'-11-01','yyyy-mm-dd')
                 AND invoice_date2
                THEN
                     order_cost
                END ) AS fiscal_ytd_total           
  FROM t
 CROSS JOIN ( SELECT MAX(invoice_date) AS invoice_date2 
                FROM t 
               WHERE invoice_num = 509 ) t2
 GROUP BY order_code
 ORDER BY order_code

ORDER_CODE	CURRENT_INVOICE_TOTAL	YTD_TOTAL	FISCAL_YTD_TOTAL
ORD001	34.99	69.98	139.96
ORD002	14.99	29.98	44.97
ORD003	59.99	59.99	59.99