View: FV_BE_XLA_V

Product:	FV - Federal Financials
Description:	View is used for reporting BE transactions in SLA
Implementation/DBA Data:	APPS.FV_BE_XLA_V

View Text

SELECT HDR.DOC_ID
, HDR.DOC_NUMBER
, HDR.FUND_VALUE
, HDR.TRANSACTION_DATE
, HDR.SOURCE BE_SOURCE
, TRE.TREASURY_SYMBOL
, BUD.DESCRIPTION BUDGET_LEVEL
FROM FV_BE_TRX_HDRS HDR
, FV_TREASURY_SYMBOLS TRE
, FV_BUDGET_LEVELS BUD
WHERE HDR.TREASURY_SYMBOL_ID = TRE.TREASURY_SYMBOL_ID
AND HDR.BUDGET_LEVEL_ID = BUD.BUDGET_LEVEL_ID
AND HDR.SET_OF_BOOKS_ID = BUD.SET_OF_BOOKS_ID

Columns