Product: | FV - Federal Financials |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT FTS.TREASURY_SYMBOL
, FFP.FUND_VALUE
, FFP.FUND_PARAMETER_ID
, '_LA:FFP.FUND_CATEGORY:FV_LOOKUP_CODES:FUND_CATEGORY:DESCRIPTION'
, FFP.SET_OF_BOOKS_ID
, GSB.NAME
, FFP.BUDGET_AUTHORITY
, FFP.TRANSFERS_IN
, FFP.TRANSFERS_OUT
, FFP.UNLIQUID_COMMITMENTS
, FFP.UNLIQUID_OBLIGATIONS
, FFP.EXPENDED_AMOUNT
, FFP.RED_STATUS
, FFP.PRIOR_YEAR_RECOVERIES
, '_DF:FV:FV_FUND_DESC_FLEX:FFP'
, FFP.LAST_UPDATE_DATE
, FFP.LAST_UPDATED_BY
, FFP.CREATION_DATE
, FFP.CREATED_BY
FROM FV_TREASURY_SYMBOLS FTS
, FV_FUND_PARAMETERS FFP
, GL_SETS_OF_BOOKS GSB
WHERE FTS.TREASURY_SYMBOL_ID = FFP.TREASURY_SYMBOL_ID
AND GSB.SET_OF_BOOKS_ID = FFP.SET_OF_BOOKS_ID WITH READ ONLY