Product: | FV - Federal Financials |
---|---|
Description: | The main purpose of this view is used as Transaction Extract lines for SLA to identify the sources |
Implementation/DBA Data: | APPS.FV_BE_BA_FD_DTL_V |
SELECT GT.EVENT_ID
, DTL.TRANSACTION_ID LINE_NUMBER
, DTL.TRANSACTION_TYPE_ID
, DTL.SUB_TYPE
, FV_BE_XLA_PKG.GET_CCID('SQLGL'
, 'GL#'
, GL.CHART_OF_ACCOUNTS_ID
, SYSDATE
, DTL.BUDGETING_SEGMENTS) FUND_DISTRIBUTION_ACCOUNT
, DTL.SEGMENT1 LINE_SEGMENT1
, DTL.SEGMENT2 LINE_SEGMENT2
, DTL.SEGMENT3 LINE_SEGMENT3
, DTL.SEGMENT4 LINE_SEGMENT4
, DTL.SEGMENT5 LINE_SEGMENT5
, DTL.SEGMENT6 LINE_SEGMENT6
, DTL.SEGMENT7 LINE_SEGMENT7
, DTL.SEGMENT8 LINE_SEGMENT8
, DTL.SEGMENT9 LINE_SEGMENT9
, DTL.SEGMENT10 LINE_SEGMENT10
, DTL.SEGMENT11 LINE_SEGMENT11
, DTL.SEGMENT12 LINE_SEGMENT12
, DTL.SEGMENT13 LINE_SEGMENT13
, DTL.SEGMENT14 LINE_SEGMENT14
, DTL.SEGMENT15 LINE_SEGMENT15
, DTL.SEGMENT16 LINE_SEGMENT16
, DTL.SEGMENT17 LINE_SEGMENT17
, DTL.SEGMENT18 LINE_SEGMENT18
, DTL.SEGMENT19 LINE_SEGMENT19
, DTL.SEGMENT20 LINE_SEGMENT20
, DTL.SEGMENT21 LINE_SEGMENT21
, DTL.SEGMENT22 LINE_SEGMENT22
, DTL.SEGMENT23 LINE_SEGMENT23
, DTL.SEGMENT24 LINE_SEGMENT24
, DTL.SEGMENT25 LINE_SEGMENT25
, DTL.SEGMENT26 LINE_SEGMENT26
, DTL.SEGMENT27 LINE_SEGMENT27
, DTL.SEGMENT28 LINE_SEGMENT28
, DTL.SEGMENT29 LINE_SEGMENT29
, DTL.SEGMENT30 LINE_SEGMENT30
, DTL.INCREASE_DECREASE_FLAG
, DTL.AMOUNT ACCOUNTED_AMOUNT
, DTL.ATTRIBUTE1 LINE_ATTRIBUTE1
, DTL.ATTRIBUTE2 LINE_ATTRIBUTE2
, DTL.ATTRIBUTE3 LINE_ATTRIBUTE3
, DTL.ATTRIBUTE4 LINE_ATTRIBUTE4
, DTL.ATTRIBUTE5 LINE_ATTRIBUTE5
, DTL.ATTRIBUTE6 LINE_ATTRIBUTE6
, DTL.ATTRIBUTE7 LINE_ATTRIBUTE7
, DTL.ATTRIBUTE8 LINE_ATTRIBUTE8
, DTL.ATTRIBUTE9 LINE_ATTRIBUTE9
, DTL.ATTRIBUTE10 LINE_ATTRIBUTE10
, DTL.ATTRIBUTE11 LINE_ATTRIBUTE11
, DTL.ATTRIBUTE12 LINE_ATTRIBUTE12
, DTL.ATTRIBUTE13 LINE_ATTRIBUTE13
, DTL.ATTRIBUTE14 LINE_ATTRIBUTE14
, DTL.ATTRIBUTE15 LINE_ATTRIBUTE15
, DTL.ATTRIBUTE_CATEGORY LINE_ATTR_CATEGORY
, DTL.CORRECTED_FLAG
, DTL.GROUP_ID
, TT.APPRN_TRANSACTION_TYPE TRANSACTION_TYPE
, ACC.DR_ACCOUNT_SEGMENT_VALUE
, ACC.CR_ACCOUNT_SEGMENT_VALUE
, DTL.APPROVAL_DATE
FROM XLA_EVENTS_GT GT
, FV_BE_TRX_HDRS HDR
, FV_BE_TRX_DTLS DTL
, FV_BE_TRANSACTION_TYPES TT
, FV_BE_TRX_SUB_TYPES TST
, FV_BE_ACCOUNT_PAIRS ACC
, GL_LEDGERS GL
WHERE GT.EVENT_ID = DTL.EVENT_ID
AND HDR.DOC_ID = DTL.DOC_ID
AND DTL.TRANSACTION_TYPE_ID = TT.BE_TT_ID
AND TT.SET_OF_BOOKS_ID = ACC.LEDGER_ID
AND TT.BE_TT_ID = ACC.BE_TT_ID
AND NVL(DTL.SUB_TYPE
, -99) = NVL(TST.SUB_TYPE
, -99)
AND NVL(TST.SUB_TYPE
, -99) = NVL(ACC.SUB_TYPE
, -99)
AND HDR.SET_OF_BOOKS_ID = GL.LEDGER_ID