VIEW: APPS.GL_BUDGETS_AUTOCOPY_V

Source

View Text - Preformatted

SELECT b.budget_name BUDGET_NAME, bv.budget_version_id BUDGET_VERSION_ID, b.ledger_id LEDGER_ID, start_per.period_num START_PERIOD_NUM, start_per.period_year START_PERIOD_YEAR, end_per.period_num END_PERIOD_NUM, end_per.period_year END_PERIOD_YEAR FROM gl_budgets b, gl_budget_versions bv, gl_period_statuses start_per, gl_period_statuses end_per WHERE b.status <> 'R' AND bv.budget_name = b.budget_name AND bv.budget_type = b.budget_type AND start_per.application_id = 101 AND start_per.ledger_id = b.ledger_id AND start_per.period_name = b.first_valid_period_name AND end_per.application_id = 101 AND end_per.ledger_id = b.ledger_id AND end_per.period_name = b.last_valid_period_name AND b.latest_opened_year is not null

View Text - HTML Formatted

SELECT B.BUDGET_NAME BUDGET_NAME
, BV.BUDGET_VERSION_ID BUDGET_VERSION_ID
, B.LEDGER_ID LEDGER_ID
, START_PER.PERIOD_NUM START_PERIOD_NUM
, START_PER.PERIOD_YEAR START_PERIOD_YEAR
, END_PER.PERIOD_NUM END_PERIOD_NUM
, END_PER.PERIOD_YEAR END_PERIOD_YEAR
FROM GL_BUDGETS B
, GL_BUDGET_VERSIONS BV
, GL_PERIOD_STATUSES START_PER
, GL_PERIOD_STATUSES END_PER
WHERE B.STATUS <> 'R'
AND BV.BUDGET_NAME = B.BUDGET_NAME
AND BV.BUDGET_TYPE = B.BUDGET_TYPE
AND START_PER.APPLICATION_ID = 101
AND START_PER.LEDGER_ID = B.LEDGER_ID
AND START_PER.PERIOD_NAME = B.FIRST_VALID_PERIOD_NAME
AND END_PER.APPLICATION_ID = 101
AND END_PER.LEDGER_ID = B.LEDGER_ID
AND END_PER.PERIOD_NAME = B.LAST_VALID_PERIOD_NAME
AND B.LATEST_OPENED_YEAR IS NOT NULL