FND Design Data [Home] [Help]

View: GL_BUDGETS_CURRENT_V

Product: GL - General Ledger
Description: 10SC ONLY
Implementation/DBA Data: ViewAPPS.GL_BUDGETS_CURRENT_V
View Text

SELECT BV.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BUD.BUDGET_NAME BUDGET_NAME
, BUD.LEDGER_ID LEDGER_ID
, BUD.FIRST_VALID_PERIOD_NAME FIRST_VALID_PERIOD_NAME
, BUD.LAST_VALID_PERIOD_NAME LAST_VALID_PERIOD_NAME
FROM GL_BUDGETS BUD
, GL_BUDGET_VERSIONS BV
WHERE BUD.BUDGET_NAME = BV.BUDGET_NAME
AND BUD.BUDGET_TYPE = BV.BUDGET_TYPE
AND BUD.STATUS IN ('O'
, 'C'
, 'F')

Columns

Name
BUDGET_VERSION_ID
BUDGET_NAME
LEDGER_ID
FIRST_VALID_PERIOD_NAME
LAST_VALID_PERIOD_NAME