Product: | IGF - Financial Aid |
---|---|
Description: | Stores details of each disbursement |
Implementation/DBA Data: | APPS.IGF_AW_AWD_DISB_V |
SELECT ADISB.ROW_ID
, ADISB.AWARD_ID
, ADISB.DISB_NUM
, ADISB.TP_CAL_TYPE
, ADISB.TP_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, ADISB.DISB_GROSS_AMT
, ADISB.FEE_1
, ADISB.FEE_2
, ADISB.DISB_NET_AMT
, ADISB.DISB_DATE
, ADISB.TRANS_TYPE
, ADISB.ELIG_STATUS
, ADISB.ELIG_STATUS_DATE
, ADISB.AFFIRM_FLAG
, ADISB.HOLD_REL_IND
, ADISB.MANUAL_HOLD_IND
, ADISB.DISB_STATUS
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DISB_STATUS'
, ADISB.DISB_STATUS)
, ADISB.DISB_STATUS_DATE
, ADISB.LATE_DISB_IND
, ADISB.FUND_DIST_MTHD
, ADISB.PREV_REPORTED_IND
, ADISB.FUND_RELEASE_DATE
, ADISB.FUND_STATUS
, ADISB.FUND_STATUS_DATE
, ADISB.FEE_PAID_1
, ADISB.FEE_PAID_2
, ADISB.CHEQUE_NUMBER
, ADISB.LD_CAL_TYPE
, ADISB.LD_SEQUENCE_NUMBER
, LD.ALTERNATE_CODE
, LD.START_DT
, LD.END_DT
, ADISB.DISB_ACCEPTED_AMT
, ADISB.DISB_PAID_AMT
, ADISB.RVSN_ID
, RVSN.DESCP
, ADISB.INT_REBATE_AMT
, ADISB.FORCE_DISB
, ADISB.DISB_EXP_DT
, ADISB.MIN_CREDIT_PTS
, ADISB.VERF_ENFR_DT
, ADISB.CREATED_BY
, ADISB.CREATION_DATE
, ADISB.LAST_UPDATED_BY
, ADISB.LAST_UPDATE_DATE
, ADISB.LAST_UPDATE_LOGIN
, ADISB.REQUEST_ID
, ADISB.PROGRAM_APPLICATION_ID
, ADISB.PROGRAM_ID
, ADISB.PROGRAM_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, ADISB.FEE_CLASS
, IGF_AW_GEN.LOOKUP_DESC('FEE_CLASS'
, ADISB.FEE_CLASS) FEE_CLASS_MEANING
, ADISB.SHOW_ON_BILL
, IGF_AW_GEN.LOOKUP_DESC ('IGF_DB_TRANS_TYPE'
, ADISB.TRANS_TYPE)
, IGF_AW_GEN.LOOKUP_DESC ('IGF_DB_ELIG_STATUS'
, ADISB.ELIG_STATUS)
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO'
, ADISB.AFFIRM_FLAG)
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_CL_HOLD_REL_IND_TF'
, ADISB.HOLD_REL_IND)
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_CL_DB_FUND_DISB_METH'
, ADISB.FUND_DIST_MTHD)
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO'
, ADISB.PREV_REPORTED_IND)
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_CL_DB_FUND_STATUS'
, ADISB.FUND_STATUS)
, ADISB.ATTENDANCE_TYPE_CODE
, ATD.DESCRIPTION
, ADISB.BASE_ATTENDANCE_TYPE_CODE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_GR_RFMS_ENROL_STAT'
, ADISB.BASE_ATTENDANCE_TYPE_CODE) BASE_ATTENDANCE_TYPE_DESC
, ADISB.PAYMENT_PRD_ST_DATE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_CHANGE_TYPE_CODE'
, ADISB.CHANGE_TYPE_CODE)
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DB_FUND_DISB_METH'
, ADISB.FUND_RETURN_MTHD_CODE)
, ADISB.CHANGE_TYPE_CODE
, ADISB.FUND_RETURN_MTHD_CODE
, ADISB.DIRECT_TO_BORR_FLAG
FROM IGF_AW_AWD_DISB ADISB
, IGS_CA_INST CI
, IGS_CA_INST LD
, IGF_AW_AWD_RVSN_RSN RVSN
, IGS_EN_ATD_TYPE ATD
WHERE ADISB.TP_CAL_TYPE =CI.CAL_TYPE(+)
AND ADISB.TP_SEQUENCE_NUMBER=CI.SEQUENCE_NUMBER(+)
AND ADISB.LD_CAL_TYPE = LD.CAL_TYPE
AND ADISB.LD_SEQUENCE_NUMBER = LD.SEQUENCE_NUMBER
AND RVSN.RVSN_ID(+)= ADISB.RVSN_ID
AND ADISB.ATTENDANCE_TYPE_CODE = ATD.ATTENDANCE_TYPE (+)