FND Design Data [Home] [Help]

View: GLBV_GL_SETS_OF_BOOKS

Product: GL - General Ledger
Description:
Implementation/DBA Data: ViewAPPS.GLBV_GL_SETS_OF_BOOKS
View Text

SELECT GL_LEDGERS.LEDGER_ID
, GL_LEDGERS.NAME
, GL_LEDGERS.SHORT_NAME
, GL_LEDGERS.CHART_OF_ACCOUNTS_ID
, GL_LEDGERS.CURRENCY_CODE
, GL_LEDGERS.PERIOD_SET_NAME
, GL_LEDGERS.FUTURE_ENTERABLE_PERIODS_LIMIT
, GL_LEDGERS.LATEST_OPENED_PERIOD_NAME
, GL_LEDGERS.LATEST_ENCUMBRANCE_YEAR
, GL_LEDGERS.DESCRIPTION
, '_LA:GL_LEDGERS.ALC_LEDGER_TYPE_CODE:GL_LOOKUPS:MRC_SOB_TYPE:MEANING'
, '_LA:GL_LEDGERS.SUSPENSE_ALLOWED_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GL_LEDGERS.ALLOW_INTERCOMPANY_POST_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GL_LEDGERS.ENABLE_AVERAGE_BALANCES_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GL_LEDGERS.ENABLE_BUDGETARY_CONTROL_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GL_LEDGERS.REQUIRE_BUDGET_JOURNALS_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GL_LEDGERS.ENABLE_JE_APPROVAL_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GL_LEDGERS.ENABLE_AUTOMATIC_TAX_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GL_LEDGERS.CONSOLIDATION_LEDGER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GL_LEDGERS.TRANSLATE_EOD_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GL_LEDGERS.TRANSLATE_QATD_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GL_LEDGERS.TRANSLATE_YATD_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GL_LEDGERS.TRACK_ROUNDING_IMBALANCE_FLAG:GL_LOOKUPS:YES/NO:MEANING'
FROM GL_LEDGERS GL_LEDGERS

Columns

Name
LEDGER_ID
LEDGER_NAME
LEDGER_SHORT_NAME
CHART_OF_ACCOUNTS_ID
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"