Product: | FV - Federal Financials |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FV_BE_GL_V |
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