VIEW: APPS.IGF_AW_AWD_DISB_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)