VIEW: APPS.IGFFV_STUDENT_FWS_AWAD_DETAILS

Source

View Text - Preformatted

SELECT DISB.DISB_GROSS_AMT, DISB.DISB_ACCEPTED_AMT, DISB.LD_CAL_TYPE, DISB.LD_SEQUENCE_NUMBER, DISB.NOTIFICATION_SENT, DISB.NOTIFICATION_DATE, (NVL(DISB.DISB_ACCEPTED_AMT,0) - NVL(DISB.DISB_PAID_AMT,0)) REMAINING_AMOUNT, DISB.DISB_PAID_AMT, DECODE( NVL(DISB.DISB_ACCEPTED_AMT,0), 0, 0, ROUND(NVL(DISB.DISB_PAID_AMT,0) * 100/ DISB.DISB_ACCEPTED_AMT)) PROGRESS_TWDS_LMT, DISB.AUTH_DATE, AWARD_CI.ALTERNATE_CODE, LOAD_CI.ALTERNATE_CODE, FMAST.FUND_CODE, FMAST.DESCRIPTION, HZ.PARTY_NUMBER, HZ.PERSON_FIRST_NAME, HZ.PERSON_LAST_NAME, HZ.PERSON_MIDDLE_NAME, FABASE.CI_CAL_TYPE, FABASE.CI_SEQUENCE_NUMBER, DISB.AUTH_ID, FABASE.PERSON_ID, FABASE.BASE_ID, FMAST.FUND_ID, DISB.AWARD_ID, DISB.DISB_NUM, DISB.CREATED_BY, DISB.CREATION_DATE, DISB.LAST_UPDATED_BY, DISB.LAST_UPDATE_DATE FROM IGF_AW_AWD_DISB_ALL DISB, IGF_AW_AWARD_ALL AWD, IGF_AP_FA_BASE_REC_ALL FABASE, IGF_AW_FUND_MAST_ALL FMAST, IGF_AW_FUND_CAT_ALL FCAT, IGS_CA_INST_ALL LOAD_CI, IGS_CA_INST_ALL AWARD_CI, HZ_PARTIES HZ WHERE DISB.AWARD_ID = AWD.AWARD_ID AND FABASE.BASE_ID = AWD.BASE_ID AND FMAST.FUND_ID = AWD.FUND_ID AND FMAST.FUND_CODE = FCAT.FUND_CODE AND LOAD_CI.CAL_TYPE = DISB.LD_CAL_TYPE AND LOAD_CI.SEQUENCE_NUMBER = DISB.LD_SEQUENCE_NUMBER AND FCAT.FED_FUND_CODE = 'FWS' AND HZ.PARTY_ID = FABASE.PERSON_ID AND AWARD_CI.CAL_TYPE = FABASE.CI_CAL_TYPE AND AWARD_CI.SEQUENCE_NUMBER = FABASE.CI_SEQUENCE_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT DISB.DISB_GROSS_AMT
, DISB.DISB_ACCEPTED_AMT
, DISB.LD_CAL_TYPE
, DISB.LD_SEQUENCE_NUMBER
, DISB.NOTIFICATION_SENT
, DISB.NOTIFICATION_DATE
, (NVL(DISB.DISB_ACCEPTED_AMT
, 0) - NVL(DISB.DISB_PAID_AMT
, 0)) REMAINING_AMOUNT
, DISB.DISB_PAID_AMT
, DECODE( NVL(DISB.DISB_ACCEPTED_AMT
, 0)
, 0
, 0
, ROUND(NVL(DISB.DISB_PAID_AMT
, 0) * 100/ DISB.DISB_ACCEPTED_AMT)) PROGRESS_TWDS_LMT
, DISB.AUTH_DATE
, AWARD_CI.ALTERNATE_CODE
, LOAD_CI.ALTERNATE_CODE
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, HZ.PARTY_NUMBER
, HZ.PERSON_FIRST_NAME
, HZ.PERSON_LAST_NAME
, HZ.PERSON_MIDDLE_NAME
, FABASE.CI_CAL_TYPE
, FABASE.CI_SEQUENCE_NUMBER
, DISB.AUTH_ID
, FABASE.PERSON_ID
, FABASE.BASE_ID
, FMAST.FUND_ID
, DISB.AWARD_ID
, DISB.DISB_NUM
, DISB.CREATED_BY
, DISB.CREATION_DATE
, DISB.LAST_UPDATED_BY
, DISB.LAST_UPDATE_DATE
FROM IGF_AW_AWD_DISB_ALL DISB
, IGF_AW_AWARD_ALL AWD
, IGF_AP_FA_BASE_REC_ALL FABASE
, IGF_AW_FUND_MAST_ALL FMAST
, IGF_AW_FUND_CAT_ALL FCAT
, IGS_CA_INST_ALL LOAD_CI
, IGS_CA_INST_ALL AWARD_CI
, HZ_PARTIES HZ
WHERE DISB.AWARD_ID = AWD.AWARD_ID
AND FABASE.BASE_ID = AWD.BASE_ID
AND FMAST.FUND_ID = AWD.FUND_ID
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND LOAD_CI.CAL_TYPE = DISB.LD_CAL_TYPE
AND LOAD_CI.SEQUENCE_NUMBER = DISB.LD_SEQUENCE_NUMBER
AND FCAT.FED_FUND_CODE = 'FWS'
AND HZ.PARTY_ID = FABASE.PERSON_ID
AND AWARD_CI.CAL_TYPE = FABASE.CI_CAL_TYPE
AND AWARD_CI.SEQUENCE_NUMBER = FABASE.CI_SEQUENCE_NUMBER WITH READ ONLY