VIEW: APPS.PSBFV_BUDGET_REVISION_POSITION

Source

View Text - Preformatted

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

View Text - HTML Formatted

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