VIEW: APPS.GL_BUDGETS_NAME_V

Source

View Text - Preformatted

SELECT b.budget_name BUDGET_NAME, bv.budget_version_id BUDGET_VERSION_ID, b.ledger_id LEDGER_ID, b.status STATUS, b.require_budget_journals_flag REQUIRE_BUDGET_JOURNALS_FLAG, b.description DESCRIPTION, b.latest_opened_year LATEST_OPENED_YEAR FROM gl_budgets b, gl_budget_versions bv WHERE bv.budget_name = b.budget_name

View Text - HTML Formatted

SELECT B.BUDGET_NAME BUDGET_NAME
, BV.BUDGET_VERSION_ID BUDGET_VERSION_ID
, B.LEDGER_ID LEDGER_ID
, B.STATUS STATUS
, B.REQUIRE_BUDGET_JOURNALS_FLAG REQUIRE_BUDGET_JOURNALS_FLAG
, B.DESCRIPTION DESCRIPTION
, B.LATEST_OPENED_YEAR LATEST_OPENED_YEAR
FROM GL_BUDGETS B
, GL_BUDGET_VERSIONS BV
WHERE BV.BUDGET_NAME = B.BUDGET_NAME