VIEW: APPS.GLBV_GL_BUDGET_ASSIGNMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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