VIEW: APPS.IGS_SV_EV_VALDTE_DUM_V

Source

View Text - Preformatted

SELECT pers.batch_id batch_id, PERS.pdso_sevis_id pdso_sevis_id, pers.person_id person_id, 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, DECODE(pers.REPRINT_RSN_CODE,'05', pers.REPRINT_REMARKS,NULL) other_remarks FROM igs_sv_persons pers WHERE pers.record_status = 'C' AND EXISTS ( SELECT 1 FROM igs_sv_btch_summary summ WHERE summ.person_id = pers.person_id AND summ.batch_id = pers.batch_id AND summ.TAG_CODE IN ('SV_LEGAL', 'SV_US_ADDR') AND summ.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
, 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
, DECODE(PERS.REPRINT_RSN_CODE
, '05'
, PERS.REPRINT_REMARKS
, NULL) OTHER_REMARKS
FROM IGS_SV_PERSONS PERS
WHERE PERS.RECORD_STATUS = 'C'
AND EXISTS ( SELECT 1
FROM IGS_SV_BTCH_SUMMARY SUMM
WHERE SUMM.PERSON_ID = PERS.PERSON_ID
AND SUMM.BATCH_ID = PERS.BATCH_ID
AND SUMM.TAG_CODE IN ('SV_LEGAL'
, 'SV_US_ADDR')
AND SUMM.ADM_ACTION_CODE = 'SEND' )