VIEW: APPS.FV_BE_BA_FD_DTL_V

Source

View Text - Preformatted

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 , dtl.public_law_code, dtl.advance_type, dtl.dept_id, dtl.main_account, dtl.transfer_description 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.sub_type_flag ='Y' AND acc.sub_type=tst.sub_type AND tst.sub_type =dtl.sub_type AND hdr.set_of_books_id = gl.ledger_id AND acc.be_tt_id = tt.be_tt_id AND tst.be_tt_id = acc.be_tt_id AND acc.ledger_id = hdr.set_of_books_id AND tst.ledger_id = hdr.set_of_books_id AND tt.set_of_books_id = hdr.set_of_books_id UNION 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 , dtl.public_law_code, dtl.advance_type, dtl.dept_id, dtl.main_account, dtl.transfer_description FROM XLA_EVENTS_GT gt, FV_BE_TRX_HDRS hdr, FV_BE_TRX_DTLS dtl, FV_BE_TRANSACTION_TYPES tt, 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.sub_type_flag ='N' AND tt.be_tt_id = acc.be_tt_id AND acc.sub_type is null AND hdr.set_of_books_id = gl.ledger_id AND acc.ledger_id = hdr.set_of_books_id AND acc.be_tt_id = tt.be_tt_id

View Text - HTML Formatted

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
, DTL.PUBLIC_LAW_CODE
, DTL.ADVANCE_TYPE
, DTL.DEPT_ID
, DTL.MAIN_ACCOUNT
, DTL.TRANSFER_DESCRIPTION
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.SUB_TYPE_FLAG ='Y'
AND ACC.SUB_TYPE=TST.SUB_TYPE
AND TST.SUB_TYPE =DTL.SUB_TYPE
AND HDR.SET_OF_BOOKS_ID = GL.LEDGER_ID
AND ACC.BE_TT_ID = TT.BE_TT_ID
AND TST.BE_TT_ID = ACC.BE_TT_ID
AND ACC.LEDGER_ID = HDR.SET_OF_BOOKS_ID
AND TST.LEDGER_ID = HDR.SET_OF_BOOKS_ID
AND TT.SET_OF_BOOKS_ID = HDR.SET_OF_BOOKS_ID UNION 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
, DTL.PUBLIC_LAW_CODE
, DTL.ADVANCE_TYPE
, DTL.DEPT_ID
, DTL.MAIN_ACCOUNT
, DTL.TRANSFER_DESCRIPTION
FROM XLA_EVENTS_GT GT
, FV_BE_TRX_HDRS HDR
, FV_BE_TRX_DTLS DTL
, FV_BE_TRANSACTION_TYPES TT
, 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.SUB_TYPE_FLAG ='N'
AND TT.BE_TT_ID = ACC.BE_TT_ID
AND ACC.SUB_TYPE IS NULL
AND HDR.SET_OF_BOOKS_ID = GL.LEDGER_ID
AND ACC.LEDGER_ID = HDR.SET_OF_BOOKS_ID
AND ACC.BE_TT_ID = TT.BE_TT_ID