[Home] [Help]
View: PSB_GL_BUDGETS_V
View Text
SELECT PB.ROWID
, PB.GL_BUDGET_ID
, PB.GL_BUDGET_SET_ID
, PB.GL_BUDGET_VERSION_ID
, PB.START_PERIOD
, PB.END_PERIOD
, PB.START_DATE
, PB.END_DATE
, PB.DUAL_POSTING_TYPE
, PB.LAST_UPDATE_DATE
, PB.LAST_UPDATED_BY
, PB.LAST_UPDATE_LOGIN
, PB.CREATED_BY
, PB.CREATION_DATE
, GB.BUDGET_NAME
, GB.START_DATE
, GB.END_DATE
FROM PSB_GL_BUDGETS PB
, GL_BUDGETS_V GB
WHERE PB.GL_BUDGET_VERSION_ID = GB.BUDGET_VERSION_ID
Columns
Name |
ROW_ID |
GL_BUDGET_ID |
GL_BUDGET_SET_ID |
GL_BUDGET_VERSION_ID |
START_PERIOD |
END_PERIOD |
START_DATE |
END_DATE |
DUAL_POSTING_TYPE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
GL_BUDGET_NAME |
GL_BUDGET_START_DATE |
GL_BUDGET_END_DATE |