[Home] [Help]
| Product: | PSB - Public Sector Budgeting (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
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