VIEW: APPS.FV_BE_BA_FD_HDR_V

Source

View Text - Preformatted

SELECT DISTINCT gt.event_id, hdr.doc_id, hdr.doc_number, hdr.revision_num, dtl.quarter_num, hdr.treasury_symbol_id, hdr.fund_value, hdr.budget_level_id, hdr.transaction_date, FV_BE_XLA_PKG.get_ccid('SQLGL','GL#',gl.chart_of_accounts_id,sysdate,hdr.budgeting_segments) Distribution_Account, dtl.gl_date, hdr.segment1 header_segment1, hdr.segment2 header_segment2, hdr.segment3 header_segment3, hdr.segment4 header_segment4, hdr.segment5 header_segment5, hdr.segment6 header_segment6, hdr.segment7 header_segment7, hdr.segment8 header_segment8, hdr.segment9 header_segment9, hdr.segment10 header_segment10, hdr.segment11 header_segment11, hdr.segment12 header_segment12, hdr.segment13 header_segment13, hdr.segment14 header_segment14, hdr.segment15 header_segment15, hdr.segment16 header_segment16, hdr.segment17 header_segment17, hdr.segment18 header_segment18, hdr.segment19 header_segment19, hdr.segment20 header_segment20, hdr.segment21 header_segment21, hdr.segment22 header_segment22, hdr.segment23 header_segment23, hdr.segment24 header_segment24, hdr.segment25 header_segment25, hdr.segment26 header_segment26, hdr.segment27 header_segment27, hdr.segment28 header_segment28, hdr.segment29 header_segment29, hdr.segment30 header_segment30, hdr.approval_id, hdr.source source, hdr.approved_by_user_id, hdr.old_doc_number, hdr.set_of_books_id ledger_id, gl.currency_code, hdr.parent_doc_id, hdr.attribute1 header_attribute1, hdr.attribute2 header_attribute2, hdr.attribute3 header_attribute3, hdr.attribute4 header_attribute4, hdr.attribute5 header_attribute5, hdr.attribute6 header_attribute6, hdr.attribute7 header_attribute7, hdr.attribute8 header_attribute8, hdr.attribute9 header_attribute9, hdr.attribute10 header_attribute10, hdr.attribute11 header_attribute11, hdr.attribute12 header_attribute12, hdr.attribute13 header_attribute13, hdr.attribute14 header_attribute14, hdr.attribute15 header_attribute15, hdr.attribute_category header_attr_category, hdr.bu_group_id, hdr.doc_status, sym.treasury_symbol, sym.time_frame, sym.established_fiscal_yr, sym.expiration_date, sym.cancellation_date, sym.resource_type, fpm.fund_category, fpm.bea_category FROM FV_BE_TRX_HDRS hdr, FV_BE_TRX_DTLS dtl, FV_TREASURY_SYMBOLS sym, FV_FUND_PARAMETERS fpm, XLA_EVENTS_GT gt, GL_LEDGERS gl WHERE dtl.event_id = gt.event_id AND hdr.doc_id = dtl.doc_id AND hdr.treasury_symbol_id = sym.treasury_symbol_id AND sym.treasury_symbol_id = fpm.treasury_symbol_id AND hdr.source <> 'RPR' AND hdr.set_of_books_id = gl.ledger_id AND hdr.fund_value = fpm.fund_value

View Text - HTML Formatted

SELECT DISTINCT GT.EVENT_ID
, HDR.DOC_ID
, HDR.DOC_NUMBER
, HDR.REVISION_NUM
, DTL.QUARTER_NUM
, HDR.TREASURY_SYMBOL_ID
, HDR.FUND_VALUE
, HDR.BUDGET_LEVEL_ID
, HDR.TRANSACTION_DATE
, FV_BE_XLA_PKG.GET_CCID('SQLGL'
, 'GL#'
, GL.CHART_OF_ACCOUNTS_ID
, SYSDATE
, HDR.BUDGETING_SEGMENTS) DISTRIBUTION_ACCOUNT
, DTL.GL_DATE
, HDR.SEGMENT1 HEADER_SEGMENT1
, HDR.SEGMENT2 HEADER_SEGMENT2
, HDR.SEGMENT3 HEADER_SEGMENT3
, HDR.SEGMENT4 HEADER_SEGMENT4
, HDR.SEGMENT5 HEADER_SEGMENT5
, HDR.SEGMENT6 HEADER_SEGMENT6
, HDR.SEGMENT7 HEADER_SEGMENT7
, HDR.SEGMENT8 HEADER_SEGMENT8
, HDR.SEGMENT9 HEADER_SEGMENT9
, HDR.SEGMENT10 HEADER_SEGMENT10
, HDR.SEGMENT11 HEADER_SEGMENT11
, HDR.SEGMENT12 HEADER_SEGMENT12
, HDR.SEGMENT13 HEADER_SEGMENT13
, HDR.SEGMENT14 HEADER_SEGMENT14
, HDR.SEGMENT15 HEADER_SEGMENT15
, HDR.SEGMENT16 HEADER_SEGMENT16
, HDR.SEGMENT17 HEADER_SEGMENT17
, HDR.SEGMENT18 HEADER_SEGMENT18
, HDR.SEGMENT19 HEADER_SEGMENT19
, HDR.SEGMENT20 HEADER_SEGMENT20
, HDR.SEGMENT21 HEADER_SEGMENT21
, HDR.SEGMENT22 HEADER_SEGMENT22
, HDR.SEGMENT23 HEADER_SEGMENT23
, HDR.SEGMENT24 HEADER_SEGMENT24
, HDR.SEGMENT25 HEADER_SEGMENT25
, HDR.SEGMENT26 HEADER_SEGMENT26
, HDR.SEGMENT27 HEADER_SEGMENT27
, HDR.SEGMENT28 HEADER_SEGMENT28
, HDR.SEGMENT29 HEADER_SEGMENT29
, HDR.SEGMENT30 HEADER_SEGMENT30
, HDR.APPROVAL_ID
, HDR.SOURCE SOURCE
, HDR.APPROVED_BY_USER_ID
, HDR.OLD_DOC_NUMBER
, HDR.SET_OF_BOOKS_ID LEDGER_ID
, GL.CURRENCY_CODE
, HDR.PARENT_DOC_ID
, HDR.ATTRIBUTE1 HEADER_ATTRIBUTE1
, HDR.ATTRIBUTE2 HEADER_ATTRIBUTE2
, HDR.ATTRIBUTE3 HEADER_ATTRIBUTE3
, HDR.ATTRIBUTE4 HEADER_ATTRIBUTE4
, HDR.ATTRIBUTE5 HEADER_ATTRIBUTE5
, HDR.ATTRIBUTE6 HEADER_ATTRIBUTE6
, HDR.ATTRIBUTE7 HEADER_ATTRIBUTE7
, HDR.ATTRIBUTE8 HEADER_ATTRIBUTE8
, HDR.ATTRIBUTE9 HEADER_ATTRIBUTE9
, HDR.ATTRIBUTE10 HEADER_ATTRIBUTE10
, HDR.ATTRIBUTE11 HEADER_ATTRIBUTE11
, HDR.ATTRIBUTE12 HEADER_ATTRIBUTE12
, HDR.ATTRIBUTE13 HEADER_ATTRIBUTE13
, HDR.ATTRIBUTE14 HEADER_ATTRIBUTE14
, HDR.ATTRIBUTE15 HEADER_ATTRIBUTE15
, HDR.ATTRIBUTE_CATEGORY HEADER_ATTR_CATEGORY
, HDR.BU_GROUP_ID
, HDR.DOC_STATUS
, SYM.TREASURY_SYMBOL
, SYM.TIME_FRAME
, SYM.ESTABLISHED_FISCAL_YR
, SYM.EXPIRATION_DATE
, SYM.CANCELLATION_DATE
, SYM.RESOURCE_TYPE
, FPM.FUND_CATEGORY
, FPM.BEA_CATEGORY
FROM FV_BE_TRX_HDRS HDR
, FV_BE_TRX_DTLS DTL
, FV_TREASURY_SYMBOLS SYM
, FV_FUND_PARAMETERS FPM
, XLA_EVENTS_GT GT
, GL_LEDGERS GL
WHERE DTL.EVENT_ID = GT.EVENT_ID
AND HDR.DOC_ID = DTL.DOC_ID
AND HDR.TREASURY_SYMBOL_ID = SYM.TREASURY_SYMBOL_ID
AND SYM.TREASURY_SYMBOL_ID = FPM.TREASURY_SYMBOL_ID
AND HDR.SOURCE <> 'RPR'
AND HDR.SET_OF_BOOKS_ID = GL.LEDGER_ID
AND HDR.FUND_VALUE = FPM.FUND_VALUE