VIEW: APPS.GLFV_GL_BUDGET_ASSIGNMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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