View: FV_FACTS1_TB_V

Product:	FV - Federal Financials
Description:	This is view is used to publish FACTS-I Trial balance information in Rxi
Implementation/DBA Data:	APPS.FV_FACTS1_TB_V

View Text

SELECT FRT.ACCOUNT_NUMBER
, GLB.CURRENCY_CODE
, (FRT.DR_AMOUNT - FRT.CR_AMOUNT) AMOUNT
, FRT.DR_AMOUNT
, FRT.CR_AMOUNT
, FRT.ELIMINATIONS_DEPT
, FRT.G_NG_INDICATOR
, FRT.SET_OF_BOOKS_ID
, FRT.USSGL_ACCOUNT
, FRT.EXCH_NON_EXCH
, FRT.CUST_NON_CUST
, FRT.BUDGET_SUBFUNCTION
, FRT.FUND_VALUE
, FRT.BEGINNING_BALANCE
, (FRT.BEGINNING_BALANCE + FRT.DR_AMOUNT - FRT.CR_AMOUNT) ENDING_BALANCE
, FRT.SEGMENT1
, FRT.SEGMENT2
, FRT.SEGMENT3
, FRT.SEGMENT4
, FRT.SEGMENT5
, FRT.SEGMENT6
, FRT.SEGMENT7
, FRT.SEGMENT8
, FRT.SEGMENT9
, FRT.SEGMENT10
, FRT.SEGMENT11
, FRT.SEGMENT12
, FRT.SEGMENT13
, FRT.SEGMENT14
, FRT.SEGMENT15
, FRT.SEGMENT16
, FRT.SEGMENT17
, FRT.SEGMENT18
, FRT.SEGMENT19
, FRT.SEGMENT20
, FRT.SEGMENT21
, FRT.SEGMENT22
, FRT.SEGMENT23
, FRT.SEGMENT24
, FRT.SEGMENT25
, FRT.SEGMENT26
, FRT.SEGMENT27
, FRT.SEGMENT28
, FRT.SEGMENT29
, FRT.SEGMENT30
, FFV.DESCRIPTION
, FTS.TREASURY_SYMBOL
FROM FV_FACTS_REPORT_T2 FRT
, FND_FLEX_VALUES_TL FFV
, FND_ID_FLEX_SEGMENTS FFIS
, FND_FLEX_VALUES FFVL
, GL_SETS_OF_BOOKS GLB
, FV_FUND_PARAMETERS FFP
, FV_TREASURY_SYMBOLS FTS
WHERE FRT.RECORD_CATEGORY = 'TRIAL_BAL'
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 = FRT.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 = FRT.ACCOUNT_NUMBER
AND FFVL.FLEX_VALUE_ID = FFV.FLEX_VALUE_ID
AND FFP.SET_OF_BOOKS_ID = FRT.SET_OF_BOOKS_ID
AND FFP.FUND_VALUE = FRT.FUND_VALUE
AND FTS.TREASURY_SYMBOL_ID = FFP.TREASURY_SYMBOL_ID
AND FFV.LANGUAGE = USERENV('LANG')

Columns