VIEW: APPS.IGF_AW_FUND_MAST_V

Source

View Text - Preformatted

SELECT FMAST.ROW_ID ,FMAST.FUND_ID ,FMAST.FUND_CODE ,FMAST.DESCRIPTION ,FCAT.FUND_TYPE ,FCAT.FUND_SOURCE ,FCAT.FED_FUND_CODE ,FCAT.SYS_FUND_TYPE ,FMAST.CI_CAL_TYPE ,FMAST.CI_SEQUENCE_NUMBER ,CI.ALTERNATE_CODE ,CI.START_DT ,CI.END_DT ,FMAST.DISCONTINUE_FUND ,FMAST.ENTITLEMENT ,FMAST.AUTO_PKG ,FMAST.SELF_HELP ,FMAST.ALLOW_MAN_PKG ,FMAST.UPDATE_NEED ,FMAST.DISBURSE_FUND ,FMAST.AVAILABLE_AMT ,FMAST.OFFERED_AMT ,FMAST.PENDING_AMT ,FMAST.ACCEPTED_AMT ,FMAST.DECLINED_AMT ,FMAST.CANCELLED_AMT ,FMAST.REMAINING_AMT ,FMAST.ENROLLMENT_STATUS ,ATT.DESCRIPTION ,FMAST.PRN_AWARD_LETTER ,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 ,FMAST.FM_FC_METHD ,IGF_AW_GEN.LOOKUP_DESC('IGF_AW_NEED_METHOD',FMAST.FM_FC_METHD) ,FMAST.ROUNDOFF_FACT ,IGF_AW_GEN.LOOKUP_DESC('IGF_AW_ROUND_OFF',FMAST.ROUNDOFF_FACT) ,FMAST.REPLACE_FC ,FMAST.ALLOW_OVERAWARD ,FMAST.PCKG_AWD_STAT ,IGF_AW_GEN.LOOKUP_DESC('IGF_AWARD_STATUS',FMAST.PCKG_AWD_STAT) ,FMAST.ORG_RECORD_REQ ,FMAST.DISB_RECORD_REQ ,FMAST.PROM_NOTE_REQ ,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 ,FMAST.FUND_RECV_REQD ,FMAST.SHOW_ON_BILL ,FMAST.BILL_DESC ,FMAST.CREDIT_TYPE_ID ,NULL ,CR.CREDIT_TYPE_NAME ,FMAST.ATTRIBUTE_CATEGORY ,FMAST.ATTRIBUTE1 ,FMAST.ATTRIBUTE2 ,FMAST.ATTRIBUTE3 ,FMAST.ATTRIBUTE4 ,FMAST.ATTRIBUTE5 ,FMAST.ATTRIBUTE6 ,FMAST.ATTRIBUTE7 ,FMAST.ATTRIBUTE8 ,FMAST.ATTRIBUTE9 ,FMAST.ATTRIBUTE10 ,FMAST.ATTRIBUTE11 ,FMAST.ATTRIBUTE12 ,FMAST.ATTRIBUTE13 ,FMAST.ATTRIBUTE14 ,FMAST.ATTRIBUTE15 ,FMAST.ATTRIBUTE16 ,FMAST.ATTRIBUTE17 ,FMAST.ATTRIBUTE18 ,FMAST.ATTRIBUTE19 ,FMAST.ATTRIBUTE20 ,FMAST.CREATED_BY ,FMAST.CREATION_DATE ,FMAST.LAST_UPDATE_DATE ,FMAST.LAST_UPDATED_BY ,FMAST.LAST_UPDATE_LOGIN ,FMAST.PROGRAM_APPLICATION_ID ,FMAST.PROGRAM_ID ,FMAST.PROGRAM_UPDATE_DATE ,FMAST.REQUEST_ID ,NULL ,NULL ,NULL ,NULL ,FMAST.THRESHOLD_PERCT ,FMAST.THRESHOLD_VALUE ,NULL ,NULL ,NULL ,CR.SUBACCOUNT_ID SUBACCOUNT_ID, FMAST.SPNSR_REF_NUM SPNSR_REF_NUM, FMAST.PARTY_ID PARTY_ID, HZ.PARTY_NUMBER PARTY_NUMBER, FMAST.SPNSR_FEE_TYPE SPNSR_FEE_TYPE, FMAST.MIN_CREDIT_POINTS MIN_CREDIT_POINTS, FMAST.GROUP_ID GROUP_ID, PIG.DESCRIPTION PERSID_GROUP_DESCRIPTION, FMAST.SPNSR_ATTRIBUTE_CATEGORY SPNSR_ATTRIBUTE_CATEGORY, FMAST.SPNSR_ATTRIBUTE1 SPNSR_ATTRIBUTE1, FMAST.SPNSR_ATTRIBUTE2 SPNSR_ATTRIBUTE2, FMAST.SPNSR_ATTRIBUTE3 SPNSR_ATTRIBUTE3, FMAST.SPNSR_ATTRIBUTE4 SPNSR_ATTRIBUTE4, FMAST.SPNSR_ATTRIBUTE5 SPNSR_ATTRIBUTE5, FMAST.SPNSR_ATTRIBUTE6 SPNSR_ATTRIBUTE6, FMAST.SPNSR_ATTRIBUTE7 SPNSR_ATTRIBUTE7, FMAST.SPNSR_ATTRIBUTE8 SPNSR_ATTRIBUTE8, FMAST.SPNSR_ATTRIBUTE9 SPNSR_ATTRIBUTE9, FMAST.SPNSR_ATTRIBUTE10 SPNSR_ATTRIBUTE10, FMAST.SPNSR_ATTRIBUTE11 SPNSR_ATTRIBUTE11, FMAST.SPNSR_ATTRIBUTE12 SPNSR_ATTRIBUTE12, FMAST.SPNSR_ATTRIBUTE13 SPNSR_ATTRIBUTE13, FMAST.SPNSR_ATTRIBUTE14 SPNSR_ATTRIBUTE14, FMAST.SPNSR_ATTRIBUTE15 SPNSR_ATTRIBUTE15, FMAST.SPNSR_ATTRIBUTE16 SPNSR_ATTRIBUTE16, FMAST.SPNSR_ATTRIBUTE17 SPNSR_ATTRIBUTE17, FMAST.SPNSR_ATTRIBUTE18 SPNSR_ATTRIBUTE18, FMAST.SPNSR_ATTRIBUTE19 SPNSR_ATTRIBUTE19, FMAST.SPNSR_ATTRIBUTE20 SPNSR_ATTRIBUTE20, FMAST.VER_APP_STAT_OVERRIDE, FMAST.GIFT_AID , FMAST.SEND_WITHOUT_DOC, FMAST.RE_PKG_VERIF_FLAG, FMAST.DONOT_REPKG_IF_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_REPKG_CODE', FMAST.DONOT_REPKG_IF_CODE), FMAST.LOCK_AWARD_FLAG, FMAST.DISB_ROUNDING_CODE ,IGF_AW_GEN.LOOKUP_DESC ('IGF_AW_DISB_ROUNDING', FMAST.DISB_ROUNDING_CODE) DISB_ROUNDING_DESC ,fmast.view_only_flag ,fmast.accept_less_amt_flag ,fmast.allow_inc_post_accept_flag ,fmast.min_increase_amt ,fmast.allow_dec_post_accept_flag ,fmast.min_decrease_amt ,fmast.allow_decln_post_accept_flag ,fmast.status_after_decline ,fmast.fund_information_txt ,igf_aw_gen.lookup_desc('IGF_AW_FUND_SOURCE', fcat.fund_source) FROM IGF_AW_FUND_MAST FMAST, IGS_CA_INST CI, IGF_AW_FUND_CAT FCAT, IGS_EN_ATD_TYPE ATT, IGS_FI_CR_TYPES CR, HZ_PARTIES HZ, IGS_PE_PERSID_GROUP PIG WHERE FMAST.CI_CAL_TYPE = CI.CAL_TYPE AND FMAST.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND FMAST.FUND_CODE = FCAT.FUND_CODE AND FMAST.ENROLLMENT_STATUS = ATT. ATTENDANCE_TYPE (+) AND FMAST.CREDIT_TYPE_ID = CR.CREDIT_TYPE_ID (+) AND FMAST.PARTY_ID = HZ.PARTY_ID (+) AND FMAST.GROUP_ID = PIG.GROUP_ID (+)

View Text - HTML Formatted

SELECT FMAST.ROW_ID
, FMAST.FUND_ID
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, FCAT.FUND_TYPE
, FCAT.FUND_SOURCE
, FCAT.FED_FUND_CODE
, FCAT.SYS_FUND_TYPE
, FMAST.CI_CAL_TYPE
, FMAST.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, FMAST.DISCONTINUE_FUND
, FMAST.ENTITLEMENT
, FMAST.AUTO_PKG
, FMAST.SELF_HELP
, FMAST.ALLOW_MAN_PKG
, FMAST.UPDATE_NEED
, FMAST.DISBURSE_FUND
, FMAST.AVAILABLE_AMT
, FMAST.OFFERED_AMT
, FMAST.PENDING_AMT
, FMAST.ACCEPTED_AMT
, FMAST.DECLINED_AMT
, FMAST.CANCELLED_AMT
, FMAST.REMAINING_AMT
, FMAST.ENROLLMENT_STATUS
, ATT.DESCRIPTION
, FMAST.PRN_AWARD_LETTER
, 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
, FMAST.FM_FC_METHD
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_NEED_METHOD'
, FMAST.FM_FC_METHD)
, FMAST.ROUNDOFF_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_ROUND_OFF'
, FMAST.ROUNDOFF_FACT)
, FMAST.REPLACE_FC
, FMAST.ALLOW_OVERAWARD
, FMAST.PCKG_AWD_STAT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AWARD_STATUS'
, FMAST.PCKG_AWD_STAT)
, FMAST.ORG_RECORD_REQ
, FMAST.DISB_RECORD_REQ
, FMAST.PROM_NOTE_REQ
, 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
, FMAST.FUND_RECV_REQD
, FMAST.SHOW_ON_BILL
, FMAST.BILL_DESC
, FMAST.CREDIT_TYPE_ID
, NULL
, CR.CREDIT_TYPE_NAME
, FMAST.ATTRIBUTE_CATEGORY
, FMAST.ATTRIBUTE1
, FMAST.ATTRIBUTE2
, FMAST.ATTRIBUTE3
, FMAST.ATTRIBUTE4
, FMAST.ATTRIBUTE5
, FMAST.ATTRIBUTE6
, FMAST.ATTRIBUTE7
, FMAST.ATTRIBUTE8
, FMAST.ATTRIBUTE9
, FMAST.ATTRIBUTE10
, FMAST.ATTRIBUTE11
, FMAST.ATTRIBUTE12
, FMAST.ATTRIBUTE13
, FMAST.ATTRIBUTE14
, FMAST.ATTRIBUTE15
, FMAST.ATTRIBUTE16
, FMAST.ATTRIBUTE17
, FMAST.ATTRIBUTE18
, FMAST.ATTRIBUTE19
, FMAST.ATTRIBUTE20
, FMAST.CREATED_BY
, FMAST.CREATION_DATE
, FMAST.LAST_UPDATE_DATE
, FMAST.LAST_UPDATED_BY
, FMAST.LAST_UPDATE_LOGIN
, FMAST.PROGRAM_APPLICATION_ID
, FMAST.PROGRAM_ID
, FMAST.PROGRAM_UPDATE_DATE
, FMAST.REQUEST_ID
, NULL
, NULL
, NULL
, NULL
, FMAST.THRESHOLD_PERCT
, FMAST.THRESHOLD_VALUE
, NULL
, NULL
, NULL
, CR.SUBACCOUNT_ID SUBACCOUNT_ID
, FMAST.SPNSR_REF_NUM SPNSR_REF_NUM
, FMAST.PARTY_ID PARTY_ID
, HZ.PARTY_NUMBER PARTY_NUMBER
, FMAST.SPNSR_FEE_TYPE SPNSR_FEE_TYPE
, FMAST.MIN_CREDIT_POINTS MIN_CREDIT_POINTS
, FMAST.GROUP_ID GROUP_ID
, PIG.DESCRIPTION PERSID_GROUP_DESCRIPTION
, FMAST.SPNSR_ATTRIBUTE_CATEGORY SPNSR_ATTRIBUTE_CATEGORY
, FMAST.SPNSR_ATTRIBUTE1 SPNSR_ATTRIBUTE1
, FMAST.SPNSR_ATTRIBUTE2 SPNSR_ATTRIBUTE2
, FMAST.SPNSR_ATTRIBUTE3 SPNSR_ATTRIBUTE3
, FMAST.SPNSR_ATTRIBUTE4 SPNSR_ATTRIBUTE4
, FMAST.SPNSR_ATTRIBUTE5 SPNSR_ATTRIBUTE5
, FMAST.SPNSR_ATTRIBUTE6 SPNSR_ATTRIBUTE6
, FMAST.SPNSR_ATTRIBUTE7 SPNSR_ATTRIBUTE7
, FMAST.SPNSR_ATTRIBUTE8 SPNSR_ATTRIBUTE8
, FMAST.SPNSR_ATTRIBUTE9 SPNSR_ATTRIBUTE9
, FMAST.SPNSR_ATTRIBUTE10 SPNSR_ATTRIBUTE10
, FMAST.SPNSR_ATTRIBUTE11 SPNSR_ATTRIBUTE11
, FMAST.SPNSR_ATTRIBUTE12 SPNSR_ATTRIBUTE12
, FMAST.SPNSR_ATTRIBUTE13 SPNSR_ATTRIBUTE13
, FMAST.SPNSR_ATTRIBUTE14 SPNSR_ATTRIBUTE14
, FMAST.SPNSR_ATTRIBUTE15 SPNSR_ATTRIBUTE15
, FMAST.SPNSR_ATTRIBUTE16 SPNSR_ATTRIBUTE16
, FMAST.SPNSR_ATTRIBUTE17 SPNSR_ATTRIBUTE17
, FMAST.SPNSR_ATTRIBUTE18 SPNSR_ATTRIBUTE18
, FMAST.SPNSR_ATTRIBUTE19 SPNSR_ATTRIBUTE19
, FMAST.SPNSR_ATTRIBUTE20 SPNSR_ATTRIBUTE20
, FMAST.VER_APP_STAT_OVERRIDE
, FMAST.GIFT_AID
, FMAST.SEND_WITHOUT_DOC
, FMAST.RE_PKG_VERIF_FLAG
, FMAST.DONOT_REPKG_IF_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_REPKG_CODE'
, FMAST.DONOT_REPKG_IF_CODE)
, FMAST.LOCK_AWARD_FLAG
, FMAST.DISB_ROUNDING_CODE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AW_DISB_ROUNDING'
, FMAST.DISB_ROUNDING_CODE) DISB_ROUNDING_DESC
, FMAST.VIEW_ONLY_FLAG
, FMAST.ACCEPT_LESS_AMT_FLAG
, FMAST.ALLOW_INC_POST_ACCEPT_FLAG
, FMAST.MIN_INCREASE_AMT
, FMAST.ALLOW_DEC_POST_ACCEPT_FLAG
, FMAST.MIN_DECREASE_AMT
, FMAST.ALLOW_DECLN_POST_ACCEPT_FLAG
, FMAST.STATUS_AFTER_DECLINE
, FMAST.FUND_INFORMATION_TXT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_FUND_SOURCE'
, FCAT.FUND_SOURCE)
FROM IGF_AW_FUND_MAST FMAST
, IGS_CA_INST CI
, IGF_AW_FUND_CAT FCAT
, IGS_EN_ATD_TYPE ATT
, IGS_FI_CR_TYPES CR
, HZ_PARTIES HZ
, IGS_PE_PERSID_GROUP PIG
WHERE FMAST.CI_CAL_TYPE = CI.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND FMAST.ENROLLMENT_STATUS = ATT. ATTENDANCE_TYPE (+)
AND FMAST.CREDIT_TYPE_ID = CR.CREDIT_TYPE_ID (+)
AND FMAST.PARTY_ID = HZ.PARTY_ID (+)
AND FMAST.GROUP_ID = PIG.GROUP_ID (+)