Product: | FV - Federal Financials |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT FFA.FEDERAL_ACCT_SYMBOL_NAME
, FTS.TREASURY_SYMBOL
, FTS.TREASURY_SYMBOL_ID
, '_LA:FTS.TIME_FRAME:FV_LOOKUP_CODES:FUND_TIME_FRAME:DESCRIPTION'
, FTS.YEARS_AVAILABLE
, FTS.ESTABLISHED_FISCAL_YR
, FTS.EXPIRATION_DATE
, FTS.CANCELLATION_DATE
, FTS.TAFS_SUB_ACCT
, FTS.TAFS_SPLIT_CODE
, FTS.TAFS_SPLIT_NAME
, '_LA:FTS.RESOURCE_TYPE:FV_LOOKUP_CODES:RESOURCE TYPE:DESCRIPTION'
, '_LA:FTS.SF224_TYPE_CODE:FV_LOOKUP_CODES:SF224_TYPE:DESCRIPTION'
, DECODE(FTS.DEF_INDEF_FLAG
, 'Y'
, 'DEFINITE'
, 'N'
, 'INDEFINITE'
, NULL)
, FTS.DEPARTMENT_ID
, FTS.BUREAU_ID
, FTS.BUSINESS_LINE
, FTS.SET_OF_BOOKS_ID
, GSB.NAME
, FTS.SF224_QTR1_OUTLAY
, FTS.SF224_QTR2_OUTLAY
, FTS.SF224_QTR3_OUTLAY
, FTS.SF224_QTR4_OUTLAY
, FTS.PRECLOSING_UNEXPENDED_AMT
, FTS.CLOSE_REQUISITIONS
, '_DF:FV:FV_TREAS_SYM_DESC_FLEX:FTS'
, FTS.LAST_UPDATE_DATE
, FTS.LAST_UPDATED_BY
, FTS.CREATION_DATE
, FTS.CREATED_BY
FROM FV_FACTS_FEDERAL_ACCOUNTS FFA
, FV_TREASURY_SYMBOLS FTS
, GL.GL_SETS_OF_BOOKS GSB
WHERE FFA.FEDERAL_ACCT_SYMBOL_ID = FTS.FEDERAL_ACCT_SYMBOL_ID
AND GSB.SET_OF_BOOKS_ID = FTS.SET_OF_BOOKS_ID WITH READ ONLY