View: FV_TBAL_BY_TS_V

Product:	FV - Federal Financials
Description:	Lists the treasury symbol processed by the FACTS II Trial balance process
Implementation/DBA Data:	APPS.FV_TBAL_BY_TS_V

View Text

SELECT FTS.ORG_ID
, FTS.TREASURY_SYMBOL
, GSB.CURRENCY_CODE
, FFV.DESCRIPTION
, FFT.SGL_ACCT_NUMBER
, FFT.AMOUNT BEGINNING_BALANCE
, FFT.AMOUNT1 PERIOD_DR
, FFT.AMOUNT2 PERIOD_CR
, (FFT.AMOUNT + FFT.AMOUNT1 - FFT.AMOUNT2) ENDING_BALANCE
, FFT.SEGMENT1
, FFT.SEGMENT2
, FFT.SEGMENT3
, FFT.SEGMENT4
, FFT.SEGMENT5
, FFT.SEGMENT6
, FFT.SEGMENT7
, FFT.SEGMENT8
, FFT.SEGMENT9
, FFT.SEGMENT10
, FFT.SEGMENT11
, FFT.SEGMENT12
, FFT.SEGMENT13
, FFT.SEGMENT14
, FFT.SEGMENT15
, FFT.SEGMENT16
, FFT.SEGMENT17
, FFT.SEGMENT18
, FFT.SEGMENT19
, FFT.SEGMENT20
, FFT.SEGMENT21
, FFT.SEGMENT22
, FFT.SEGMENT23
, FFT.SEGMENT24
, FFT.SEGMENT25
, FFT.SEGMENT26
, FFT.SEGMENT27
, FFT.SEGMENT28
, FFT.SEGMENT29
, FFT.SEGMENT30
FROM FV_TREASURY_SYMBOLS FTS
, FV_FACTS_TEMP FFT
, GL_SETS_OF_BOOKS GSB
, FND_FLEX_VALUES_TL FFV
, FND_ID_FLEX_SEGMENTS FFIS
, FND_FLEX_VALUES FFVL
WHERE FFT.FCT_INT_RECORD_CATEGORY = 'STBAL'
AND FFT.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID
AND GSB.SET_OF_BOOKS_ID = FTS.SET_OF_BOOKS_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 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 = FFT.SGL_ACCT_NUMBER
AND FFVL.FLEX_VALUE_ID = FFV.FLEX_VALUE_ID
AND FFV.LANGUAGE = USERENV('LANG')

Columns