VIEW: APPS.GL_LEDGER_NAMES_V

Source

View Text - Preformatted

SELECT gl.name, gl.short_name, gl.ledger_id, gl.chart_of_accounts_id, gl.period_set_name, gl.currency_code, gl.enable_average_balances_flag, gl.consolidation_ledger_flag FROM gl_ledgers gl WHERE nvl(gl.complete_flag,'Y') = 'Y'

View Text - HTML Formatted

SELECT GL.NAME
, GL.SHORT_NAME
, GL.LEDGER_ID
, GL.CHART_OF_ACCOUNTS_ID
, GL.PERIOD_SET_NAME
, GL.CURRENCY_CODE
, GL.ENABLE_AVERAGE_BALANCES_FLAG
, GL.CONSOLIDATION_LEDGER_FLAG
FROM GL_LEDGERS GL
WHERE NVL(GL.COMPLETE_FLAG
, 'Y') = 'Y'