FND Design Data [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: ViewAPPS.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