View: FV_BE_RPR_HDR_V

Product:	FV - Federal Financials
Description:	View is used as RPR Transaction Extract headers for SLA to identify the source
Implementation/DBA Data:	APPS.FV_BE_RPR_HDR_V

View Text

SELECT GT.EVENT_ID
, RPR.BUDGET_LEVEL_ID
, RPR.GL_DATE
, RPR.TRANSACTION_ID
, RPR.DOC_NUMBER
, RPR.TRANSACTION_STATUS
, RPR.APPROVED_BY_USER_ID RPR_APPROVED_BY_USER_ID
, 'RPR' SOURCE
, RPR.SET_OF_BOOKS_ID LEDGER_ID
, GL.CURRENCY_CODE
FROM XLA_EVENTS_GT GT
, FV_BE_RPR_TRANSACTIONS RPR
, GL_LEDGERS GL
WHERE GT.EVENT_ID = RPR.EVENT_ID
AND RPR.SET_OF_BOOKS_ID = GL.LEDGER_ID

Columns