[Home] [Help]
View: FV_BE_RPR_XLA_V
Product: | FV - Federal Financials |
Description: | View is used for reporting the Reprogram BE transactions in SLA |
Implementation/DBA Data: |
APPS.FV_BE_RPR_XLA_V
|
View Text
SELECT HDR.TRANSACTION_ID
, HDR.DOC_NUMBER
, HDR.FUND_VALUE_FROM
, HDR.FUND_VALUE_TO
, HDR.GL_DATE TRANSACTION_DATE
, 'REPROGRAM' RPR_SOURCE
, BUD.DESCRIPTION BUDGET_LEVEL
FROM FV_BE_RPR_TRANSACTIONS HDR
, FV_BUDGET_LEVELS BUD
WHERE HDR.BUDGET_LEVEL_ID = BUD.BUDGET_LEVEL_ID
AND HDR.SET_OF_BOOKS_ID = BUD.SET_OF_BOOKS_ID
Columns
Name |
TRANSACTION_ID |
DOC_NUMBER |
FUND_VALUE_FROM |
FUND_VALUE_TO |
TRANSACTION_DATE |
RPR_SOURCE |
BUDGET_LEVEL |