[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 |