VIEW: APPS.PSBBV_BUDGET_REVISIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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