[Home] [Help]
View: 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
Name |
BUDGET_NAME |
BUDGET_VERSION_ID |
DESCRIPTION |
LEDGER_ID |
START_PERIOD_NAME |
START_PERIOD_NUM |
START_PERIOD_YEAR |
END_PERIOD_NAME |
END_PERIOD_NUM |
END_PERIOD_YEAR |