VIEW: APPS.IGSBV_STUDENT_SPNSR_RELATIONS

Source

View Text - Preformatted

SELECT sp.ld_cal_type, sp.ld_sequence_number, sp.tot_spnsr_amount, sp.min_credit_points, sp.min_attendance_type, pa.party_number, pa.party_name, ci1.start_dt, ci1.end_dt, ci1.description, ci1.alternate_code, ap.ci_cal_type, ap.ci_sequence_number, ci2.start_dt, ci2.end_dt, ci2.description, ci2.alternate_code, aw.fund_code, aw.description, sp.spnsr_stdnt_id, sp.fund_id, sp.base_id, sp.person_id, sp.creation_date, sp.created_by, sp.last_update_date, sp.last_updated_by FROM igf_sp_stdnt_rel_all sp, hz_parties pa, igs_ca_inst_all ci1, igf_ap_fa_base_rec_all ap, igs_ca_inst_all ci2, igf_aw_fund_mast_all aw WHERE sp.fund_id = aw.fund_id AND sp.person_id = pa.party_id AND sp.base_id = ap.base_id AND sp.ld_cal_type = ci1.cal_type AND sp.ld_sequence_number = ci1.sequence_number AND ap.ci_cal_type = ci2.cal_type AND ap.ci_sequence_number = ci2.sequence_number WITH READ ONLY

View Text - HTML Formatted

SELECT SP.LD_CAL_TYPE
, SP.LD_SEQUENCE_NUMBER
, SP.TOT_SPNSR_AMOUNT
, SP.MIN_CREDIT_POINTS
, SP.MIN_ATTENDANCE_TYPE
, PA.PARTY_NUMBER
, PA.PARTY_NAME
, CI1.START_DT
, CI1.END_DT
, CI1.DESCRIPTION
, CI1.ALTERNATE_CODE
, AP.CI_CAL_TYPE
, AP.CI_SEQUENCE_NUMBER
, CI2.START_DT
, CI2.END_DT
, CI2.DESCRIPTION
, CI2.ALTERNATE_CODE
, AW.FUND_CODE
, AW.DESCRIPTION
, SP.SPNSR_STDNT_ID
, SP.FUND_ID
, SP.BASE_ID
, SP.PERSON_ID
, SP.CREATION_DATE
, SP.CREATED_BY
, SP.LAST_UPDATE_DATE
, SP.LAST_UPDATED_BY
FROM IGF_SP_STDNT_REL_ALL SP
, HZ_PARTIES PA
, IGS_CA_INST_ALL CI1
, IGF_AP_FA_BASE_REC_ALL AP
, IGS_CA_INST_ALL CI2
, IGF_AW_FUND_MAST_ALL AW
WHERE SP.FUND_ID = AW.FUND_ID
AND SP.PERSON_ID = PA.PARTY_ID
AND SP.BASE_ID = AP.BASE_ID
AND SP.LD_CAL_TYPE = CI1.CAL_TYPE
AND SP.LD_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER
AND AP.CI_CAL_TYPE = CI2.CAL_TYPE
AND AP.CI_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER WITH READ ONLY