VIEW: APPS.FV_FACTS1_TB_V

Source

View Text - Preformatted

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_ledgers GLB, gl_access_set_assignments gsa, fv_fund_parameters ffp, fv_treasury_symbols fts, fnd_segment_attribute_values fsav WHERE frt.record_category = 'TRIAL_BAL' AND ffis.application_id = 101 AND ffis.id_flex_code = 'GL#' AND ffis.id_flex_num = glb.chart_of_accounts_id AND glb.ledger_id = frt.set_of_books_id AND gsa.ledger_id = glb.ledger_id and gsa.access_set_id = fnd_profile.value ('GL_ACCESS_SET_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 = 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') AND fsav.application_id = 101 and fsav.id_flex_code = 'GL#' and fsav.id_flex_num = glb.chart_of_accounts_id and fsav.segment_attribute_type = 'GL_ACCOUNT' and fsav.attribute_value = 'Y'

View Text - HTML Formatted

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_LEDGERS GLB
, GL_ACCESS_SET_ASSIGNMENTS GSA
, FV_FUND_PARAMETERS FFP
, FV_TREASURY_SYMBOLS FTS
, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
WHERE FRT.RECORD_CATEGORY = 'TRIAL_BAL'
AND FFIS.APPLICATION_ID = 101
AND FFIS.ID_FLEX_CODE = 'GL#'
AND FFIS.ID_FLEX_NUM = GLB.CHART_OF_ACCOUNTS_ID
AND GLB.LEDGER_ID = FRT.SET_OF_BOOKS_ID
AND GSA.LEDGER_ID = GLB.LEDGER_ID
AND GSA.ACCESS_SET_ID = FND_PROFILE.VALUE ('GL_ACCESS_SET_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 = 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')
AND FSAV.APPLICATION_ID = 101
AND FSAV.ID_FLEX_CODE = 'GL#'
AND FSAV.ID_FLEX_NUM = GLB.CHART_OF_ACCOUNTS_ID
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
AND FSAV.ATTRIBUTE_VALUE = 'Y'