VIEW: APPS.GLFV_GL_SETS_OF_BOOKS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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