Product: | PSB - Public Sector Budgeting |
---|---|
Description: | PSBBV_BUDGET_REVISION_ACCOUNTS provides informationabout budget revision account lines. |
Implementation/DBA Data: | APPS.PSBBV_BUDGET_REVISION_ACCOUNTS |
SELECT BRL.BUDGET_REVISION_ID
, BRA.BUDGET_REVISION_ACCT_LINE_ID
, BRA.CODE_COMBINATION_ID
, BRA.BUDGET_GROUP_ID
, BRA.GL_PERIOD_NAME
, BRA.GL_BUDGET_VERSION_ID
, BRA.CURRENCY_CODE
, '_LA:BRA.ACCOUNT_TYPE:FND_LOOKUPS:ACCOUNT_TYPE:MEANING'
, BRA.BUDGET_BALANCE
, BRA.ACTUAL_BALANCE
, BRA.ENCUMBRANCE_BALANCE
, BRA.REVISION_TYPE
, BRA.REVISION_VALUE_TYPE
, BRA.REVISION_AMOUNT
, BRA.FUNDS_CONTROL_STATUS_CODE
, BRA.FUNDS_CONTROL_RESULTS_CODE
, BRA.FUNDS_CONTROL_TIMESTAMP
, BRA.FREEZE_FLAG
, BRA.NOTE_ID
FROM PSB_BUDGET_REVISION_ACCOUNTS BRA
, PSB_BUDGET_REVISION_LINES BRL
WHERE BRA.BUDGET_REVISION_ACCT_LINE_ID = BRL.BUDGET_REVISION_ACCT_LINE_ID WITH READ ONLY