FND Design Data [Home] [Help]

View: GL_BUDGETS_SOURCE_BUDGETS_V

Product: GL - General Ledger
Description: 10SC ONLY
Implementation/DBA Data: ViewAPPS.GL_BUDGETS_SOURCE_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
, BPR.PERIOD_YEAR BUDGET_RANGE_PERIOD_YEAR
, BPR.START_PERIOD_NUM BUDGET_RANGE_START_PERIOD_NUM
, BPR.END_PERIOD_NUM BUDGET_RANGE_END_PERIOD_NUM
FROM GL_BUDGET_PERIOD_RANGES BPR
, GL_BUDGETS B
, GL_BUDGET_VERSIONS BV
WHERE BV.BUDGET_VERSION_ID = BPR.BUDGET_VERSION_ID AND BV.BUDGET_NAME = B.BUDGET_NAME

Columns

Name
BUDGET_NAME
BUDGET_VERSION_ID
DESCRIPTION
LEDGER_ID
BUDGET_RANGE_PERIOD_YEAR
BUDGET_RANGE_START_PERIOD_NUM
BUDGET_RANGE_END_PERIOD_NUM