VIEW: APPS.GL_BUDGETS_TARGET_BUDGETS_V

Source

View Text - Preformatted

SELECT bv.budget_name BUDGET_NAME, bv.budget_version_id BUDGET_VERSION_ID, b.description DESCRIPTION, b.ledger_id LEDGER_ID, ps1.period_name START_PERIOD_NAME, ps1.period_num START_PERIOD_NUM, ps1.period_year START_PERIOD_YEAR, ps2.period_name END_PERIOD_NAME, ps2.period_num END_PERIOD_NUM, ps2.period_year END_PERIOD_YEAR FROM gl_period_statuses ps1, gl_period_statuses ps2, gl_budget_versions bv, gl_budgets b WHERE bv.budget_name = b.budget_name AND ps1.period_name = b.first_valid_period_name AND ps1.application_id = 101 AND ps1.ledger_id = b.ledger_id AND ps2.period_name = b.last_valid_period_name AND ps2.application_id = 101 AND ps2.ledger_id = b.ledger_id

View Text - HTML Formatted

SELECT BV.BUDGET_NAME BUDGET_NAME
, BV.BUDGET_VERSION_ID BUDGET_VERSION_ID
, B.DESCRIPTION DESCRIPTION
, B.LEDGER_ID LEDGER_ID
, PS1.PERIOD_NAME START_PERIOD_NAME
, PS1.PERIOD_NUM START_PERIOD_NUM
, PS1.PERIOD_YEAR START_PERIOD_YEAR
, PS2.PERIOD_NAME END_PERIOD_NAME
, PS2.PERIOD_NUM END_PERIOD_NUM
, PS2.PERIOD_YEAR END_PERIOD_YEAR
FROM GL_PERIOD_STATUSES PS1
, GL_PERIOD_STATUSES PS2
, GL_BUDGET_VERSIONS BV
, GL_BUDGETS B
WHERE BV.BUDGET_NAME = B.BUDGET_NAME
AND PS1.PERIOD_NAME = B.FIRST_VALID_PERIOD_NAME
AND PS1.APPLICATION_ID = 101
AND PS1.LEDGER_ID = B.LEDGER_ID
AND PS2.PERIOD_NAME = B.LAST_VALID_PERIOD_NAME
AND PS2.APPLICATION_ID = 101
AND PS2.LEDGER_ID = B.LEDGER_ID