FND Design Data [Home] [Help]

View: GL_CONS_BUDGET_NAMES_V

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

SELECT B.BUDGET_NAME BUDGET_NAME
, BV.BUDGET_VERSION_ID BUDGET_VERSION_ID
, B.LEDGER_ID LEDGER_ID
, B.STATUS STATUS
, B.FIRST_VALID_PERIOD_NAME FIRST_VALID_PERIOD_NAME
, B.LAST_VALID_PERIOD_NAME LAST_VALID_PERIOD_NAME
FROM GL_BUDGETS B
, GL_BUDGET_VERSIONS BV
WHERE B.BUDGET_NAME = BV.BUDGET_NAME AND B.STATUS NOT IN ('F'
, 'I'
, 'R')

Columns

Name
BUDGET_NAME
BUDGET_VERSION_ID
LEDGER_ID
STATUS
FIRST_VALID_PERIOD_NAME
LAST_VALID_PERIOD_NAME