[Home] [Help]
View: 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 |