View: GLFV_GL_BUDGETS

Product:	GL - General Ledger
Description:	General Ledger budgets are a collection of estimated amounts for a range of accounting periods.
Implementation/DBA Data:	APPS.GLFV_GL_BUDGETS

View Text

SELECT GL_BUDGET_VERSION.BUDGET_VERSION_ID
, GL_BUDGET.BUDGET_NAME
, GL_BUDGET.LEDGER_ID
, GL_LEDGERS.NAME
, '_LA:GL_BUDGET.STATUS:GL_LOOKUPS:PLAN/VERSION STATUS:MEANING'
, GL_BUDGET.DATE_CREATED
, GL_BUDGET.DATE_CLOSED
, GL_BUDGET.FIRST_VALID_PERIOD_NAME
, GL_BUDGET.LAST_VALID_PERIOD_NAME
, GL_BUDGET.LATEST_OPENED_YEAR
, '_LA:GL_BUDGET.REQUIRE_BUDGET_JOURNALS_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, GL_BUDGET.DESCRIPTION
, '_DF:SQLGL:GL_BUDGETS:GL_BUDGET'
FROM GL_BUDGETS GL_BUDGET
, GL_LEDGERS GL_LEDGERS
, GL_BUDGET_VERSIONS GL_BUDGET_VERSION
WHERE (GL_BUDGET.LEDGER_ID = GL_LEDGERS.LEDGER_ID)
AND (GL_BUDGET.BUDGET_NAME = GL_BUDGET_VERSION.BUDGET_NAME)
AND (GL_BUDGET.BUDGET_TYPE = GL_BUDGET_VERSION.BUDGET_TYPE)
AND '_SEC:GL:GL_BUDGET.LEDGER_ID' IS NOT NULL WITH READ ONLY

Columns