VIEW: APPS.IGFFV_FFELP_AWD_DISBURSEMENTS

Source

View Text - Preformatted

SELECT SDLC.DISB_GROSS_AMT, SDLC.FEE_1, SDLC.FEE_2, SDLC.FEE_PAID_1, SDLC.FEE_PAID_2, SDLC.DISB_DATE, SDLC.DISB_NET_AMT, '_LA:DISB.TRANS_TYPE:IGF_LOOKUPS_VIEW:IGF_DB_TRANS_TYPE:MEANING', '_LA:DISB.FUND_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_FUND_STATUS:MEANING', '_LA:DISB.DISB_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CL_DISB_STATUS:MEANING', '_LA:DISB.HOLD_REL_IND:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_HOLD_REL_IND:MEANING', '_LA:DISB.FUND_DIST_MTHD:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_FUND_DISB_METH:MEANING', '_LA:DISB.PREV_REPORTED_IND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', DISB.DISB_STATUS_DATE, DISB.LATE_DISB_IND, DISB.CHEQUE_NUMBER, LOANS.LOAN_NUMBER, FABASE.CI_CAL_TYPE, FABASE.CI_SEQUENCE_NUMBER, CA.ALTERNATE_CODE, HZ.PARTY_NUMBER, HZ.PERSON_FIRST_NAME, HZ.PERSON_LAST_NAME, HZ.PERSON_MIDDLE_NAME, FMAST.FUND_CODE, FMAST.DESCRIPTION, LOANS.LOAN_ID, FABASE.BASE_ID, FABASE.PERSON_ID, SDLC.AWARD_ID, SDLC.DISB_NUM, SDLC.CREATED_BY, SDLC.CREATION_DATE, SDLC.LAST_UPDATED_BY, SDLC.LAST_UPDATE_DATE FROM IGF_SL_AWD_DISB_LOC_ALL SDLC, IGF_AW_AWARD_ALL AWD, IGF_AW_AWD_DISB_ALL DISB, IGF_AW_FUND_MAST_ALL FMAST, IGF_AW_FUND_CAT_ALL FCAT, IGF_SL_LOANS_ALL LOANS, IGF_AP_FA_BASE_REC_ALL FABASE, IGS_CA_INST_ALL CA, HZ_PARTIES HZ WHERE SDLC.AWARD_ID = AWD.AWARD_ID AND SDLC.AWARD_ID = DISB.AWARD_ID AND SDLC.DISB_NUM = DISB.DISB_NUM AND FMAST.FUND_ID = AWD.FUND_ID AND FCAT.FUND_CODE = FMAST.FUND_CODE AND LOANS.AWARD_ID = AWD.AWARD_ID AND FABASE.BASE_ID = AWD.BASE_ID AND FCAT.FED_FUND_CODE IN ('FLP','FLS','FLU','ALT') AND CA.CAL_TYPE = FABASE.CI_CAL_TYPE AND CA.SEQUENCE_NUMBER = FABASE.CI_SEQUENCE_NUMBER AND FABASE.PERSON_ID = HZ.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT SDLC.DISB_GROSS_AMT
, SDLC.FEE_1
, SDLC.FEE_2
, SDLC.FEE_PAID_1
, SDLC.FEE_PAID_2
, SDLC.DISB_DATE
, SDLC.DISB_NET_AMT
, '_LA:DISB.TRANS_TYPE:IGF_LOOKUPS_VIEW:IGF_DB_TRANS_TYPE:MEANING'
, '_LA:DISB.FUND_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_FUND_STATUS:MEANING'
, '_LA:DISB.DISB_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CL_DISB_STATUS:MEANING'
, '_LA:DISB.HOLD_REL_IND:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_HOLD_REL_IND:MEANING'
, '_LA:DISB.FUND_DIST_MTHD:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_FUND_DISB_METH:MEANING'
, '_LA:DISB.PREV_REPORTED_IND:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, DISB.DISB_STATUS_DATE
, DISB.LATE_DISB_IND
, DISB.CHEQUE_NUMBER
, LOANS.LOAN_NUMBER
, FABASE.CI_CAL_TYPE
, FABASE.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, HZ.PARTY_NUMBER
, HZ.PERSON_FIRST_NAME
, HZ.PERSON_LAST_NAME
, HZ.PERSON_MIDDLE_NAME
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, LOANS.LOAN_ID
, FABASE.BASE_ID
, FABASE.PERSON_ID
, SDLC.AWARD_ID
, SDLC.DISB_NUM
, SDLC.CREATED_BY
, SDLC.CREATION_DATE
, SDLC.LAST_UPDATED_BY
, SDLC.LAST_UPDATE_DATE
FROM IGF_SL_AWD_DISB_LOC_ALL SDLC
, IGF_AW_AWARD_ALL AWD
, IGF_AW_AWD_DISB_ALL DISB
, IGF_AW_FUND_MAST_ALL FMAST
, IGF_AW_FUND_CAT_ALL FCAT
, IGF_SL_LOANS_ALL LOANS
, IGF_AP_FA_BASE_REC_ALL FABASE
, IGS_CA_INST_ALL CA
, HZ_PARTIES HZ
WHERE SDLC.AWARD_ID = AWD.AWARD_ID
AND SDLC.AWARD_ID = DISB.AWARD_ID
AND SDLC.DISB_NUM = DISB.DISB_NUM
AND FMAST.FUND_ID = AWD.FUND_ID
AND FCAT.FUND_CODE = FMAST.FUND_CODE
AND LOANS.AWARD_ID = AWD.AWARD_ID
AND FABASE.BASE_ID = AWD.BASE_ID
AND FCAT.FED_FUND_CODE IN ('FLP'
, 'FLS'
, 'FLU'
, 'ALT')
AND CA.CAL_TYPE = FABASE.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = FABASE.CI_SEQUENCE_NUMBER
AND FABASE.PERSON_ID = HZ.PARTY_ID WITH READ ONLY