VIEW: APPS.IGF_SL_DL_SETUP_V

Source

View Text - Preformatted

SELECT dlset.row_id ROW_ID ,dlset.dlset_id DLSET_ID ,dlset.ci_cal_type CI_CAL_TYPE ,dlset.ci_sequence_number CI_SEQUENCE_NUMBER ,ci.start_dt CI_START_DT ,ci.end_dt CI_END_DT ,ci.alternate_code CI_ALTERNATE_CODE ,dlset.school_id SCHOOL_ID ,dlset.orig_fee_perct_stafford ORIG_FEE_PERCT_STAFFORD ,dlset.orig_fee_perct_plus ORIG_FEE_PERCT_PLUS ,dlset.int_rebate INT_REBATE ,dlset.pnote_print_ind PNOTE_PRINT_IND ,igf_aw_gen.lookup_desc('IGF_SL_PNOTE_PRINT_IND',dlset.pnote_print_ind) PNOTE_PRINT_IND_DESC ,dlset.pnote_print_copies PNOTE_PRINT_COPIES ,dlset.acc_note_for_disb ACC_NOTE_FOR_DISB ,dlset.affirmation_reqd AFFIRMATION_REQD ,dlset.interview_reqd INTERVIEW_REQD ,dlset.disclosure_print_ind DISCLOSURE_PRINT_IND ,igf_aw_gen.lookup_desc('IGF_SL_DISCLOSURE_PRINT_IND', dlset.disclosure_print_ind) DISCLOSURE_PRINT_DESC ,dlset.special_school SPECIAL_SCHOOL ,dlset.dl_version DL_VERSION ,igf_aw_gen.lookup_desc('IGF_SL_DL_VERSION', dlset.dl_version) DL_VERSION_DESC ,dlset.created_by CREATED_BY ,dlset.creation_date CREATION_DATE ,dlset.last_updated_by LAST_UPDATED_BY ,dlset.last_update_date LAST_UPDATE_DATE ,dlset.last_update_login LAST_UPDATE_LOGIN ,dlset.RESPONSE_OPTION_CODE RESPONSE_OPTION_CODE ,IGF_AW_GEN.LOOKUP_DESC('IGF_SL_RESP_OPTIONS',DLSET.RESPONSE_OPTION_CODE) ,dlset.FUNDING_METHOD FUNDING_METHOD ,IGF_AW_GEN.LOOKUP_DESC('IGF_SL_FUNDING_METHODS',DLSET.FUNDING_METHOD) FROM igf_sl_dl_setup dlset, igs_ca_inst ci WHERE dlset.ci_cal_type = ci.cal_type AND dlset.ci_sequence_number = ci.sequence_number

View Text - HTML Formatted

SELECT DLSET.ROW_ID ROW_ID
, DLSET.DLSET_ID DLSET_ID
, DLSET.CI_CAL_TYPE CI_CAL_TYPE
, DLSET.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, CI.START_DT CI_START_DT
, CI.END_DT CI_END_DT
, CI.ALTERNATE_CODE CI_ALTERNATE_CODE
, DLSET.SCHOOL_ID SCHOOL_ID
, DLSET.ORIG_FEE_PERCT_STAFFORD ORIG_FEE_PERCT_STAFFORD
, DLSET.ORIG_FEE_PERCT_PLUS ORIG_FEE_PERCT_PLUS
, DLSET.INT_REBATE INT_REBATE
, DLSET.PNOTE_PRINT_IND PNOTE_PRINT_IND
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PNOTE_PRINT_IND'
, DLSET.PNOTE_PRINT_IND) PNOTE_PRINT_IND_DESC
, DLSET.PNOTE_PRINT_COPIES PNOTE_PRINT_COPIES
, DLSET.ACC_NOTE_FOR_DISB ACC_NOTE_FOR_DISB
, DLSET.AFFIRMATION_REQD AFFIRMATION_REQD
, DLSET.INTERVIEW_REQD INTERVIEW_REQD
, DLSET.DISCLOSURE_PRINT_IND DISCLOSURE_PRINT_IND
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_DISCLOSURE_PRINT_IND'
, DLSET.DISCLOSURE_PRINT_IND) DISCLOSURE_PRINT_DESC
, DLSET.SPECIAL_SCHOOL SPECIAL_SCHOOL
, DLSET.DL_VERSION DL_VERSION
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_DL_VERSION'
, DLSET.DL_VERSION) DL_VERSION_DESC
, DLSET.CREATED_BY CREATED_BY
, DLSET.CREATION_DATE CREATION_DATE
, DLSET.LAST_UPDATED_BY LAST_UPDATED_BY
, DLSET.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DLSET.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DLSET.RESPONSE_OPTION_CODE RESPONSE_OPTION_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_RESP_OPTIONS'
, DLSET.RESPONSE_OPTION_CODE)
, DLSET.FUNDING_METHOD FUNDING_METHOD
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_FUNDING_METHODS'
, DLSET.FUNDING_METHOD)
FROM IGF_SL_DL_SETUP DLSET
, IGS_CA_INST CI
WHERE DLSET.CI_CAL_TYPE = CI.CAL_TYPE
AND DLSET.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER