[Home] [Help]
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
Name |
DOC_ID |
DOC_NUMBER |
FUND_VALUE |
TRANSACTION_DATE |
BE_SOURCE |
TREASURY_SYMBOL |
BUDGET_LEVEL |