VIEW: APPS.PSBFV_BUDGET_REVISIONS

Source

View Text - Preformatted

SELECT BR.BUDGET_REVISION_ID ,BR.JUSTIFICATION ,BR.BUDGET_GROUP_ID ,BG.SHORT_NAME ,BR.BALANCE_TYPE ,BR.GL_BUDGET_SET_ID ,GLS.GL_BUDGET_SET_NAME ,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 ,PESP.NAME ,BR.CONSTRAINT_SET_ID ,PESC.NAME ,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 ,'_DF:PSB:PSB_BUDGET_REVISIONS:br' FROM PSB_BUDGET_REVISIONS BR, PSB_BUDGET_GROUPS BG, PSB_ENTITY_SET PESC, PSB_ENTITY_SET PESP, PSB_GL_BUDGET_SETS GLS WHERE BR.budget_group_id = BG.budget_group_id and 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 ) AND BR.PARAMETER_SET_ID = PESP.ENTITY_SET_ID(+) AND BR.CONSTRAINT_SET_ID = PESC.ENTITY_SET_ID(+) AND BR.GL_BUDGET_SET_ID = GLS.GL_BUDGET_SET_ID (+) with read only

View Text - HTML Formatted

SELECT BR.BUDGET_REVISION_ID
, BR.JUSTIFICATION
, BR.BUDGET_GROUP_ID
, BG.SHORT_NAME
, BR.BALANCE_TYPE
, BR.GL_BUDGET_SET_ID
, GLS.GL_BUDGET_SET_NAME
, 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
, PESP.NAME
, BR.CONSTRAINT_SET_ID
, PESC.NAME
, 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
, '_DF:PSB:PSB_BUDGET_REVISIONS:BR'
FROM PSB_BUDGET_REVISIONS BR
, PSB_BUDGET_GROUPS BG
, PSB_ENTITY_SET PESC
, PSB_ENTITY_SET PESP
, PSB_GL_BUDGET_SETS GLS
WHERE BR.BUDGET_GROUP_ID = BG.BUDGET_GROUP_ID
AND 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 )
AND BR.PARAMETER_SET_ID = PESP.ENTITY_SET_ID(+)
AND BR.CONSTRAINT_SET_ID = PESC.ENTITY_SET_ID(+)
AND BR.GL_BUDGET_SET_ID = GLS.GL_BUDGET_SET_ID (+) WITH READ ONLY