Trial Balance Report

SELECT 
  c.SEGMENT1 AS COMPANY,
  c.SEGMENT2 AS ACCOUNT,
  c.SEGMENT3 AS COST_CENTER,
  c.SEGMENT4 AS PRODUCT,
  c.SEGMENT5 AS INTERCOMPANY,
  a.ACCOUNT_DESCRIPTION,
  SUM(b.PERIOD_NET_DR) AS DEBIT_AMOUNT,
  SUM(b.PERIOD_NET_CR) AS CREDIT_AMOUNT,
  SUM(b.PERIOD_NET_DR - b.PERIOD_NET_CR) AS NET_BALANCE,
  SUM(b.BEGIN_BALANCE_DR - b.BEGIN_BALANCE_CR) AS BEGINNING_BALANCE,
  c.ENABLED_FLAG,
  c.START_DATE_ACTIVE,
  c.END_DATE_ACTIVE
FROM GL_BALANCES b
JOIN GL_CODE_COMBINATIONS c ON b.CODE_COMBINATION_ID = c.CODE_COMBINATION_ID
JOIN GL_ACCOUNTS a ON c.SEGMENT2 = a.ACCOUNT_NUMBER
WHERE b.PERIOD_NAME = :period_name
  AND b.ACTUAL_FLAG = 'A'
  AND (:company IS NULL OR c.SEGMENT1 = :company)
  AND (:account_from IS NULL OR c.SEGMENT2 >= :account_from)
  AND (:account_to IS NULL OR c.SEGMENT2 <= :account_to)
  AND c.ENABLED_FLAG = 'Y'
  AND TRUNC(SYSDATE) BETWEEN c.START_DATE_ACTIVE AND NVL(c.END_DATE_ACTIVE, TRUNC(SYSDATE))
GROUP BY c.SEGMENT1, c.SEGMENT2, c.SEGMENT3, c.SEGMENT4, c.SEGMENT5, a.ACCOUNT_DESCRIPTION,
         c.ENABLED_FLAG, c.START_DATE_ACTIVE, c.END_DATE_ACTIVE
HAVING SUM(b.PERIOD_NET_DR - b.PERIOD_NET_CR) != 0
ORDER BY c.SEGMENT1, c.SEGMENT2, c.SEGMENT3, c.SEGMENT4, c.SEGMENT5