VIEW: APPS.IGFBV_FUNDS

Source

View Text - Preformatted

SELECT FMAST.FUND_CODE, FMAST.CI_CAL_TYPE, FMAST.CI_SEQUENCE_NUMBER, FMAST.DESCRIPTION, '_LA:FMAST.DISCONTINUE_FUND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.ENTITLEMENT:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.AUTO_PKG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.SELF_HELP:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING' , '_LA:FMAST.ALLOW_MAN_PKG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.UPDATE_NEED:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.DISBURSE_FUND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.AVAILABLE_AMT, FMAST.OFFERED_AMT, FMAST.PENDING_AMT , FMAST.ACCEPTED_AMT , FMAST.DECLINED_AMT , FMAST.CANCELLED_AMT , FMAST.REMAINING_AMT , FMAST.ENROLLMENT_STATUS , '_LA:FMAST.PRN_AWARD_LETTER:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.OVER_AWARD_AMT , FMAST.OVER_AWARD_PERCT , FMAST.MIN_AWARD_AMT , FMAST.MAX_AWARD_AMT , FMAST.MAX_YEARLY_AMT , FMAST.MAX_LIFE_AMT , FMAST.MAX_LIFE_TERM , '_LA:FMAST.FM_FC_METHD:IGF_LOOKUPS_VIEW:IGF_AW_NEED_METHOD:MEANING', '_LA:FMAST.ROUNDOFF_FACT:IGF_LOOKUPS_VIEW:IGF_AW_ROUND_OFF:MEANING', '_LA:FMAST.REPLACE_FC:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING', '_LA:FMAST.ALLOW_OVERAWARD:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING', '_LA:FMAST.PCKG_AWD_STAT:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING', '_LA:FMAST.ORG_RECORD_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.DISB_RECORD_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.PROM_NOTE_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.MIN_NUM_DISB , FMAST.MAX_NUM_DISB , FMAST.FEE_TYPE , FMAST.TOTAL_OFFERED , FMAST.TOTAL_ACCEPTED , FMAST.TOTAL_DECLINED , FMAST.TOTAL_REVOKED , FMAST.TOTAL_CANCELLED , FMAST.TOTAL_DISBURSED , FMAST.TOTAL_COMMITTED , FMAST.COMMITTED_AMT , FMAST.DISBURSED_AMT , FMAST.AWD_NOTICE_TXT , FMAST.DISB_VERF_DA , FMAST.FUND_EXP_DA , FMAST.NSLDS_DISB_DA , FMAST.DISB_EXP_DA , '_LA:FMAST.FUND_RECV_REQD:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.SHOW_ON_BILL:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.BILL_DESC , FMAST.CREDIT_TYPE_ID , NULL, FMAST.THRESHOLD_PERCT , FMAST.THRESHOLD_VALUE , NULL, NULL, NULL, FMAST.SPNSR_REF_NUM, FMAST.SPNSR_FEE_TYPE, FMAST.MIN_CREDIT_POINTS, FMAST.GROUP_ID GROUP_ID, '_LA:FMAST.VER_APP_STAT_OVERRIDE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.GIFT_AID:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.SEND_WITHOUT_DOC:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_DF:IGF:IGF_AW_FUND_MAST_ALL_FLEX:FMAST', '_DF:IGF:IGF_SP_FUND_MAST_SPNSR_FLEX:FMAST', '_LA:FMAST.VIEW_ONLY_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.ACCEPT_LESS_AMT_FLAG, '_LA:FMAST.ALLOW_INC_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.MIN_INCREASE_AMT, '_LA:FMAST.ALLOW_DEC_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', FMAST.MIN_DECREASE_AMT, '_LA:FMAST.ALLOW_DECLN_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:FMAST.STATUS_AFTER_DECLINE:IGF_LOOKUPS_VIEW:IGF_AW_AWD_STAT_POST_DECL:MEANING', FUND_INFORMATION_TXT, FMAST.PARTY_ID, FMAST.FUND_ID, FMAST.CREATED_BY , FMAST.CREATION_DATE , FMAST.LAST_UPDATED_BY , FMAST.LAST_UPDATE_DATE FROM IGF_AW_FUND_MAST_ALL FMAST WITH READ ONLY

View Text - HTML Formatted

SELECT FMAST.FUND_CODE
, FMAST.CI_CAL_TYPE
, FMAST.CI_SEQUENCE_NUMBER
, FMAST.DESCRIPTION
, '_LA:FMAST.DISCONTINUE_FUND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.ENTITLEMENT:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.AUTO_PKG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.SELF_HELP:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.ALLOW_MAN_PKG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.UPDATE_NEED:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.DISBURSE_FUND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.AVAILABLE_AMT
, FMAST.OFFERED_AMT
, FMAST.PENDING_AMT
, FMAST.ACCEPTED_AMT
, FMAST.DECLINED_AMT
, FMAST.CANCELLED_AMT
, FMAST.REMAINING_AMT
, FMAST.ENROLLMENT_STATUS
, '_LA:FMAST.PRN_AWARD_LETTER:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.OVER_AWARD_AMT
, FMAST.OVER_AWARD_PERCT
, FMAST.MIN_AWARD_AMT
, FMAST.MAX_AWARD_AMT
, FMAST.MAX_YEARLY_AMT
, FMAST.MAX_LIFE_AMT
, FMAST.MAX_LIFE_TERM
, '_LA:FMAST.FM_FC_METHD:IGF_LOOKUPS_VIEW:IGF_AW_NEED_METHOD:MEANING'
, '_LA:FMAST.ROUNDOFF_FACT:IGF_LOOKUPS_VIEW:IGF_AW_ROUND_OFF:MEANING'
, '_LA:FMAST.REPLACE_FC:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING'
, '_LA:FMAST.ALLOW_OVERAWARD:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING'
, '_LA:FMAST.PCKG_AWD_STAT:IGF_LOOKUPS_VIEW:IGF_AWARD_STATUS:MEANING'
, '_LA:FMAST.ORG_RECORD_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.DISB_RECORD_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.PROM_NOTE_REQ:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.MIN_NUM_DISB
, FMAST.MAX_NUM_DISB
, FMAST.FEE_TYPE
, FMAST.TOTAL_OFFERED
, FMAST.TOTAL_ACCEPTED
, FMAST.TOTAL_DECLINED
, FMAST.TOTAL_REVOKED
, FMAST.TOTAL_CANCELLED
, FMAST.TOTAL_DISBURSED
, FMAST.TOTAL_COMMITTED
, FMAST.COMMITTED_AMT
, FMAST.DISBURSED_AMT
, FMAST.AWD_NOTICE_TXT
, FMAST.DISB_VERF_DA
, FMAST.FUND_EXP_DA
, FMAST.NSLDS_DISB_DA
, FMAST.DISB_EXP_DA
, '_LA:FMAST.FUND_RECV_REQD:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.SHOW_ON_BILL:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.BILL_DESC
, FMAST.CREDIT_TYPE_ID
, NULL
, FMAST.THRESHOLD_PERCT
, FMAST.THRESHOLD_VALUE
, NULL
, NULL
, NULL
, FMAST.SPNSR_REF_NUM
, FMAST.SPNSR_FEE_TYPE
, FMAST.MIN_CREDIT_POINTS
, FMAST.GROUP_ID GROUP_ID
, '_LA:FMAST.VER_APP_STAT_OVERRIDE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.GIFT_AID:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.SEND_WITHOUT_DOC:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_DF:IGF:IGF_AW_FUND_MAST_ALL_FLEX:FMAST'
, '_DF:IGF:IGF_SP_FUND_MAST_SPNSR_FLEX:FMAST'
, '_LA:FMAST.VIEW_ONLY_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.ACCEPT_LESS_AMT_FLAG
, '_LA:FMAST.ALLOW_INC_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.MIN_INCREASE_AMT
, '_LA:FMAST.ALLOW_DEC_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, FMAST.MIN_DECREASE_AMT
, '_LA:FMAST.ALLOW_DECLN_POST_ACCEPT_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:FMAST.STATUS_AFTER_DECLINE:IGF_LOOKUPS_VIEW:IGF_AW_AWD_STAT_POST_DECL:MEANING'
, FUND_INFORMATION_TXT
, FMAST.PARTY_ID
, FMAST.FUND_ID
, FMAST.CREATED_BY
, FMAST.CREATION_DATE
, FMAST.LAST_UPDATED_BY
, FMAST.LAST_UPDATE_DATE
FROM IGF_AW_FUND_MAST_ALL FMAST WITH READ ONLY