VIEW: APPS.FV_BE_GL_V

Source

View Text - Preformatted

SELECT fbh.doc_number CHARGEBACK_NUMBER, fbd.revision_num PO_LINE_NUM, fbl.description APPLIED_TO_TRX_HDR_CURRENCY, fbh.transaction_date TRX_DATE, DECODE( fbd.source,NULL,fbh.source,fbd.source) RCV_RECEIPT_NUM, SUBSTR( fts.treasury_symbol,1,30) ACCOUNTING_COMPLETE, jel.accounted_dr ACCOUNTED_DR, jel.accounted_cr ACCOUNTED_CR, jel.entered_dr ENTERED_DR, jel.entered_cr ENTERED_CR, fbtt.apprn_transaction_type TRX_LINE_TYPE_NAME, fbd.increase_decrease_flag PO_ORDER_NUMBER, fbh.doc_id RCV_SHIPMENT_HEADER_ID, fbh.set_of_books_id SET_OF_BOOKS_ID, jel.je_header_id JE_HEADER_ID, jel.je_line_num JE_LINE_NUM, jel.code_combination_id CODE_COMBINATION_ID, jeh.currency_code CURRENCY_CODE, 8901 APPLICATION_ID FROM fv_be_trx_dtls fbd, fv_be_trx_hdrs fbh, fv_budget_levels fbl, fv_be_transaction_types fbtt, fv_treasury_symbols fts, gl_je_lines jel, gl_je_headers jeh WHERE fbh.doc_id = fbd.doc_id AND fbh.budget_level_id = fbl.budget_level_id AND fbh.set_of_books_id = fbl.set_of_books_id AND fbd.transaction_type_id = fbtt.be_tt_id AND fbd.set_of_books_id = fbtt.set_of_books_id AND fbh.treasury_symbol_id = fts.treasury_symbol_id AND fbh.set_of_books_id = fts.set_of_books_id AND to_char(fbd.transaction_id) = jel.reference_1 AND jeh.je_source = 'Budgetary Transaction' AND jeh.je_header_id = jel.je_header_id AND jeh.ledger_id = jel.ledger_id AND fbd.set_of_books_id = jel.ledger_id

View Text - HTML Formatted

SELECT FBH.DOC_NUMBER CHARGEBACK_NUMBER
, FBD.REVISION_NUM PO_LINE_NUM
, FBL.DESCRIPTION APPLIED_TO_TRX_HDR_CURRENCY
, FBH.TRANSACTION_DATE TRX_DATE
, DECODE( FBD.SOURCE
, NULL
, FBH.SOURCE
, FBD.SOURCE) RCV_RECEIPT_NUM
, SUBSTR( FTS.TREASURY_SYMBOL
, 1
, 30) ACCOUNTING_COMPLETE
, JEL.ACCOUNTED_DR ACCOUNTED_DR
, JEL.ACCOUNTED_CR ACCOUNTED_CR
, JEL.ENTERED_DR ENTERED_DR
, JEL.ENTERED_CR ENTERED_CR
, FBTT.APPRN_TRANSACTION_TYPE TRX_LINE_TYPE_NAME
, FBD.INCREASE_DECREASE_FLAG PO_ORDER_NUMBER
, FBH.DOC_ID RCV_SHIPMENT_HEADER_ID
, FBH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, JEL.JE_HEADER_ID JE_HEADER_ID
, JEL.JE_LINE_NUM JE_LINE_NUM
, JEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, JEH.CURRENCY_CODE CURRENCY_CODE
, 8901 APPLICATION_ID
FROM FV_BE_TRX_DTLS FBD
, FV_BE_TRX_HDRS FBH
, FV_BUDGET_LEVELS FBL
, FV_BE_TRANSACTION_TYPES FBTT
, FV_TREASURY_SYMBOLS FTS
, GL_JE_LINES JEL
, GL_JE_HEADERS JEH
WHERE FBH.DOC_ID = FBD.DOC_ID
AND FBH.BUDGET_LEVEL_ID = FBL.BUDGET_LEVEL_ID
AND FBH.SET_OF_BOOKS_ID = FBL.SET_OF_BOOKS_ID
AND FBD.TRANSACTION_TYPE_ID = FBTT.BE_TT_ID
AND FBD.SET_OF_BOOKS_ID = FBTT.SET_OF_BOOKS_ID
AND FBH.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID
AND FBH.SET_OF_BOOKS_ID = FTS.SET_OF_BOOKS_ID
AND TO_CHAR(FBD.TRANSACTION_ID) = JEL.REFERENCE_1
AND JEH.JE_SOURCE = 'BUDGETARY TRANSACTION'
AND JEH.JE_HEADER_ID = JEL.JE_HEADER_ID
AND JEH.LEDGER_ID = JEL.LEDGER_ID
AND FBD.SET_OF_BOOKS_ID = JEL.LEDGER_ID