[Home] [Help]
View: GLBV_GL_BUDGET_ASSIGNMENTS
View Text
SELECT GBA.LEDGER_ID
, GL_LEDGERS.NAME
, GBA.BUDGET_ENTITY_ID
, GBA.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GCC'
, GBA.CURRENCY_CODE
, '_LA:GBA.ENTRY_CODE:GL_LOOKUPS:ENTRY_CODE:MEANING'
, '_LA:BC.AMOUNT_TYPE:GL_LOOKUPS:PTD_YTD:DESCRIPTION'
, '_LA:BC.BOUNDARY_CODE:GL_LOOKUPS:BOUNDARY_TYPE:MEANING'
, BC.FUNDING_BUDGET_VERSION_ID
, '_LA:BC.FUNDS_CHECK_LEVEL_CODE:GL_LOOKUPS:FUNDS_CHECK_LEVEL:MEANING'
, NULL
FROM GL_BUDGET_ASSIGNMENTS GBA
, GL_BUDORG_BC_OPTIONS BC
, GL_CODE_COMBINATIONS GCC
, GL_LEDGERS GL_LEDGERS
WHERE (GBA.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID )
AND (GBA.LEDGER_ID = GL_LEDGERS.LEDGER_ID)
AND (BC.RANGE_ID(+) = GBA.RANGE_ID)
AND '_SEC:GL:GBA.LEDGER_ID
, GBA.CODE_COMBINATION_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
LEDGER_ID |
LEDGER_NAME |
BUDGET_ORGANIZATION_ID |
ACCOUNT_ID |
"_KF:ACCOUNT" |
CURRENCY |
"_LA:ENTRY_TYPE" |
"_LA:AMOUNT_TYPE" |
"_LA:BOUNDARY" |
FUNDING_BUDGET_ID |
"_LA:FUNDS_CHECK_LEVEL" |
AUTO_ENCUMBRANCE_FLAG |