VIEW: APPS.FV_BUDGETS_WITH_DATES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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