VIEW: APPS.FV_GTAS_TB_V

Source

View Text - Preformatted

SELECT GRT.ACCOUNT_NUMBER , GLB.CURRENCY_CODE , (GRT.DR_AMOUNT - GRT.CR_AMOUNT) AMOUNT , GRT.DR_AMOUNT , GRT.CR_AMOUNT , GRT.SET_OF_BOOKS_ID , GRT.USSGL_ACCOUNT , GRT.EXCH_NON_EXCH , GRT.CUST_NON_CUST , GRT.FUND_VALUE , GRT.BEGINNING_BALANCE , (GRT.BEGINNING_BALANCE + GRT.DR_AMOUNT - GRT.CR_AMOUNT) ENDING_BALANCE , GRT.SEGMENT1 , GRT.SEGMENT2 , GRT.SEGMENT3 , GRT.SEGMENT4 , GRT.SEGMENT5 , GRT.SEGMENT6 , GRT.SEGMENT7 , GRT.SEGMENT8 , GRT.SEGMENT9 , GRT.SEGMENT10 , GRT.SEGMENT11 , GRT.SEGMENT12 , GRT.SEGMENT13 , GRT.SEGMENT14 , GRT.SEGMENT15 , GRT.SEGMENT16 , GRT.SEGMENT17 , GRT.SEGMENT18 , GRT.SEGMENT19 , GRT.SEGMENT20 , GRT.SEGMENT21 , GRT.SEGMENT22 , GRT.SEGMENT23 , GRT.SEGMENT24 , GRT.SEGMENT25 , GRT.SEGMENT26 , GRT.SEGMENT27 , GRT.SEGMENT28 , GRT.SEGMENT29 , GRT.SEGMENT30 , FTS.TREASURY_SYMBOL , FTS.SUB_LEVEL_PREFIX_CODE , FTS.DEPT_TRANSFER , FTS.ESTABLISHED_FISCAL_YR , FTS.AVAILABILITY_TYPE_CODE , FTS.TAFS_SUB_ACCT , FTS.DEPARTMENT_ID , FTS.FUND_GROUP_CODE , GRT.DIRECT_OR_REIMB_CODE , GRT.APPOR_CAT_CODE , GRT.APPOR_CAT_B_CODE , GRT.FED_NON_FED , GRT.NEW_BAL_CODE , GRT.CUR_SUBSEQUENT_CODE , GRT.BEA_CAT_CODE , GRT.BORR_SRC_CODE , GRT.AUTHORITY_TYPE_CODE , GRT.BUDGET_IMPACT_IND , GRT.PYA_CODE , GRT.PROGRAM_COST_IND , GRT.PROGRAM_REPT_CODE , GRT.TRADING_PARTNER_AGENCY_ID , GRT.TRADING_PARTNER_MAIN_ACCOUNT , GRT.CREDIT_COHORT_YR , FTS.END_YEAR_AVAIL FROM FV_GTAS1_REPORT_T2 GRT , GL_SETS_OF_BOOKS GLB , FV_TREASURY_SYMBOLS FTS WHERE GRT.RECORD_CATEGORY = 'TRIAL_BAL' AND GLB.SET_OF_BOOKS_ID = GRT.SET_OF_BOOKS_ID AND FTS.SET_OF_BOOKS_ID = GRT.SET_OF_BOOKS_ID AND GRT.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID

View Text - HTML Formatted

SELECT GRT.ACCOUNT_NUMBER
, GLB.CURRENCY_CODE
, (GRT.DR_AMOUNT - GRT.CR_AMOUNT) AMOUNT
, GRT.DR_AMOUNT
, GRT.CR_AMOUNT
, GRT.SET_OF_BOOKS_ID
, GRT.USSGL_ACCOUNT
, GRT.EXCH_NON_EXCH
, GRT.CUST_NON_CUST
, GRT.FUND_VALUE
, GRT.BEGINNING_BALANCE
, (GRT.BEGINNING_BALANCE + GRT.DR_AMOUNT - GRT.CR_AMOUNT) ENDING_BALANCE
, GRT.SEGMENT1
, GRT.SEGMENT2
, GRT.SEGMENT3
, GRT.SEGMENT4
, GRT.SEGMENT5
, GRT.SEGMENT6
, GRT.SEGMENT7
, GRT.SEGMENT8
, GRT.SEGMENT9
, GRT.SEGMENT10
, GRT.SEGMENT11
, GRT.SEGMENT12
, GRT.SEGMENT13
, GRT.SEGMENT14
, GRT.SEGMENT15
, GRT.SEGMENT16
, GRT.SEGMENT17
, GRT.SEGMENT18
, GRT.SEGMENT19
, GRT.SEGMENT20
, GRT.SEGMENT21
, GRT.SEGMENT22
, GRT.SEGMENT23
, GRT.SEGMENT24
, GRT.SEGMENT25
, GRT.SEGMENT26
, GRT.SEGMENT27
, GRT.SEGMENT28
, GRT.SEGMENT29
, GRT.SEGMENT30
, FTS.TREASURY_SYMBOL
, FTS.SUB_LEVEL_PREFIX_CODE
, FTS.DEPT_TRANSFER
, FTS.ESTABLISHED_FISCAL_YR
, FTS.AVAILABILITY_TYPE_CODE
, FTS.TAFS_SUB_ACCT
, FTS.DEPARTMENT_ID
, FTS.FUND_GROUP_CODE
, GRT.DIRECT_OR_REIMB_CODE
, GRT.APPOR_CAT_CODE
, GRT.APPOR_CAT_B_CODE
, GRT.FED_NON_FED
, GRT.NEW_BAL_CODE
, GRT.CUR_SUBSEQUENT_CODE
, GRT.BEA_CAT_CODE
, GRT.BORR_SRC_CODE
, GRT.AUTHORITY_TYPE_CODE
, GRT.BUDGET_IMPACT_IND
, GRT.PYA_CODE
, GRT.PROGRAM_COST_IND
, GRT.PROGRAM_REPT_CODE
, GRT.TRADING_PARTNER_AGENCY_ID
, GRT.TRADING_PARTNER_MAIN_ACCOUNT
, GRT.CREDIT_COHORT_YR
, FTS.END_YEAR_AVAIL
FROM FV_GTAS1_REPORT_T2 GRT
, GL_SETS_OF_BOOKS GLB
, FV_TREASURY_SYMBOLS FTS
WHERE GRT.RECORD_CATEGORY = 'TRIAL_BAL'
AND GLB.SET_OF_BOOKS_ID = GRT.SET_OF_BOOKS_ID
AND FTS.SET_OF_BOOKS_ID = GRT.SET_OF_BOOKS_ID
AND GRT.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID