[Home] [Help]
View: GL_BUDGETS_NO_JOURNALS_V
View Text
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'
Columns
Name |
BUDGET_NAME |
LEDGER_ID |
LATEST_OPENED_YEAR |
FIRST_VALID_PERIOD_NAME |
LAST_VALID_PERIOD_NAME |
STATUS |
BUDGET_VERSION_ID |