VIEW: APPS.GLBV_GL_SETS_OF_BOOKS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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