Product: | FV - Federal Financials |
---|---|
Description: | This view is used to publish FACTS transactrion register information in Rxi |
Implementation/DBA Data: | APPS.FV_FACTS_TRX_V |
SELECT FVFT.SET_OF_BOOKS_ID
, GLB.CURRENCY_CODE
, FVFT.CODE_COMBINATION_ID
, FUND_VALUE
, ACCOUNT_NUMBER
, DECODE(DEBIT
, 0
, NULL
, ACCOUNT_NUMBER) DEBIT_ACC
, DECODE(CREDIT
, 0
, NULL
, ACCOUNT_NUMBER) CREDIT_ACC
, DOCUMENT_SOURCE
, DOCUMENT_NUMBER
, SUBSTR(DOCUMENT_NUMBER
, 1
, DECODE(INSTR(DOCUMENT_NUMBER
, '.')
, 0
, LENGTH(DOCUMENT_NUMBER)
, INSTR(DOCUMENT_NUMBER
, '.')-1)) ORIG_DOCNO
, TRANSACTION_DATE
, CREATION_DATE_TIME
, ENTRY_USER
, FED_NON_FED
, TRADING_PARTNER
, EXCH_NON_EXCH
, FVFT.CUST_NON_CUST
, BUDGET_SUBFUNCTION
, DEBIT
, CREDIT
, TRANSFER_DEPT_ID
, TRANSFER_MAIN_ACCT
, YEAR_BUDGET_AUTH
, BUDGET_FUNCTION
, ADVANCE_FLAG
, COHORT
, BEGIN_END
, INDEF_DEF_FLAG
, APPOR_CAT_B_DTL
, APPOR_CAT_B_TXT
, PUBLIC_LAW
, APPOR_CAT_CODE
, AUTHORITY_TYPE
, TRANSACTION_PARTNER
, REIMBURSEABLE_FLAG
, BEA_CATEGORY
, BORROWING_SOURCE
, DEF_LIQUID_FLAG
, DEFICIENCY_FLAG
, AVAILABILITY_FLAG
, LEGISLATION_FLAG
, FTS.TREASURY_SYMBOL
, GLCC.SEGMENT1
, GLCC.SEGMENT2
, GLCC.SEGMENT3
, GLCC.SEGMENT4
, GLCC.SEGMENT5
, GLCC.SEGMENT6
, GLCC.SEGMENT7
, GLCC.SEGMENT8
, GLCC.SEGMENT9
, GLCC.SEGMENT10
, GLCC.SEGMENT11
, GLCC.SEGMENT12
, GLCC.SEGMENT13
, GLCC.SEGMENT14
, GLCC.SEGMENT15
, GLCC.SEGMENT16
, GLCC.SEGMENT17
, GLCC.SEGMENT18
, GLCC.SEGMENT19
, GLCC.SEGMENT20
, GLCC.SEGMENT21
, GLCC.SEGMENT22
, GLCC.SEGMENT23
, GLCC.SEGMENT24
, GLCC.SEGMENT25
, GLCC.SEGMENT26
, GLCC.SEGMENT27
, GLCC.SEGMENT28
, GLCC.SEGMENT29
, GLCC.SEGMENT30
, FFV.DESCRIPTION
, FVFT.JOURNAL_CREATION_DATE
, FVFT.JOURNAL_MODIFIED_DATE
, FVFT.PERIOD_NAME
FROM FV_FACTS_TRX_TEMP FVFT
, GL_CODE_COMBINATIONS GLCC
, FV_TREASURY_SYMBOLS FTS
, FND_FLEX_VALUES_TL FFV
, FND_ID_FLEX_SEGMENTS FFIS
, FND_FLEX_VALUES FFVL
, GL_SETS_OF_BOOKS GLB
WHERE GLCC.CODE_COMBINATION_ID = FVFT.CODE_COMBINATION_ID
AND FVFT.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID
AND FFIS.APPLICATION_ID = 101
AND FFIS.ID_FLEX_CODE = 'GL#'
AND FFIS.ID_FLEX_NUM = SYS_CONTEXT('FV_CONTEXT'
, 'CHART_OF_ACCOUNTS_ID')
AND GLB.SET_OF_BOOKS_ID = FTS.SET_OF_BOOKS_ID
AND FFIS.APPLICATION_COLUMN_NAME = SYS_CONTEXT('FV_CONTEXT'
, 'ACCT_SEGMENT')
AND FFIS.FLEX_VALUE_SET_ID = FFVL.FLEX_VALUE_SET_ID
AND FFVL.FLEX_VALUE = FVFT.ACCOUNT_NUMBER
AND FFVL.FLEX_VALUE_ID = FFV.FLEX_VALUE_ID
AND FFV.LANGUAGE = USERENV('LANG')