VIEW: APPS.FV_FACTS_TRX_V

Source

View Text - Preformatted

SELECT FVFT.SET_OF_BOOKS_ID , GLB.CURRENCY_CODE , FVFT.CODE_COMBINATION_ID , FUND_VALUE , ACCOUNT_NUMBER , DECODE(debit,0,NULL,ACCOUNT_NUMBER) DEBIT_ACC , DECODE(credit,0,NULL,ACCOUNT_NUMBER) CREDIT_ACC , DOCUMENT_SOURCE , DOCUMENT_NUMBER , SUBSTR(document_number ,1,decode(INSTR(document_number,'.'),0,length(document_number) , INSTR(document_number,'.')-1)) ORIG_DOCNO , TRANSACTION_DATE , CREATION_DATE_TIME, ENTRY_USER , FED_NON_FED , TRADING_PARTNER , EXCH_NON_EXCH , FVFT.CUST_NON_CUST , BUDGET_SUBFUNCTION , DEBIT , CREDIT , TRANSFER_DEPT_ID , TRANSFER_MAIN_ACCT , YEAR_BUDGET_AUTH , BUDGET_FUNCTION , ADVANCE_FLAG , COHORT , BEGIN_END , INDEF_DEF_FLAG , APPOR_CAT_B_DTL , APPOR_CAT_B_TXT , PROGRAM_RPT_CAT_NUM, PROGRAM_RPT_CAT_TXT, PUBLIC_LAW , APPOR_CAT_CODE , AUTHORITY_TYPE , TRANSACTION_PARTNER , REIMBURSEABLE_FLAG , BEA_CATEGORY , BORROWING_SOURCE , DEF_LIQUID_FLAG , DEFICIENCY_FLAG , AVAILABILITY_FLAG , LEGISLATION_FLAG , PYA_FLAG, FTS.TREASURY_SYMBOL, GLCC.SEGMENT1, GLCC.SEGMENT2, GLCC.SEGMENT3, GLCC.SEGMENT4, GLCC.SEGMENT5, GLCC.SEGMENT6, GLCC.SEGMENT7, GLCC.SEGMENT8, GLCC.SEGMENT9, GLCC.SEGMENT10, GLCC.SEGMENT11, GLCC.SEGMENT12, GLCC.SEGMENT13, GLCC.SEGMENT14, GLCC.SEGMENT15, GLCC.SEGMENT16, GLCC.SEGMENT17, GLCC.SEGMENT18, GLCC.SEGMENT19, GLCC.SEGMENT20, GLCC.SEGMENT21, GLCC.SEGMENT22, GLCC.SEGMENT23, GLCC.SEGMENT24, GLCC.SEGMENT25, GLCC.SEGMENT26, GLCC.SEGMENT27, GLCC.SEGMENT28, GLCC.SEGMENT29, GLCC.SEGMENT30, FFV.DESCRIPTION, FVFT.JOURNAL_CREATION_DATE, FVFT.JOURNAL_MODIFIED_DATE, FVFT.PERIOD_NAME, FVFT.GL_DATE, FVFT.GL_POSTED_DATE, FVFT.DOCUMENT_CATEGORY, FVFT.REVERSAL_FLAG, FVFT.SLA_HDR_EVENT_ID, FVFT.SLA_HDR_CREATION_DATE, FVFT.SLA_ENTITY_ID FROM fv_facts_trx_temp fvft, gl_code_combinations glcc, fv_treasury_symbols fts, fnd_flex_values_tl ffv, fnd_id_flex_segments ffis, fnd_flex_values ffvl, gl_ledgers glb, gl_access_set_ledgers gsl, fnd_segment_attribute_values fsav WHERE glcc.code_combination_id = fvft.code_combination_id 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 glb.ledger_id = fts.set_of_books_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 = fvft.account_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 = glb.chart_of_accounts_id and fsav.segment_attribute_type = 'GL_ACCOUNT' and fsav.attribute_value = 'Y' ORDER BY fvft.sla_entity_id

View Text - HTML Formatted

SELECT FVFT.SET_OF_BOOKS_ID
, GLB.CURRENCY_CODE
, FVFT.CODE_COMBINATION_ID
, FUND_VALUE
, ACCOUNT_NUMBER
, DECODE(DEBIT
, 0
, NULL
, ACCOUNT_NUMBER) DEBIT_ACC
, DECODE(CREDIT
, 0
, NULL
, ACCOUNT_NUMBER) CREDIT_ACC
, DOCUMENT_SOURCE
, DOCUMENT_NUMBER
, SUBSTR(DOCUMENT_NUMBER
, 1
, DECODE(INSTR(DOCUMENT_NUMBER
, '.')
, 0
, LENGTH(DOCUMENT_NUMBER)
, INSTR(DOCUMENT_NUMBER
, '.')-1)) ORIG_DOCNO
, TRANSACTION_DATE
, CREATION_DATE_TIME
, ENTRY_USER
, FED_NON_FED
, TRADING_PARTNER
, EXCH_NON_EXCH
, FVFT.CUST_NON_CUST
, BUDGET_SUBFUNCTION
, DEBIT
, CREDIT
, TRANSFER_DEPT_ID
, TRANSFER_MAIN_ACCT
, YEAR_BUDGET_AUTH
, BUDGET_FUNCTION
, ADVANCE_FLAG
, COHORT
, BEGIN_END
, INDEF_DEF_FLAG
, APPOR_CAT_B_DTL
, APPOR_CAT_B_TXT
, PROGRAM_RPT_CAT_NUM
, PROGRAM_RPT_CAT_TXT
, PUBLIC_LAW
, APPOR_CAT_CODE
, AUTHORITY_TYPE
, TRANSACTION_PARTNER
, REIMBURSEABLE_FLAG
, BEA_CATEGORY
, BORROWING_SOURCE
, DEF_LIQUID_FLAG
, DEFICIENCY_FLAG
, AVAILABILITY_FLAG
, LEGISLATION_FLAG
, PYA_FLAG
, FTS.TREASURY_SYMBOL
, GLCC.SEGMENT1
, GLCC.SEGMENT2
, GLCC.SEGMENT3
, GLCC.SEGMENT4
, GLCC.SEGMENT5
, GLCC.SEGMENT6
, GLCC.SEGMENT7
, GLCC.SEGMENT8
, GLCC.SEGMENT9
, GLCC.SEGMENT10
, GLCC.SEGMENT11
, GLCC.SEGMENT12
, GLCC.SEGMENT13
, GLCC.SEGMENT14
, GLCC.SEGMENT15
, GLCC.SEGMENT16
, GLCC.SEGMENT17
, GLCC.SEGMENT18
, GLCC.SEGMENT19
, GLCC.SEGMENT20
, GLCC.SEGMENT21
, GLCC.SEGMENT22
, GLCC.SEGMENT23
, GLCC.SEGMENT24
, GLCC.SEGMENT25
, GLCC.SEGMENT26
, GLCC.SEGMENT27
, GLCC.SEGMENT28
, GLCC.SEGMENT29
, GLCC.SEGMENT30
, FFV.DESCRIPTION
, FVFT.JOURNAL_CREATION_DATE
, FVFT.JOURNAL_MODIFIED_DATE
, FVFT.PERIOD_NAME
, FVFT.GL_DATE
, FVFT.GL_POSTED_DATE
, FVFT.DOCUMENT_CATEGORY
, FVFT.REVERSAL_FLAG
, FVFT.SLA_HDR_EVENT_ID
, FVFT.SLA_HDR_CREATION_DATE
, FVFT.SLA_ENTITY_ID
FROM FV_FACTS_TRX_TEMP FVFT
, GL_CODE_COMBINATIONS GLCC
, FV_TREASURY_SYMBOLS FTS
, FND_FLEX_VALUES_TL FFV
, FND_ID_FLEX_SEGMENTS FFIS
, FND_FLEX_VALUES FFVL
, GL_LEDGERS GLB
, GL_ACCESS_SET_LEDGERS GSL
, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
WHERE GLCC.CODE_COMBINATION_ID = FVFT.CODE_COMBINATION_ID
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 GLB.LEDGER_ID = FTS.SET_OF_BOOKS_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 = FVFT.ACCOUNT_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 = GLB.CHART_OF_ACCOUNTS_ID
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
AND FSAV.ATTRIBUTE_VALUE = 'Y' ORDER BY FVFT.SLA_ENTITY_ID