VIEW: APPS.PSB_BUDGET_REVISIONS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)