VIEW: APPS.FV_FACTS_TB_V

Source

View Text - Preformatted

SELECT FVFT.PARENT_SGL_ACCT_NUMBER, FVFT.ADVANCE_FLAG, FVFT.AMOUNT BEGIN_AMT, FVFT.AMOUNT + PERIOD_ACTIVITY END_AMT, PERIOD_ACTIVITY, FVFT.APPOR_CAT_B_DTL, FVFT.APPOR_CAT_B_TXT, FVFT.PROGRAM_RPT_CAT_NUM, FVFT.PROGRAM_RPT_CAT_TXT, FVFT.APPOR_CAT_CODE, FVFT.AUTHORITY_TYPE, FVFT.AVAILABILITY_FLAG, FVFT.BEA_CATEGORY, FVFT.BORROWING_SOURCE, FVFT.BUDGET_FUNCTION, FVFT.CODE_COMBINATION_ID, FVFT.COHORT, FVFT.DEFICIENCY_FLAG, FVFT.DEF_LIQUID_FLAG, FVFT.INDEF_DEF_FLAG, FVFT.LEGISLATION_FLAG, FVFT.PYA_FLAG, FVFT.PUBLIC_LAW, FVFT.REIMBURSEABLE_FLAG, FVFT.SGL_ACCT_NUMBER, FVFT.TBAL_ACCT_NUM, FVFT.TBAL_FUND_VALUE, FVFT.TRANSACTION_PARTNER, FVFT.TRANSFER_DEPT_ID, FVFT.TRANSFER_MAIN_ACCT, FVFT.TREASURY_SYMBOL_ID, FVFT.YEAR_BUDGET_AUTH, FTS.TREASURY_SYMBOL, GLB.CURRENCY_CODE , FVFT.SEGMENT1, FVFT.SEGMENT2, FVFT.SEGMENT3, FVFT.SEGMENT4, FVFT.SEGMENT5, FVFT.SEGMENT6, FVFT.SEGMENT7, FVFT.SEGMENT8, FVFT.SEGMENT9, FVFT.SEGMENT10, FVFT.SEGMENT11, FVFT.SEGMENT12, FVFT.SEGMENT13, FVFT.SEGMENT14, FVFT.SEGMENT15, FVFT.SEGMENT16, FVFT.SEGMENT17, FVFT.SEGMENT18, FVFT.SEGMENT19, FVFT.SEGMENT20, FVFT.SEGMENT21, FVFT.SEGMENT22, FVFT.SEGMENT23, FVFT.SEGMENT24, FVFT.SEGMENT25, FVFT.SEGMENT26, FVFT.SEGMENT27, FVFT.SEGMENT28, FVFT.SEGMENT29, FVFT.SEGMENT30, FFV.DESCRIPTION, FVFT.AMOUNT1 DR_AMOUNT, FVFT.AMOUNT2 CR_AMOUNT FROM fv_facts_temp fvft, fv_treasury_symbols fts, gl_access_set_ledgers gsl, gl_ledgers glb, fnd_flex_values_tl ffv, fnd_id_flex_segments ffis, fnd_flex_values ffvl, fnd_segment_attribute_values fsav WHERE fvft.fct_int_record_category = 'REPORTED_NEW' AND fvft.fct_int_record_type = 'TB' AND fvft.treasury_symbol_id = fts.treasury_symbol_id AND gsl.access_set_id = fnd_profile.value ('GL_ACCESS_SET_ID') AND glb.ledger_id = gsl.ledger_id AND ffis.application_id = 101 AND ffis.id_flex_code = 'GL#' AND ffis.id_flex_num = glb.chart_of_accounts_id AND ffis.application_column_name = fsav.application_column_name AND fts.set_of_books_id = gsl.ledger_id AND ffis.flex_value_set_id = ffvl.flex_value_set_id AND ffvl.flex_value = fvft.tbal_acct_num 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 = glb.chart_of_accounts_id and fsav.segment_attribute_type = 'GL_ACCOUNT' and fsav.attribute_value = 'Y'

View Text - HTML Formatted

SELECT FVFT.PARENT_SGL_ACCT_NUMBER
, FVFT.ADVANCE_FLAG
, FVFT.AMOUNT BEGIN_AMT
, FVFT.AMOUNT + PERIOD_ACTIVITY END_AMT
, PERIOD_ACTIVITY
, FVFT.APPOR_CAT_B_DTL
, FVFT.APPOR_CAT_B_TXT
, FVFT.PROGRAM_RPT_CAT_NUM
, FVFT.PROGRAM_RPT_CAT_TXT
, FVFT.APPOR_CAT_CODE
, FVFT.AUTHORITY_TYPE
, FVFT.AVAILABILITY_FLAG
, FVFT.BEA_CATEGORY
, FVFT.BORROWING_SOURCE
, FVFT.BUDGET_FUNCTION
, FVFT.CODE_COMBINATION_ID
, FVFT.COHORT
, FVFT.DEFICIENCY_FLAG
, FVFT.DEF_LIQUID_FLAG
, FVFT.INDEF_DEF_FLAG
, FVFT.LEGISLATION_FLAG
, FVFT.PYA_FLAG
, FVFT.PUBLIC_LAW
, FVFT.REIMBURSEABLE_FLAG
, FVFT.SGL_ACCT_NUMBER
, FVFT.TBAL_ACCT_NUM
, FVFT.TBAL_FUND_VALUE
, FVFT.TRANSACTION_PARTNER
, FVFT.TRANSFER_DEPT_ID
, FVFT.TRANSFER_MAIN_ACCT
, FVFT.TREASURY_SYMBOL_ID
, FVFT.YEAR_BUDGET_AUTH
, FTS.TREASURY_SYMBOL
, GLB.CURRENCY_CODE
, FVFT.SEGMENT1
, FVFT.SEGMENT2
, FVFT.SEGMENT3
, FVFT.SEGMENT4
, FVFT.SEGMENT5
, FVFT.SEGMENT6
, FVFT.SEGMENT7
, FVFT.SEGMENT8
, FVFT.SEGMENT9
, FVFT.SEGMENT10
, FVFT.SEGMENT11
, FVFT.SEGMENT12
, FVFT.SEGMENT13
, FVFT.SEGMENT14
, FVFT.SEGMENT15
, FVFT.SEGMENT16
, FVFT.SEGMENT17
, FVFT.SEGMENT18
, FVFT.SEGMENT19
, FVFT.SEGMENT20
, FVFT.SEGMENT21
, FVFT.SEGMENT22
, FVFT.SEGMENT23
, FVFT.SEGMENT24
, FVFT.SEGMENT25
, FVFT.SEGMENT26
, FVFT.SEGMENT27
, FVFT.SEGMENT28
, FVFT.SEGMENT29
, FVFT.SEGMENT30
, FFV.DESCRIPTION
, FVFT.AMOUNT1 DR_AMOUNT
, FVFT.AMOUNT2 CR_AMOUNT
FROM FV_FACTS_TEMP FVFT
, FV_TREASURY_SYMBOLS FTS
, GL_ACCESS_SET_LEDGERS GSL
, GL_LEDGERS GLB
, FND_FLEX_VALUES_TL FFV
, FND_ID_FLEX_SEGMENTS FFIS
, FND_FLEX_VALUES FFVL
, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
WHERE FVFT.FCT_INT_RECORD_CATEGORY = 'REPORTED_NEW'
AND FVFT.FCT_INT_RECORD_TYPE = 'TB'
AND FVFT.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID
AND GSL.ACCESS_SET_ID = FND_PROFILE.VALUE ('GL_ACCESS_SET_ID')
AND GLB.LEDGER_ID = GSL.LEDGER_ID
AND FFIS.APPLICATION_ID = 101
AND FFIS.ID_FLEX_CODE = 'GL#'
AND FFIS.ID_FLEX_NUM = GLB.CHART_OF_ACCOUNTS_ID
AND FFIS.APPLICATION_COLUMN_NAME = FSAV.APPLICATION_COLUMN_NAME
AND FTS.SET_OF_BOOKS_ID = GSL.LEDGER_ID
AND FFIS.FLEX_VALUE_SET_ID = FFVL.FLEX_VALUE_SET_ID
AND FFVL.FLEX_VALUE = FVFT.TBAL_ACCT_NUM
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 = GLB.CHART_OF_ACCOUNTS_ID
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
AND FSAV.ATTRIBUTE_VALUE = 'Y'