VIEW: APPS.IGS_SV_DROP_BLW_BLK_V

Source

View Text - Preformatted

SELECT pers.batch_id, PERS.pdso_sevis_id pdso_sevis_id, pers.person_id, prgms.print_form, prgms.authorization_reason auth_reason, prgms.prgm_start_date auth_start_date, prgms.prgm_end_date auth_end_date, prgms.remarks dbf_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_prgms_info prgms, IGS_SV_BTCH_SUMMARY authSumm WHERE pers.record_status = 'C' AND prgms.batch_id = pers.batch_id AND prgms.person_id = pers.person_id AND prgms.prgm_action_type = 'DB' AND prgms.person_id = authSumm.person_id AND prgms.batch_id = authSumm.batch_id AND authSumm.TAG_CODE = 'SV_AUTH_DROP' AND authSumm.ADM_ACTION_CODE = 'SEND'

View Text - HTML Formatted

SELECT PERS.BATCH_ID
, PERS.PDSO_SEVIS_ID PDSO_SEVIS_ID
, PERS.PERSON_ID
, PRGMS.PRINT_FORM
, PRGMS.AUTHORIZATION_REASON AUTH_REASON
, PRGMS.PRGM_START_DATE AUTH_START_DATE
, PRGMS.PRGM_END_DATE AUTH_END_DATE
, PRGMS.REMARKS DBF_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_PRGMS_INFO PRGMS
, IGS_SV_BTCH_SUMMARY AUTHSUMM
WHERE PERS.RECORD_STATUS = 'C'
AND PRGMS.BATCH_ID = PERS.BATCH_ID
AND PRGMS.PERSON_ID = PERS.PERSON_ID
AND PRGMS.PRGM_ACTION_TYPE = 'DB'
AND PRGMS.PERSON_ID = AUTHSUMM.PERSON_ID
AND PRGMS.BATCH_ID = AUTHSUMM.BATCH_ID
AND AUTHSUMM.TAG_CODE = 'SV_AUTH_DROP'
AND AUTHSUMM.ADM_ACTION_CODE = 'SEND'