eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

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:	Not implemented in this database

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

Name
LEDGER_ID
LEDGER_NAME
LEDGER_SHORT_NAME
CHART_OF_ACCOUNTS_ID
CHART_OF_ACCOUNTS_NAME
FUNCTIONAL_CURRENCY
ACCOUNTING_CALENDAR
FUTURE_PERIODS
LATEST_OPENED_PERIOD
LATEST_OPENED_ENCUMBRANCE_YEAR
DESCRIPTION
"_LA:REPORTING_BOOKS_TYPE"
"_LA:ALLOW_SUSPENSE_FLAG"
"_LA:BALANCE_INTERCO_JE_FLAG"
"_LA:ENABLE_AVERAGE_BAL_FLAG"
"_LA:ENABLE_BUDGET_CTRL_FLAG"
"_LA:REQUIRE_BUDGET_JE_FLAG"
"_LA:ENABLE_JE_APPROVAL_FLAG"
"_LA:ENABLE_JE_TAX_FLAG"
"_LA:CONSOLIDATION_BOOK_FLAG"
"_LA:TRANSLATE_EOD_FLAG"
"_LA:TRANSLATE_QATD_FLAG"
"_LA:TRANSLATE_YATD_FLAG"
"_LA:ROUNDING_IMBALANCE_FLAG"
_DF