View: GLFV_GL_SETS_OF_BOOKS

Product:	GL - General Ledger
Description:	General Ledger sets of books are accounting organizations. Each set of books is defined by a particular functional currency, charts of accounts, and accounting calendar.
Implementation/DBA Data:	APPS.GLFV_GL_SETS_OF_BOOKS

View Text

SELECT SB.LEDGER_ID
, SB.NAME
, SB.SHORT_NAME
, SB.CHART_OF_ACCOUNTS_ID
, COA.ID_FLEX_STRUCTURE_NAME
, SB.CURRENCY_CODE
, SB.PERIOD_SET_NAME
, SB.FUTURE_ENTERABLE_PERIODS_LIMIT
, SB.LATEST_OPENED_PERIOD_NAME
, SB.LATEST_ENCUMBRANCE_YEAR
, SB.DESCRIPTION
, '_LA:SB.ALC_LEDGER_TYPE_CODE:GL_LOOKUPS:MRC_SOB_TYPE:MEANING'
, '_LA:SB.SUSPENSE_ALLOWED_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:SB.ALLOW_INTERCOMPANY_POST_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:SB.ENABLE_AVERAGE_BALANCES_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:SB.ENABLE_BUDGETARY_CONTROL_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:SB.REQUIRE_BUDGET_JOURNALS_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:SB.ENABLE_JE_APPROVAL_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:SB.ENABLE_AUTOMATIC_TAX_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:SB.CONSOLIDATION_LEDGER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:SB.TRANSLATE_EOD_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:SB.TRANSLATE_QATD_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:SB.TRANSLATE_YATD_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:SB.TRACK_ROUNDING_IMBALANCE_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_DF:SQLGL:GL_SETS_OF_BOOKS:SB'
FROM GL_LEDGERS SB
, FND_ID_FLEX_STRUCTURES_TL COA
WHERE (SB.CHART_OF_ACCOUNTS_ID = COA.ID_FLEX_NUM)
AND (COA.ID_FLEX_CODE = 'GL#')
AND (COA.APPLICATION_ID = 101)
AND (COA.LANGUAGE = USERENV('LANG')) WITH READ ONLY

Columns