VIEW: APPS.FV_TBAL_BY_TS_V

Source

View Text - Preformatted

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_access_set_ledgers gsl, gl_ledgers gsb, fnd_flex_values_tl ffv, fnd_id_flex_segments ffis, fnd_flex_values ffvl, fnd_segment_attribute_values fsav WHERE fft.fct_int_record_category = 'STBAL' AND fft.treasury_symbol_id = fts.treasury_symbol_id AND gsb.ledger_id = fts.set_of_books_id AND gsl.access_set_id = fnd_profile.value ('GL_ACCESS_SET_ID') AND gsb.ledger_id = gsl.ledger_id AND ffis.application_id = 101 AND ffis.id_flex_code = 'GL#' AND ffis.id_flex_num = gsb.chart_of_accounts_id AND ffis.application_column_name = fsav.application_column_name 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') AND fsav.application_id = 101 and fsav.id_flex_code = 'GL#' and fsav.id_flex_num = gsb.chart_of_accounts_id and fsav.segment_attribute_type = 'GL_ACCOUNT' and fsav.attribute_value = 'Y'

View Text - HTML Formatted

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_ACCESS_SET_LEDGERS GSL
, GL_LEDGERS GSB
, FND_FLEX_VALUES_TL FFV
, FND_ID_FLEX_SEGMENTS FFIS
, FND_FLEX_VALUES FFVL
, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
WHERE FFT.FCT_INT_RECORD_CATEGORY = 'STBAL'
AND FFT.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID
AND GSB.LEDGER_ID = FTS.SET_OF_BOOKS_ID
AND GSL.ACCESS_SET_ID = FND_PROFILE.VALUE ('GL_ACCESS_SET_ID')
AND GSB.LEDGER_ID = GSL.LEDGER_ID
AND FFIS.APPLICATION_ID = 101
AND FFIS.ID_FLEX_CODE = 'GL#'
AND FFIS.ID_FLEX_NUM = GSB.CHART_OF_ACCOUNTS_ID
AND FFIS.APPLICATION_COLUMN_NAME = FSAV.APPLICATION_COLUMN_NAME
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')
AND FSAV.APPLICATION_ID = 101
AND FSAV.ID_FLEX_CODE = 'GL#'
AND FSAV.ID_FLEX_NUM = GSB.CHART_OF_ACCOUNTS_ID
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
AND FSAV.ATTRIBUTE_VALUE = 'Y'