VIEW: APPS.IGS_SV_EDT_FINC_BLK_V

Source

View Text - Preformatted

SELECT pers.batch_id, PERS.pdso_sevis_id pdso_sevis_id, pers.person_id, fin.print_form, fin.acad_term_length academic_term, fin.tuition, fin.living_exp, fin.dependent_exp, fin.other_exp, fin.other_exp_desc other_exp_descr, fin.personal_funds, fin.school_funds, fin.school_funds_desc school_funds_descr, fin.other_funds, fin.other_funds_desc other_funds_descr, fin.empl_funds employment_funds, fin.remarks, pers.sevis_user_id sevis_user_id, ltrim(to_char(substr(pers.person_id, 1, 10), '0000000000')) person_number, pers.record_number record_number, ltrim(to_char(substr(pers.person_id, 1, 14), '00000000000000')) person_id_long , decode(pers.REPRINT_RSN_CODE,'11',null, pers.REPRINT_RSN_CODE) reprint_reason, pers.reprint_remarks FROM igs_sv_persons pers, igs_sv_finance_info fin, IGS_SV_BTCH_SUMMARY finSumm WHERE pers.record_status = 'C' AND fin.batch_id = pers.batch_id AND fin.person_id = pers.person_id AND fin.person_id = finSumm.person_id AND fin.batch_id = finSumm.batch_id AND finSumm.TAG_CODE = 'SV_FINANCIAL' AND finSumm.ADM_ACTION_CODE = 'SEND'

View Text - HTML Formatted

SELECT PERS.BATCH_ID
, PERS.PDSO_SEVIS_ID PDSO_SEVIS_ID
, PERS.PERSON_ID
, FIN.PRINT_FORM
, FIN.ACAD_TERM_LENGTH ACADEMIC_TERM
, FIN.TUITION
, FIN.LIVING_EXP
, FIN.DEPENDENT_EXP
, FIN.OTHER_EXP
, FIN.OTHER_EXP_DESC OTHER_EXP_DESCR
, FIN.PERSONAL_FUNDS
, FIN.SCHOOL_FUNDS
, FIN.SCHOOL_FUNDS_DESC SCHOOL_FUNDS_DESCR
, FIN.OTHER_FUNDS
, FIN.OTHER_FUNDS_DESC OTHER_FUNDS_DESCR
, FIN.EMPL_FUNDS EMPLOYMENT_FUNDS
, FIN.REMARKS
, PERS.SEVIS_USER_ID SEVIS_USER_ID
, LTRIM(TO_CHAR(SUBSTR(PERS.PERSON_ID
, 1
, 10)
, '0000000000')) PERSON_NUMBER
, PERS.RECORD_NUMBER RECORD_NUMBER
, LTRIM(TO_CHAR(SUBSTR(PERS.PERSON_ID
, 1
, 14)
, '00000000000000')) PERSON_ID_LONG
, DECODE(PERS.REPRINT_RSN_CODE
, '11'
, NULL
, PERS.REPRINT_RSN_CODE) REPRINT_REASON
, PERS.REPRINT_REMARKS
FROM IGS_SV_PERSONS PERS
, IGS_SV_FINANCE_INFO FIN
, IGS_SV_BTCH_SUMMARY FINSUMM
WHERE PERS.RECORD_STATUS = 'C'
AND FIN.BATCH_ID = PERS.BATCH_ID
AND FIN.PERSON_ID = PERS.PERSON_ID
AND FIN.PERSON_ID = FINSUMM.PERSON_ID
AND FIN.BATCH_ID = FINSUMM.BATCH_ID
AND FINSUMM.TAG_CODE = 'SV_FINANCIAL'
AND FINSUMM.ADM_ACTION_CODE = 'SEND'