Product: | FV - Federal Financials |
---|---|
Description: | The main purpose of this view is used as RPR Transaction Extract lines for SLA to identify the sources. |
Implementation/DBA Data: | APPS.FV_BE_RPR_DTL_V |
SELECT GT.EVENT_ID
, RPR.TRANSACTION_ID LINE_NUMBER
, RPR.FUND_VALUE_FROM
, FND_FLEX_EXT.GET_CCID('SQLGL'
, 'GL#'
, GL.CHART_OF_ACCOUNTS_ID
, SYSDATE
, RPR.DISTRIBUTION_FROM) DISTRIBUTION_FROM_ACCOUNT
, RPR.FUND_VALUE_TO
, FV_BE_XLA_PKG.GET_CCID('SQLGL'
, 'GL#'
, GL.CHART_OF_ACCOUNTS_ID
, SYSDATE
, RPR.DISTRIBUTION_TO) DISTRIBUTION_TO_ACCOUNT
, RPR.TRANSACTION_TYPE_ID
, RPR.SUB_TYPE
, RPR.AMOUNT ACCOUNTED_AMOUNT
, RPR.SEGMENT1_FROM
, RPR.SEGMENT2_FROM
, RPR.SEGMENT3_FROM
, RPR.SEGMENT4_FROM
, RPR.SEGMENT5_FROM
, RPR.SEGMENT6_FROM
, RPR.SEGMENT7_FROM
, RPR.SEGMENT8_FROM
, RPR.SEGMENT9_FROM
, RPR.SEGMENT10_FROM
, RPR.SEGMENT11_FROM
, RPR.SEGMENT12_FROM
, RPR.SEGMENT13_FROM
, RPR.SEGMENT14_FROM
, RPR.SEGMENT15_FROM
, RPR.SEGMENT16_FROM
, RPR.SEGMENT17_FROM
, RPR.SEGMENT18_FROM
, RPR.SEGMENT19_FROM
, RPR.SEGMENT20_FROM
, RPR.SEGMENT21_FROM
, RPR.SEGMENT22_FROM
, RPR.SEGMENT23_FROM
, RPR.SEGMENT24_FROM
, RPR.SEGMENT25_FROM
, RPR.SEGMENT26_FROM
, RPR.SEGMENT27_FROM
, RPR.SEGMENT28_FROM
, RPR.SEGMENT29_FROM
, RPR.SEGMENT30_FROM
, RPR.SEGMENT1 SEGMENT1_TO
, RPR.SEGMENT2 SEGMENT2_TO
, RPR.SEGMENT3 SEGMENT3_TO
, RPR.SEGMENT4 SEGMENT4_TO
, RPR.SEGMENT5 SEGMENT5_TO
, RPR.SEGMENT6 SEGMENT6_TO
, RPR.SEGMENT7 SEGMENT7_TO
, RPR.SEGMENT8 SEGMENT8_TO
, RPR.SEGMENT9 SEGMENT9_TO
, RPR.SEGMENT10 SEGMENT10_TO
, RPR.SEGMENT11 SEGMENT11_TO
, RPR.SEGMENT12 SEGMENT12_TO
, RPR.SEGMENT13 SEGMENT13_TO
, RPR.SEGMENT14 SEGMENT14_TO
, RPR.SEGMENT15 SEGMENT15_TO
, RPR.SEGMENT16 SEGMENT16_TO
, RPR.SEGMENT17 SEGMENT17_TO
, RPR.SEGMENT18 SEGMENT18_TO
, RPR.SEGMENT19 SEGMENT19_TO
, RPR.SEGMENT20 SEGMENT20_TO
, RPR.SEGMENT21 SEGMENT21_TO
, RPR.SEGMENT22 SEGMENT22_TO
, RPR.SEGMENT23 SEGMENT23_TO
, RPR.SEGMENT24 SEGMENT24_TO
, RPR.SEGMENT25 SEGMENT25_TO
, RPR.SEGMENT26 SEGMENT26_TO
, RPR.SEGMENT27 SEGMENT27_TO
, RPR.SEGMENT28 SEGMENT28_TO
, RPR.SEGMENT29 SEGMENT29_TO
, RPR.SEGMENT30 SEGMENT30_TO
, RPR.ATTRIBUTE1
, RPR.ATTRIBUTE2
, RPR.ATTRIBUTE3
, RPR.ATTRIBUTE4
, RPR.ATTRIBUTE5
, RPR.ATTRIBUTE6
, RPR.ATTRIBUTE7
, RPR.ATTRIBUTE8
, RPR.ATTRIBUTE9
, RPR.ATTRIBUTE10
, RPR.ATTRIBUTE11
, RPR.ATTRIBUTE12
, RPR.ATTRIBUTE13
, RPR.ATTRIBUTE14
, RPR.ATTRIBUTE15
, RPR.ATTRIBUTE_CATEGORY
, TT.APPRN_TRANSACTION_TYPE TRANSACTION_TYPE
, ACC.DR_ACCOUNT_SEGMENT_VALUE
, ACC.CR_ACCOUNT_SEGMENT_VALUE
FROM XLA_EVENTS_GT GT
, FV_BE_RPR_TRANSACTIONS RPR
, FV_BE_TRANSACTION_TYPES TT
, FV_BE_TRX_SUB_TYPES TST
, FV_BE_ACCOUNT_PAIRS ACC
, GL_LEDGERS GL
WHERE GT.EVENT_ID = RPR.EVENT_ID
AND RPR.TRANSACTION_TYPE_ID = TT.BE_TT_ID
AND TT.BE_TT_ID = ACC.BE_TT_ID
AND TT.SET_OF_BOOKS_ID = ACC.LEDGER_ID
AND NVL(RPR.SUB_TYPE
, -99) = NVL(TST.SUB_TYPE
, -99)
AND NVL(TST.BE_TT_ID
, -99) = NVL(ACC.BE_TT_ID
, -99)
AND NVL(TST.LEDGER_ID
, -99) = NVL (ACC.LEDGER_ID
, -99)
AND RPR.SET_OF_BOOKS_ID = GL.LEDGER_ID