[Home] [Help]
| Product: | PSB - Public Sector Budgeting (Obsolete) |
|---|---|
| Description: | PSB_BUDGET_REVISIONS_V is a view on PSB_BUDGET_REVISIONS and provides information about budget revisions. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT BR.ROWID
, BR.BUDGET_REVISION_ID
, BR.JUSTIFICATION
, BR.BUDGET_GROUP_ID
, BG.SHORT_NAME
, BR.GL_BUDGET_SET_ID
, BR.HR_BUDGET_ID
, BR.CONSTRAINT_SET_ID
, BR.BUDGET_REVISION_TYPE
, BR.FROM_GL_PERIOD_NAME
, BR.TO_GL_PERIOD_NAME
, BR.EFFECTIVE_START_DATE
, BR.EFFECTIVE_END_DATE
, BR.TRANSACTION_TYPE
, BR.CURRENCY_CODE
, BR.PERMANENT_REVISION
, BR.REVISE_BY_POSITION
, BR.BALANCE_TYPE
, BR.PARAMETER_SET_ID
, PES.NAME
, BR.REQUESTOR
, FU.USER_NAME
, BR.SUBMISSION_DATE
, BR.SUBMISSION_STATUS
, BR.FREEZE_FLAG
, BR.APPROVAL_ORIG_SYSTEM
, BR.APPROVAL_OVERRIDE_BY
, BR.BASE_LINE_REVISION
, BR.GLOBAL_BUDGET_REVISION
, BR.GLOBAL_BUDGET_REVISION_ID
, BR.REQUEST_ID
, BR.LAST_UPDATE_DATE
, BR.LAST_UPDATED_BY
, BR.LAST_UPDATE_LOGIN
, BR.CREATED_BY
, BR.CREATION_DATE
, BR.ATTRIBUTE1
, BR.ATTRIBUTE2
, BR.ATTRIBUTE3
, BR.ATTRIBUTE4
, BR.ATTRIBUTE5
, BR.ATTRIBUTE6
, BR.ATTRIBUTE7
, BR.ATTRIBUTE8
, BR.ATTRIBUTE9
, BR.ATTRIBUTE10
, BR.ATTRIBUTE11
, BR.ATTRIBUTE12
, BR.ATTRIBUTE13
, BR.ATTRIBUTE14
, BR.ATTRIBUTE15
, BR.ATTRIBUTE16
, BR.ATTRIBUTE17
, BR.ATTRIBUTE18
, BR.ATTRIBUTE19
, BR.ATTRIBUTE20
, BR.ATTRIBUTE21
, BR.ATTRIBUTE22
, BR.ATTRIBUTE23
, BR.ATTRIBUTE24
, BR.ATTRIBUTE25
, BR.ATTRIBUTE26
, BR.ATTRIBUTE27
, BR.ATTRIBUTE28
, BR.ATTRIBUTE29
, BR.ATTRIBUTE30
, BR.CONTEXT
FROM PSB_BUDGET_REVISIONS BR
, PSB_BUDGET_GROUPS BG
, PSB_ENTITY_SET PES
, FND_USER FU
WHERE BR.BUDGET_GROUP_ID = BG.BUDGET_GROUP_ID
AND FU.USER_ID = BR.REQUESTOR
AND BR.PARAMETER_SET_ID = PES.ENTITY_SET_ID(+)