VIEW: APPS.IGF_DB_AWD_DISB_V

Source

View Text - Preformatted

SELECT adisb.row_id ROW_ID, awdv.award_id AWARD_ID, adisb.disb_num DISB_NUM, awdv.base_id BASE_ID, awdv.ci_cal_type CI_CAL_TYPE, awdv.ci_sequence_number CI_SEQUENCE_NUMBER, awdv.ci_alternate_code CI_ALTERNATE_CODE, awdv.ci_start_dt CI_START_DT, awdv.ci_end_dt CI_END_DT, awdv.student_id STUDENT_ID, awdv.person_number PERSON_NUMBER, awdv.ssn SSN, awdv.full_name FULL_NAME, awdv.fund_id FUND_ID, awdv.description FUND_DESCRIPTION, awdv.fund_code FUND_CODE, awdv.fund_type FUND_TYPE, awdv.fed_fund_code FED_FUND_CODE, awdv.sys_fund_type SYS_FUND_TYPE, awdv.offered_amt OFFERED_AMT, awdv.accepted_amt ACCEPTED_AMT, awdv.rules_override RULES_OVERRIDE, adisb.tp_cal_type TP_CAL_TYPE, adisb.tp_sequence_number TP_SEQUENCE_NUMBER, adisb.disb_gross_amt DISB_GROSS_AMT, adisb.fee_1 FEE_1, adisb.fee_2 FEE_2, adisb.disb_net_amt DISB_NET_AMT, adisb.disb_date DISB_DATE, adisb.trans_type TRANS_TYPE, adisb.elig_status ELIG_STATUS, adisb.elig_status_date ELIG_STATUS_DATE, adisb.affirm_flag AFFIRM_FLAG, adisb.manual_hold_ind MANUAL_HOLD_IND, adisb.hold_rel_ind HOLD_REL_IND, adisb.disb_status DISB_STATUS, adisb.disb_status_date DISB_STATUS_DATE, adisb.late_disb_ind LATE_DISB_IND, adisb.fund_dist_mthd FUND_DIST_MTHD, adisb.prev_reported_ind PREV_REPORTED_IND, adisb.fund_release_date FUND_RELEASE_DATE, adisb.fund_status FUND_STATUS, adisb.fund_status_date FUND_STATUS_DATE, adisb.cheque_number CHEQUE_NUMBER, adisb.fee_paid_1 FEE_PAID_1, adisb.fee_paid_2 FEE_PAID_2, adisb.created_by CREATED_BY, adisb.creation_date CREATION_DATE, adisb.last_updated_by LAST_UPDATED_BY, adisb.last_update_date LAST_UPDATE_DATE, adisb.last_update_login LAST_UPDATE_LOGIN, adisb.request_id REQUEST_ID, adisb.program_application_id PROGRAM_APPLICATION_ID, adisb.program_id PROGRAM_ID, adisb.program_update_date PROGRAM_UPDATE_DATE, AWDV.AWARD_STATUS, ADISB.DISB_EXP_DT, ADISB.VERF_ENFR_DT, ADISB.FORCE_DISB, ADISB.MIN_CREDIT_PTS, adisb.ld_cal_type, adisb.ld_sequence_number, adisb.paid_amt, adisb.ld_start_dt, adisb.ld_end_dt, adisb.tp_start_dt, adisb.tp_end_dt, adisb.ld_alternate_code, adisb.tp_alternate_code FROM igf_aw_award_v awdv, igf_aw_awd_disb_v adisb WHERE awdv.award_id = adisb.award_id

View Text - HTML Formatted

SELECT ADISB.ROW_ID ROW_ID
, AWDV.AWARD_ID AWARD_ID
, ADISB.DISB_NUM DISB_NUM
, AWDV.BASE_ID BASE_ID
, AWDV.CI_CAL_TYPE CI_CAL_TYPE
, AWDV.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, AWDV.CI_ALTERNATE_CODE CI_ALTERNATE_CODE
, AWDV.CI_START_DT CI_START_DT
, AWDV.CI_END_DT CI_END_DT
, AWDV.STUDENT_ID STUDENT_ID
, AWDV.PERSON_NUMBER PERSON_NUMBER
, AWDV.SSN SSN
, AWDV.FULL_NAME FULL_NAME
, AWDV.FUND_ID FUND_ID
, AWDV.DESCRIPTION FUND_DESCRIPTION
, AWDV.FUND_CODE FUND_CODE
, AWDV.FUND_TYPE FUND_TYPE
, AWDV.FED_FUND_CODE FED_FUND_CODE
, AWDV.SYS_FUND_TYPE SYS_FUND_TYPE
, AWDV.OFFERED_AMT OFFERED_AMT
, AWDV.ACCEPTED_AMT ACCEPTED_AMT
, AWDV.RULES_OVERRIDE RULES_OVERRIDE
, ADISB.TP_CAL_TYPE TP_CAL_TYPE
, ADISB.TP_SEQUENCE_NUMBER TP_SEQUENCE_NUMBER
, ADISB.DISB_GROSS_AMT DISB_GROSS_AMT
, ADISB.FEE_1 FEE_1
, ADISB.FEE_2 FEE_2
, ADISB.DISB_NET_AMT DISB_NET_AMT
, ADISB.DISB_DATE DISB_DATE
, ADISB.TRANS_TYPE TRANS_TYPE
, ADISB.ELIG_STATUS ELIG_STATUS
, ADISB.ELIG_STATUS_DATE ELIG_STATUS_DATE
, ADISB.AFFIRM_FLAG AFFIRM_FLAG
, ADISB.MANUAL_HOLD_IND MANUAL_HOLD_IND
, ADISB.HOLD_REL_IND HOLD_REL_IND
, ADISB.DISB_STATUS DISB_STATUS
, ADISB.DISB_STATUS_DATE DISB_STATUS_DATE
, ADISB.LATE_DISB_IND LATE_DISB_IND
, ADISB.FUND_DIST_MTHD FUND_DIST_MTHD
, ADISB.PREV_REPORTED_IND PREV_REPORTED_IND
, ADISB.FUND_RELEASE_DATE FUND_RELEASE_DATE
, ADISB.FUND_STATUS FUND_STATUS
, ADISB.FUND_STATUS_DATE FUND_STATUS_DATE
, ADISB.CHEQUE_NUMBER CHEQUE_NUMBER
, ADISB.FEE_PAID_1 FEE_PAID_1
, ADISB.FEE_PAID_2 FEE_PAID_2
, ADISB.CREATED_BY CREATED_BY
, ADISB.CREATION_DATE CREATION_DATE
, ADISB.LAST_UPDATED_BY LAST_UPDATED_BY
, ADISB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ADISB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ADISB.REQUEST_ID REQUEST_ID
, ADISB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ADISB.PROGRAM_ID PROGRAM_ID
, ADISB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AWDV.AWARD_STATUS
, ADISB.DISB_EXP_DT
, ADISB.VERF_ENFR_DT
, ADISB.FORCE_DISB
, ADISB.MIN_CREDIT_PTS
, ADISB.LD_CAL_TYPE
, ADISB.LD_SEQUENCE_NUMBER
, ADISB.PAID_AMT
, ADISB.LD_START_DT
, ADISB.LD_END_DT
, ADISB.TP_START_DT
, ADISB.TP_END_DT
, ADISB.LD_ALTERNATE_CODE
, ADISB.TP_ALTERNATE_CODE
FROM IGF_AW_AWARD_V AWDV
, IGF_AW_AWD_DISB_V ADISB
WHERE AWDV.AWARD_ID = ADISB.AWARD_ID