View: GLBV_GL_BUDGET_ASSIGNMENTS

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.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