VIEW: APPS.IGS_SV_EV_UPD_FIN_BLK_V

Source

View Text - Preformatted

SELECT pers.batch_id batch_id, PERS.pdso_sevis_id pdso_sevis_id, pers.person_id person_id, finc.recvd_us_gvt_funds received_us_gov_funds, finc.program_sponsor current_program_sponsor, finc.govt_org1_code govt_org1, finc.govt_org1 govt_org1_amount, finc.govt_org2_code govt_org2, finc.govt_org2 govt_org2_amount, finc.intl_org1_code internat_org1, finc.intl_org1 internat_org1_amount, finc.intl_org2_code internat_org2, finc.intl_org2 internat_org2_amount, finc.ev_govt ev_govt, finc.bi_natnl_com binational_commission, finc.other_org other_org, finc.personal_funds personal_funds, finc.remarks financial_remarks, finc.GOVT_ORG1_OTHR_NAME, finc.GOVT_ORG2_OTHR_NAME, finc.INTL_ORG1_OTHR_NAME, finc.INTL_ORG2_OTHR_NAME, finc.OTHER_GOVT_NAME , pers.print_form print_form, pers.sevis_user_id sevis_user_id, pers.record_number record_number, ltrim(to_char(substr(pers.person_id, 1, 10), '0000000000')) person_number, ltrim(to_char(substr(pers.person_id, 1, 14), '00000000000000')) person_id_long, pers.REPRINT_RSN_CODE REPRINT_REASON , DECODE(pers.REPRINT_RSN_CODE,'05',NULL, pers.REPRINT_REMARKS) REPRINT_REMARKS, DECODE(pers.REPRINT_RSN_CODE,'05', pers.REPRINT_REMARKS,NULL) OTHER_REMARKS FROM igs_sv_persons pers, igs_sv_finance_info finc , IGS_SV_BTCH_SUMMARY finSumm WHERE pers.record_status = 'C' AND finc.batch_id = pers.batch_id AND finc.person_id = pers.person_id AND finc.person_id = finSumm.person_id and finc.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 BATCH_ID
, PERS.PDSO_SEVIS_ID PDSO_SEVIS_ID
, PERS.PERSON_ID PERSON_ID
, FINC.RECVD_US_GVT_FUNDS RECEIVED_US_GOV_FUNDS
, FINC.PROGRAM_SPONSOR CURRENT_PROGRAM_SPONSOR
, FINC.GOVT_ORG1_CODE GOVT_ORG1
, FINC.GOVT_ORG1 GOVT_ORG1_AMOUNT
, FINC.GOVT_ORG2_CODE GOVT_ORG2
, FINC.GOVT_ORG2 GOVT_ORG2_AMOUNT
, FINC.INTL_ORG1_CODE INTERNAT_ORG1
, FINC.INTL_ORG1 INTERNAT_ORG1_AMOUNT
, FINC.INTL_ORG2_CODE INTERNAT_ORG2
, FINC.INTL_ORG2 INTERNAT_ORG2_AMOUNT
, FINC.EV_GOVT EV_GOVT
, FINC.BI_NATNL_COM BINATIONAL_COMMISSION
, FINC.OTHER_ORG OTHER_ORG
, FINC.PERSONAL_FUNDS PERSONAL_FUNDS
, FINC.REMARKS FINANCIAL_REMARKS
, FINC.GOVT_ORG1_OTHR_NAME
, FINC.GOVT_ORG2_OTHR_NAME
, FINC.INTL_ORG1_OTHR_NAME
, FINC.INTL_ORG2_OTHR_NAME
, FINC.OTHER_GOVT_NAME
, PERS.PRINT_FORM PRINT_FORM
, PERS.SEVIS_USER_ID SEVIS_USER_ID
, PERS.RECORD_NUMBER RECORD_NUMBER
, LTRIM(TO_CHAR(SUBSTR(PERS.PERSON_ID
, 1
, 10)
, '0000000000')) PERSON_NUMBER
, LTRIM(TO_CHAR(SUBSTR(PERS.PERSON_ID
, 1
, 14)
, '00000000000000')) PERSON_ID_LONG
, PERS.REPRINT_RSN_CODE REPRINT_REASON
, DECODE(PERS.REPRINT_RSN_CODE
, '05'
, NULL
, PERS.REPRINT_REMARKS) REPRINT_REMARKS
, DECODE(PERS.REPRINT_RSN_CODE
, '05'
, PERS.REPRINT_REMARKS
, NULL) OTHER_REMARKS
FROM IGS_SV_PERSONS PERS
, IGS_SV_FINANCE_INFO FINC
, IGS_SV_BTCH_SUMMARY FINSUMM
WHERE PERS.RECORD_STATUS = 'C'
AND FINC.BATCH_ID = PERS.BATCH_ID
AND FINC.PERSON_ID = PERS.PERSON_ID
AND FINC.PERSON_ID = FINSUMM.PERSON_ID
AND FINC.BATCH_ID = FINSUMM.BATCH_ID
AND FINSUMM.TAG_CODE = 'SV_FINANCIAL'
AND FINSUMM.ADM_ACTION_CODE = 'SEND'