[Oracle]查詢YTD

SELECT GCC.SEGMENT1 || '.' || GCC.SEGMENT2 || '.' || GCC.SEGMENT3 || '.' ||
       GCC.SEGMENT4 ACCOUNTING,
       SUM(GB.PERIOD_NET_DR),
       SUM(GB.PERIOD_NET_CR),
       SUM(GB.PERIOD_NET_DR) - SUM(GB.PERIOD_NET_CR)
  FROM GL_BALANCES GB, GL_CODE_COMBINATIONS GCC
 WHERE 1 = 1
   AND GB.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
      --AND PERIOD_NAME = '04-21'
      --AND GCC.SEGMENT2 = 220019
      --AND GCC.SEGMENT3 = 2241
      -- AND GCC.SEGMENT4 = 011400
   AND PERIOD_NAME NOT IN ('05-21', '06-21', '07-21')
 GROUP BY GCC.SEGMENT1 || '.' || GCC.SEGMENT2 || '.' || GCC.SEGMENT3 || '.' ||
          GCC.SEGMENT4,
          GB.CODE_COMBINATION_ID