View: GLFV_GL_BUDGET_ASSIGNMENTS

Product:	GL - General Ledger
Description:	General Ledger budget assignements are accounts associated with a budget organization.
Implementation/DBA Data:	APPS.GLFV_GL_BUDGET_ASSIGNMENTS

View Text

SELECT G.LEDGER_ID
, GL_LEDGERS.NAME
, G.BUDGET_ENTITY_ID
, GL_BUDGET_ENTITY.NAME
, G.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GCC'
, G.CURRENCY_CODE
, '_LA:G.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
, GL_BUDGET_VERSION.BUDGET_NAME
, '_LA:BC.FUNDS_CHECK_LEVEL_CODE:GL_LOOKUPS:FUNDS_CHECK_LEVEL:MEANING'
, NULL
FROM GL_BUDGET_ASSIGNMENTS G
, GL_BUDORG_BC_OPTIONS BC
, GL_LEDGERS GL_LEDGERS
, GL_BUDGET_ENTITIES GL_BUDGET_ENTITY
, GL_CODE_COMBINATIONS GCC
, GL_BUDGET_VERSIONS GL_BUDGET_VERSION
WHERE (G.CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID)
AND (G.LEDGER_ID=GL_LEDGERS.LEDGER_ID)
AND (BC.RANGE_ID(+) = G.RANGE_ID)
AND (G.BUDGET_ENTITY_ID=GL_BUDGET_ENTITY.BUDGET_ENTITY_ID)
AND (BC.FUNDING_BUDGET_VERSION_ID= GL_BUDGET_VERSION.BUDGET_VERSION_ID(+))
AND '_SEC:GL:G.LEDGER_ID
, G.CODE_COMBINATION_ID' IS NOT NULL WITH READ ONLY

Columns