GL List of Budget Names (Oracle Fusion SQL)

Enterprise Resource Planning (ERP) Oracle General Ledger (GL-Fusion-SQL's)
1

This GL list of budget names query lists budget names and periods by ledger (set of books), helping users track financial planning across ledgers.

#sqlquery

SELECT DISTINCT
  -- SQL4Fusion (An Orbit Analytics Project)
  -- Lists budget names and periods by ledger
  GL.NAME SOB_NAME,
  GL.DESCRIPTION SOB_DESCRIPTION,
  GBB.BUDGET_NAME BUDGET_NAME,
  GBB.PERIOD_NAME BUDGET_PERIOD
FROM
  GL_BUDGET_BALANCES GBB,
  GL_LEDGERS GL
WHERE
  1 = 1
  AND GBB.LEDGER_ID = GL.LEDGER_ID;