Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSBFV_BUDGET_REVISION_ACCOUNTS |
SELECT BRL.BUDGET_REVISION_ID
, BR.JUSTIFICATION
, BRA.BUDGET_REVISION_ACCT_LINE_ID
, BRA.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GCC'
, BRA.BUDGET_GROUP_ID
, BG.SHORT_NAME
, BRA.GL_PERIOD_NAME
, BRA.GL_BUDGET_VERSION_ID
, GBV.BUDGET_NAME
, 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
, WALN.NOTE
FROM PSB_BUDGET_REVISION_ACCOUNTS BRA
, PSB_BUDGET_REVISION_LINES BRL
, PSB_BUDGET_REVISIONS BR
, GL_CODE_COMBINATIONS_KFV GCC
, PSB_WS_ACCOUNT_LINE_NOTES WALN
, GL_BUDGET_VERSIONS GBV
, PSB_BUDGET_GROUPS BG
WHERE BRA.BUDGET_REVISION_ACCT_LINE_ID = BRL.BUDGET_REVISION_ACCT_LINE_ID
AND BR.BUDGET_REVISION_ID = BRL.BUDGET_REVISION_ID
AND BRA.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND BRA.NOTE_ID = WALN.NOTE_ID(+)
AND GBV.BUDGET_VERSION_ID = BRA.GL_BUDGET_VERSION_ID
AND BG.BUDGET_GROUP_ID = BRA.BUDGET_GROUP_ID WITH READ ONLY