Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSBFV_BUDGET_REVISION_POSITION |
SELECT BRL.BUDGET_REVISION_ID
, BR.JUSTIFICATION
, BRP.BUDGET_REVISION_POS_LINE_ID
, BRP.POSITION_ID
, '_KF:PSB:BPS:PKFV:_CO'
, BRP.BUDGET_GROUP_ID
, BG.SHORT_NAME
, BRP.EFFECTIVE_START_DATE
, BRP.EFFECTIVE_END_DATE
, BRP.REVISION_TYPE
, BRP.REVISION_VALUE_TYPE
, BRP.REVISION_VALUE
, BRP.NOTE_ID
, WALN.NOTE
FROM PSB_BUDGET_REVISION_POSITIONS BRP
, PSB_BUDGET_REVISION_POS_LINES BRL
, PSB_POSITIONS POS
, PSB_BUDGET_REVISIONS BR
, PSB_POSITION_DEFINITIONS_KFV PKFV
, PSB_WS_ACCOUNT_LINE_NOTES WALN
, PSB_BUDGET_GROUPS BG
WHERE BRP.BUDGET_REVISION_POS_LINE_ID = BRL.BUDGET_REVISION_POS_LINE_ID
AND BR.BUDGET_REVISION_ID = BRL.BUDGET_REVISION_ID
AND BRP.POSITION_ID = POS.POSITION_ID
AND POS.POSITION_DEFINITION_ID = PKFV.POSITION_DEFINITION_ID
AND BRP.NOTE_ID = WALN.NOTE_ID(+)
AND BG.BUDGET_GROUP_ID = BRP.BUDGET_GROUP_ID WITH READ ONLY