FORM VIEW formed by joining IGF_SP_STD_FC MO view, IGF_SP_STDNT_REL MO view and IGS_LOOKUPS_VIEW. The view holds pays only fee class details for a sponsor fund.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT STDFC.ROWID , STDFC.FEE_CLS_ID , STDFC.SPNSR_STDNT_ID , STDFC.FEE_CLASS , LKP.MEANING , STDFC.FEE_PERCENT , STDFC.MAX_AMOUNT , STDFC.CREATED_BY , STDFC.CREATION_DATE , STDFC.LAST_UPDATED_BY , STDFC.LAST_UPDATE_DATE , STDFC.LAST_UPDATE_LOGIN , STDFC.ORG_ID FROM IGF_SP_STD_FC STDFC , IGF_SP_STDNT_REL SPSTD , IGS_LOOKUPS_VIEW LKP WHERE STDFC.SPNSR_STDNT_ID = SPSTD.SPNSR_STDNT_ID AND LKP.LOOKUP_TYPE = 'FEE_CLASS' AND LKP.LOOKUP_CODE = STDFC.FEE_CLASS