VIEW: APPS.FV_GTAS_TRX_V

Source

View Text - Preformatted

SELECT FVFT.SET_OF_BOOKS_ID , GLB.CURRENCY_CODE , FVFT.CODE_COMBINATION_ID , FVFT.FUND_VALUE , FVFT.ACCOUNT_NUMBER , DECODE(FVFT.DEBIT, 0, NULL, FVFT.ACCOUNT_NUMBER) DEBIT_ACC , DECODE(FVFT.CREDIT, 0, NULL, FVFT.ACCOUNT_NUMBER) CREDIT_ACC , FVFT.DOCUMENT_SOURCE , FVFT.DOCUMENT_NUMBER , SUBSTR(FVFT.DOCUMENT_NUMBER, 1, DECODE(INSTR(FVFT.DOCUMENT_NUMBER, '.'), 0, LENGTH(FVFT.DOCUMENT_NUMBER), INSTR(FVFT.DOCUMENT_NUMBER, '.')-1)) ORIG_DOCNO , FVFT.TRANSACTION_DATE , FVFT.CREATION_DATE_TIME , FVFT.ENTRY_USER , FVFT.EXCH_NON_EXCH , FVFT.CUST_NON_CUST , FVFT.DEBIT , FVFT.CREDIT , FVFT.TRANSFER_DEPT_ID , FVFT.TRANSFER_MAIN_ACCT , FVFT.YEAR_BUDGET_AUTH , FVFT.ADVANCE_FLAG , FVFT.CREDIT_COHORT_YR , FVFT.BEGIN_END , FVFT.INDEF_DEF_FLAG , FVFT.APPOR_CAT_CODE , FVFT.APPOR_CAT_B_CODE , FVFT.AUTHORITY_TYPE , FVFT.TRANSACTION_PARTNER , FVFT.REIMBURSEABLE_FLAG , FVFT.BEA_CAT_CODE , FVFT.BORR_SRC_CODE , FVFT.DEF_LIQUID_FLAG , FVFT.DEFICIENCY_FLAG , FVFT.AVAILABILITY_FLAG , FVFT.LEGISLATION_FLAG , FVFT.FED_NON_FED , FVFT.DIRECT_OR_REIMB_CODE , FVFT.PROGRAM_REPT_CODE , FVFT.TRADING_PARTNER_AGENCY_ID , FVFT.TRADING_PARTNER_MAIN_ACCOUNT , FVFT.NEW_BAL_CODE , FVFT.CUR_SUBSEQUENT_CODE , FVFT.AUTHORITY_TYPE_CODE , FVFT.BUDGET_IMPACT_IND , FVFT.PYA_CODE , FVFT.PROGRAM_COST_IND , FVFT.SLA_HDR_EVENT_ID , FTS.TREASURY_SYMBOL , FTS.SUB_LEVEL_PREFIX_CODE , FTS.DEPT_TRANSFER , FTS.ESTABLISHED_FISCAL_YR , FTS.END_YEAR_AVAIL , FTS.AVAILABILITY_TYPE_CODE , FTS.TAFS_SUB_ACCT , FTS.DEPARTMENT_ID , FTS.FUND_GROUP_CODE , 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 , FVFT.JOURNAL_CREATION_DATE , FVFT.JOURNAL_MODIFIED_DATE , FVFT.PERIOD_NAME , FVFT.DOCUMENT_CATEGORY , FVFT.GL_POSTED_DATE , GLK.CONCATENATED_SEGMENTS , FVFT.GL_DATE , FVFT.USSGL_ACCOUNT FROM FV_GTAS_TRX_REG_TEMP FVFT , GL_CODE_COMBINATIONS GLCC , FV_TREASURY_SYMBOLS FTS , GL_SETS_OF_BOOKS GLB , GL_CODE_COMBINATIONS_KFV GLK WHERE GLCC.CODE_COMBINATION_ID = FVFT.CODE_COMBINATION_ID AND FVFT.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID AND GLB.SET_OF_BOOKS_ID = FTS.SET_OF_BOOKS_ID AND GLK.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID

View Text - HTML Formatted

SELECT FVFT.SET_OF_BOOKS_ID
, GLB.CURRENCY_CODE
, FVFT.CODE_COMBINATION_ID
, FVFT.FUND_VALUE
, FVFT.ACCOUNT_NUMBER
, DECODE(FVFT.DEBIT
, 0
, NULL
, FVFT.ACCOUNT_NUMBER) DEBIT_ACC
, DECODE(FVFT.CREDIT
, 0
, NULL
, FVFT.ACCOUNT_NUMBER) CREDIT_ACC
, FVFT.DOCUMENT_SOURCE
, FVFT.DOCUMENT_NUMBER
, SUBSTR(FVFT.DOCUMENT_NUMBER
, 1
, DECODE(INSTR(FVFT.DOCUMENT_NUMBER
, '.')
, 0
, LENGTH(FVFT.DOCUMENT_NUMBER)
, INSTR(FVFT.DOCUMENT_NUMBER
, '.')-1)) ORIG_DOCNO
, FVFT.TRANSACTION_DATE
, FVFT.CREATION_DATE_TIME
, FVFT.ENTRY_USER
, FVFT.EXCH_NON_EXCH
, FVFT.CUST_NON_CUST
, FVFT.DEBIT
, FVFT.CREDIT
, FVFT.TRANSFER_DEPT_ID
, FVFT.TRANSFER_MAIN_ACCT
, FVFT.YEAR_BUDGET_AUTH
, FVFT.ADVANCE_FLAG
, FVFT.CREDIT_COHORT_YR
, FVFT.BEGIN_END
, FVFT.INDEF_DEF_FLAG
, FVFT.APPOR_CAT_CODE
, FVFT.APPOR_CAT_B_CODE
, FVFT.AUTHORITY_TYPE
, FVFT.TRANSACTION_PARTNER
, FVFT.REIMBURSEABLE_FLAG
, FVFT.BEA_CAT_CODE
, FVFT.BORR_SRC_CODE
, FVFT.DEF_LIQUID_FLAG
, FVFT.DEFICIENCY_FLAG
, FVFT.AVAILABILITY_FLAG
, FVFT.LEGISLATION_FLAG
, FVFT.FED_NON_FED
, FVFT.DIRECT_OR_REIMB_CODE
, FVFT.PROGRAM_REPT_CODE
, FVFT.TRADING_PARTNER_AGENCY_ID
, FVFT.TRADING_PARTNER_MAIN_ACCOUNT
, FVFT.NEW_BAL_CODE
, FVFT.CUR_SUBSEQUENT_CODE
, FVFT.AUTHORITY_TYPE_CODE
, FVFT.BUDGET_IMPACT_IND
, FVFT.PYA_CODE
, FVFT.PROGRAM_COST_IND
, FVFT.SLA_HDR_EVENT_ID
, FTS.TREASURY_SYMBOL
, FTS.SUB_LEVEL_PREFIX_CODE
, FTS.DEPT_TRANSFER
, FTS.ESTABLISHED_FISCAL_YR
, FTS.END_YEAR_AVAIL
, FTS.AVAILABILITY_TYPE_CODE
, FTS.TAFS_SUB_ACCT
, FTS.DEPARTMENT_ID
, FTS.FUND_GROUP_CODE
, 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
, FVFT.JOURNAL_CREATION_DATE
, FVFT.JOURNAL_MODIFIED_DATE
, FVFT.PERIOD_NAME
, FVFT.DOCUMENT_CATEGORY
, FVFT.GL_POSTED_DATE
, GLK.CONCATENATED_SEGMENTS
, FVFT.GL_DATE
, FVFT.USSGL_ACCOUNT
FROM FV_GTAS_TRX_REG_TEMP FVFT
, GL_CODE_COMBINATIONS GLCC
, FV_TREASURY_SYMBOLS FTS
, GL_SETS_OF_BOOKS GLB
, GL_CODE_COMBINATIONS_KFV GLK
WHERE GLCC.CODE_COMBINATION_ID = FVFT.CODE_COMBINATION_ID
AND FVFT.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID
AND GLB.SET_OF_BOOKS_ID = FTS.SET_OF_BOOKS_ID
AND GLK.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID