[Home] [Help]
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
Name |
EVENT_ID |
BUDGET_LEVEL_ID |
GL_DATE |
TRANSACTION_ID |
DOC_NUMBER |
TRANSACTION_STATUS |
RPR_APPROVED_BY_USER_ID |
SOURCE |
LEDGER_ID |
CURRENCY_CODE |