View: PSBBV_BUDGET_REVISIONS

Product:	PSB - Public Sector Budgeting
Description:
Implementation/DBA Data:	APPS.PSBBV_BUDGET_REVISIONS

View Text

SELECT BR.BUDGET_REVISION_ID
, BR.JUSTIFICATION
, BR.BUDGET_GROUP_ID
, BR.BALANCE_TYPE
, BR.GL_BUDGET_SET_ID
, BR.FROM_GL_PERIOD_NAME
, BR.TO_GL_PERIOD_NAME
, BR.EFFECTIVE_START_DATE
, BR.EFFECTIVE_END_DATE
, '_LA:BUDGET_REVISION_TYPE:FND_LOOKUPS:PSB_REVISION_SOURCE_TYPE:MEANING'
, '_LA:TRANSACTION_TYPE:FND_LOOKUPS:PSB_REVISION_TRANSACTION_TYPES:MEANING'
, BR.PERMANENT_REVISION
, BR.REVISE_BY_POSITION
, BR.REQUESTOR
, BR.PARAMETER_SET_ID
, BR.CONSTRAINT_SET_ID
, BR.SUBMISSION_DATE
, BR.SUBMISSION_STATUS
, BR.APPROVAL_ORIG_SYSTEM
, BR.APPROVAL_OVERRIDE_BY
, BR.FREEZE_FLAG
, BR.BASE_LINE_REVISION
, BR.GLOBAL_BUDGET_REVISION
, BR.GLOBAL_BUDGET_REVISION_ID
FROM PSB_BUDGET_REVISIONS BR
WHERE BR.BUDGET_GROUP_ID IN ( SELECT BUDGET_GROUP_ID
FROM PSB_BUDGET_GROUPS
WHERE BUDGET_GROUP_TYPE = 'R'
AND SYSDATE BETWEEN EFFECTIVE_START_DATE
AND NVL(EFFECTIVE_END_DATE
, SYSDATE) START WITH BUDGET_GROUP_ID IN (SELECT BUDGET_GROUP_ID
FROM PSB_BUDGET_GROUP_RESP
WHERE RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID) CONNECT BY PRIOR BUDGET_GROUP_ID = PARENT_BUDGET_GROUP_ID ) WITH READ ONLY

Columns