VIEW: APPS.IGF_SP_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 , FMAST.ELIG_CRITERIA , 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_UPDATED_BY , FMAST.LAST_UPDATE_DATE , FMAST.LAST_UPDATE_LOGIN , FMAST.REQUEST_ID , FMAST.PROGRAM_ID , FMAST.PROGRAM_APPLICATION_ID , FMAST.PROGRAM_UPDATE_DATE , NULL , NULL , FMAST.THRESHOLD_PERCT , FMAST.THRESHOLD_VALUE , NULL , NULL , NULL , FMAST.SPNSR_REF_NUM SPNSR_REF_NUM , FMAST.PARTY_ID PARTY_ID , FIPV.PERSON_NUMBER PARTY_NUMBER , FMAST.SPNSR_FEE_TYPE , FMAST.MIN_CREDIT_POINTS , FMAST.GROUP_ID , PIG.DESCRIPTION , FMAST.SPNSR_ATTRIBUTE_CATEGORY , FMAST.SPNSR_ATTRIBUTE1 , FMAST.SPNSR_ATTRIBUTE2 , FMAST.SPNSR_ATTRIBUTE3 , FMAST.SPNSR_ATTRIBUTE4 , FMAST.SPNSR_ATTRIBUTE5 , FMAST.SPNSR_ATTRIBUTE6 , FMAST.SPNSR_ATTRIBUTE7 , FMAST.SPNSR_ATTRIBUTE8 , FMAST.SPNSR_ATTRIBUTE9 , FMAST.SPNSR_ATTRIBUTE10 , FMAST.SPNSR_ATTRIBUTE11 , FMAST.SPNSR_ATTRIBUTE12 , FMAST.SPNSR_ATTRIBUTE13 , FMAST.SPNSR_ATTRIBUTE14 , FMAST.SPNSR_ATTRIBUTE15 , FMAST.SPNSR_ATTRIBUTE16 , FMAST.SPNSR_ATTRIBUTE17 , FMAST.SPNSR_ATTRIBUTE18 , FMAST.SPNSR_ATTRIBUTE19 , FMAST.SPNSR_ATTRIBUTE20 , FMAST.VER_APP_STAT_OVERRIDE , FMAST.GIFT_AID , FMAST.SEND_WITHOUT_DOC , BM.AWARD_YEAR_STATUS_CODE , FMAST.DISB_ROUNDING_CODE , IGF_AW_GEN.LOOKUP_DESC ('IGF_AW_DISB_ROUNDING', FMAST.DISB_ROUNDING_CODE) DISB_ROUNDING_DESC , FMAST.RE_PKG_VERIF_FLAG , FMAST.DONOT_REPKG_IF_CODE , FMAST.LOCK_AWARD_FLAG FROM IGF_AW_FUND_MAST FMAST, IGF_AP_BATCH_AW_MAP BM, IGS_CA_INST CI, IGF_AW_FUND_CAT FCAT, IGS_EN_ATD_TYPE ATT, IGS_FI_CR_TYPES CR, IGS_FI_PARTIES_V FIPV, IGS_PE_PERSID_GROUP PIG WHERE FMAST.CI_CAL_TYPE = BM.CI_CAL_TYPE AND FMAST.CI_SEQUENCE_NUMBER = BM.CI_SEQUENCE_NUMBER AND BM.CI_CAL_TYPE = CI.CAL_TYPE AND BM.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 = FIPV.PERSON_ID AND FMAST.GROUP_ID = PIG.GROUP_ID (+) AND FCAT.SYS_FUND_TYPE = 'SPONSOR' AND BM.AWARD_YEAR_STATUS_CODE IN ('O', 'C', 'LD')

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
, FMAST.ELIG_CRITERIA
, 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_UPDATED_BY
, FMAST.LAST_UPDATE_DATE
, FMAST.LAST_UPDATE_LOGIN
, FMAST.REQUEST_ID
, FMAST.PROGRAM_ID
, FMAST.PROGRAM_APPLICATION_ID
, FMAST.PROGRAM_UPDATE_DATE
, NULL
, NULL
, FMAST.THRESHOLD_PERCT
, FMAST.THRESHOLD_VALUE
, NULL
, NULL
, NULL
, FMAST.SPNSR_REF_NUM SPNSR_REF_NUM
, FMAST.PARTY_ID PARTY_ID
, FIPV.PERSON_NUMBER PARTY_NUMBER
, FMAST.SPNSR_FEE_TYPE
, FMAST.MIN_CREDIT_POINTS
, FMAST.GROUP_ID
, PIG.DESCRIPTION
, FMAST.SPNSR_ATTRIBUTE_CATEGORY
, FMAST.SPNSR_ATTRIBUTE1
, FMAST.SPNSR_ATTRIBUTE2
, FMAST.SPNSR_ATTRIBUTE3
, FMAST.SPNSR_ATTRIBUTE4
, FMAST.SPNSR_ATTRIBUTE5
, FMAST.SPNSR_ATTRIBUTE6
, FMAST.SPNSR_ATTRIBUTE7
, FMAST.SPNSR_ATTRIBUTE8
, FMAST.SPNSR_ATTRIBUTE9
, FMAST.SPNSR_ATTRIBUTE10
, FMAST.SPNSR_ATTRIBUTE11
, FMAST.SPNSR_ATTRIBUTE12
, FMAST.SPNSR_ATTRIBUTE13
, FMAST.SPNSR_ATTRIBUTE14
, FMAST.SPNSR_ATTRIBUTE15
, FMAST.SPNSR_ATTRIBUTE16
, FMAST.SPNSR_ATTRIBUTE17
, FMAST.SPNSR_ATTRIBUTE18
, FMAST.SPNSR_ATTRIBUTE19
, FMAST.SPNSR_ATTRIBUTE20
, FMAST.VER_APP_STAT_OVERRIDE
, FMAST.GIFT_AID
, FMAST.SEND_WITHOUT_DOC
, BM.AWARD_YEAR_STATUS_CODE
, FMAST.DISB_ROUNDING_CODE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AW_DISB_ROUNDING'
, FMAST.DISB_ROUNDING_CODE) DISB_ROUNDING_DESC
, FMAST.RE_PKG_VERIF_FLAG
, FMAST.DONOT_REPKG_IF_CODE
, FMAST.LOCK_AWARD_FLAG
FROM IGF_AW_FUND_MAST FMAST
, IGF_AP_BATCH_AW_MAP BM
, IGS_CA_INST CI
, IGF_AW_FUND_CAT FCAT
, IGS_EN_ATD_TYPE ATT
, IGS_FI_CR_TYPES CR
, IGS_FI_PARTIES_V FIPV
, IGS_PE_PERSID_GROUP PIG
WHERE FMAST.CI_CAL_TYPE = BM.CI_CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = BM.CI_SEQUENCE_NUMBER
AND BM.CI_CAL_TYPE = CI.CAL_TYPE
AND BM.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 = FIPV.PERSON_ID
AND FMAST.GROUP_ID = PIG.GROUP_ID (+)
AND FCAT.SYS_FUND_TYPE = 'SPONSOR'
AND BM.AWARD_YEAR_STATUS_CODE IN ('O'
, 'C'
, 'LD')