View: FV_FACTS_TB_V

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

View Text

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.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.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
, FND_FLEX_VALUES_TL FFV
, FND_ID_FLEX_SEGMENTS FFIS
, FND_FLEX_VALUES FFVL
, GL_SETS_OF_BOOKS GLB
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 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 GLB.SET_OF_BOOKS_ID = FTS.SET_OF_BOOKS_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')

Columns