VIEW: APPS.PSBFV_BUDGET_REVISION_ACCOUNTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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