[Home] [Help]
View: FV_BUDGETS_WITH_DATES_V
View Text
SELECT B.BUDGET_NAME BUDGET_NAME
, B.BUDGET_TYPE BUDGET_TYPE
, BV.BUDGET_VERSION_ID BUDGET_VERSION_ID
, B.LEDGER_ID SET_OF_BOOKS_ID
, B.FIRST_VALID_PERIOD_NAME FIRST_VALID_PERIOD_NAME
, B.LAST_VALID_PERIOD_NAME LAST_VALID_PERIOD_NAME
, B.LATEST_OPENED_YEAR LATEST_OPENED_YEAR
, B.REQUIRE_BUDGET_JOURNALS_FLAG REQUIRE_BUDGET_JOURNALS_FLAG
, B.STATUS STATUS
, START_PER.START_DATE START_DATE
, DEST_PER.END_DATE END_DATE
FROM GL_BUDGETS B
, GL_BUDGET_VERSIONS BV
, GL_PERIOD_STATUSES START_PER
, GL_PERIOD_STATUSES DEST_PER
WHERE B.BUDGET_NAME = BV.BUDGET_NAME
AND B.BUDGET_TYPE = BV.BUDGET_TYPE
AND START_PER.APPLICATION_ID = 101
AND START_PER.SET_OF_BOOKS_ID = B.LEDGER_ID
AND START_PER.PERIOD_NAME = B.FIRST_VALID_PERIOD_NAME
AND DEST_PER.APPLICATION_ID = 101
AND DEST_PER.SET_OF_BOOKS_ID = B.LEDGER_ID
AND DEST_PER.PERIOD_NAME = B.LAST_VALID_PERIOD_NAME
Columns
Name |
BUDGET_NAME |
BUDGET_TYPE |
BUDGET_VERSION_ID |
SET_OF_BOOKS_ID |
FIRST_VALID_PERIOD_NAME |
LAST_VALID_PERIOD_NAME |
LATEST_OPENED_YEAR |
REQUIRE_BUDGET_JOURNALS_FLAG |
STATUS |
START_DATE |
END_DATE |