Oracle Fusion ERP – Query to Fetch-Ledger, Balance Cube Details

SELECT 
 gl.ledger_id, 
 gl.name ledger_name, 
  gbc.cube_id,
  gbc.APPLICATION_NAME,
  gbc.cube_name,
  gbc.CUBE_TYPE,
  gbc.ESSBASE_SERVER_PORT
  
 FROM GL_LEDGERS GL, GL_BALANCES_CUBES  GBC

WHERE 1=1

AND gl.CHART_OF_ACCOUNTS_ID  = gbc.CHART_OF_ACCOUNTS_ID
AND gl.PERIOD_SET_NAME = gbc.PERIOD_SET_NAME