VIEW: APPS.GL_BUDGETS_NO_JOURNALS_V

Source

View Text - Preformatted

SELECT b.budget_name BUDGET_NAME, b.ledger_id LEDGER_ID, b.latest_opened_year LATEST_OPENED_YEAR, b.first_valid_period_name FIRST_VALID_PERIOD_NAME, b.last_valid_period_name LAST_VALID_PERIOD_NAME, b.status STATUS, bv.budget_version_id BUDGET_VERSION_ID FROM gl_budgets b, gl_budget_versions bv WHERE b.budget_name = bv.budget_name AND b.budget_type = bv.budget_type AND b.status NOT in ('F', 'I') AND b.require_budget_journals_flag = 'N'

View Text - HTML Formatted

SELECT B.BUDGET_NAME BUDGET_NAME
, B.LEDGER_ID LEDGER_ID
, B.LATEST_OPENED_YEAR LATEST_OPENED_YEAR
, B.FIRST_VALID_PERIOD_NAME FIRST_VALID_PERIOD_NAME
, B.LAST_VALID_PERIOD_NAME LAST_VALID_PERIOD_NAME
, B.STATUS STATUS
, BV.BUDGET_VERSION_ID BUDGET_VERSION_ID
FROM GL_BUDGETS B
, GL_BUDGET_VERSIONS BV
WHERE B.BUDGET_NAME = BV.BUDGET_NAME
AND B.BUDGET_TYPE = BV.BUDGET_TYPE
AND B.STATUS NOT IN ('F'
, 'I')
AND B.REQUIRE_BUDGET_JOURNALS_FLAG = 'N'