SELECT BRL.BUDGET_REVISION_ID, BRP.BUDGET_REVISION_POS_LINE_ID, BRP.POSITION_ID, BRP.BUDGET_GROUP_ID, BRP.EFFECTIVE_START_DATE, BRP.EFFECTIVE_END_DATE, BRP.REVISION_TYPE, BRP.REVISION_VALUE_TYPE, BRP.REVISION_VALUE, BRP.NOTE_ID from PSB_BUDGET_REVISION_POSITIONS BRP, PSB_BUDGET_REVISION_POS_LINES BRL WHERE BRP.BUDGET_REVISION_POS_LINE_ID = BRL.BUDGET_REVISION_POS_LINE_ID with read only
SELECT BRL.BUDGET_REVISION_ID
, BRP.BUDGET_REVISION_POS_LINE_ID
, BRP.POSITION_ID
, BRP.BUDGET_GROUP_ID
, BRP.EFFECTIVE_START_DATE
, BRP.EFFECTIVE_END_DATE
, BRP.REVISION_TYPE
, BRP.REVISION_VALUE_TYPE
, BRP.REVISION_VALUE
, BRP.NOTE_ID
FROM PSB_BUDGET_REVISION_POSITIONS BRP
, PSB_BUDGET_REVISION_POS_LINES BRL
WHERE BRP.BUDGET_REVISION_POS_LINE_ID = BRL.BUDGET_REVISION_POS_LINE_ID WITH READ ONLY
|
|
|