View: GL_BUDGETS_TARGET_BUDGETS_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_BUDGETS_TARGET_BUDGETS_V

View Text

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

Columns