FND Design Data [Home] [Help]

View: GL_BUD_PERIOD_RANGES_V

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

SELECT P.ROWID ROW_ID
, P.BUDGET_VERSION_ID BUDGET_VERSION_ID
, V.BUDGET_NAME BUDGET_NAME
, P.PERIOD_YEAR PERIOD_YEAR
, P.START_PERIOD_NAME START_PERIOD_NAME
, P.START_PERIOD_NUM START_PERIOD_NUM
, P.END_PERIOD_NAME END_PERIOD_NAME
, P.END_PERIOD_NUM END_PERIOD_NUM
, P.OPEN_FLAG OPEN_FLAG
, P.LAST_UPDATE_DATE LAST_UPDATE_DATE
, P.LAST_UPDATED_BY LAST_UPDATED_BY
FROM GL_BUDGET_VERSIONS V
, GL_BUDGET_PERIOD_RANGES P
WHERE V.BUDGET_VERSION_ID = P.BUDGET_VERSION_ID

Columns

Name
ROW_ID
BUDGET_VERSION_ID
BUDGET_NAME
PERIOD_YEAR
START_PERIOD_NAME
START_PERIOD_NUM
END_PERIOD_NAME
END_PERIOD_NUM
OPEN_FLAG
LAST_UPDATE_DATE
LAST_UPDATED_BY