VIEW: APPS.FV_BE_RPR_DTL_V

Source

View Text - Preformatted

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.sub_type_flag = 'Y' and tst.be_tt_id = tt.be_tt_id and rpr.sub_type = tst.sub_type AND acc.sub_type=tst.sub_type AND rpr.set_of_books_id = gl.ledger_id and acc.ledger_id = gl.ledger_id UNION 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.sub_type_flag = 'N' AND tt.be_tt_id = acc.be_tt_id AND acc.sub_type is null AND rpr.set_of_books_id = gl.ledger_id and acc.ledger_id = gl.ledger_id

View Text - HTML Formatted

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.SUB_TYPE_FLAG = 'Y'
AND TST.BE_TT_ID = TT.BE_TT_ID
AND RPR.SUB_TYPE = TST.SUB_TYPE
AND ACC.SUB_TYPE=TST.SUB_TYPE
AND RPR.SET_OF_BOOKS_ID = GL.LEDGER_ID
AND ACC.LEDGER_ID = GL.LEDGER_ID UNION 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.SUB_TYPE_FLAG = 'N'
AND TT.BE_TT_ID = ACC.BE_TT_ID
AND ACC.SUB_TYPE IS NULL
AND RPR.SET_OF_BOOKS_ID = GL.LEDGER_ID
AND ACC.LEDGER_ID = GL.LEDGER_ID