eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGS_SV_EV_CRT_BIO_V

Source

View Text - Preformatted


SELECT bio.batch_id, bio.person_id, bio.last_name ev_last_name, bio.first_name ev_first_name, bio.middle_name ev_middle_name, bio.suffix ev_suffix, bio.birth_date ev_birth_date, bio.gender ev_gender, bio.birth_city ev_birth_city, bio.birth_cntry_code ev_birth_cntry_code, bio.citizen_cntry_code ev_citizen_cntry_code, bio.legal_res_cntry_code ev_perm_res_cntry_code, bio.visa_type ev_visa_type, bio.category_code category_code, bio.BIRTH_CNTRY_RESN_CODE from igs_sv_bio_info bio

View Text - HTML Formatted

SELECT BIO.BATCH_ID
, BIO.PERSON_ID
, BIO.LAST_NAME EV_LAST_NAME
, BIO.FIRST_NAME EV_FIRST_NAME
, BIO.MIDDLE_NAME EV_MIDDLE_NAME
, BIO.SUFFIX EV_SUFFIX
, BIO.BIRTH_DATE EV_BIRTH_DATE
, BIO.GENDER EV_GENDER
, BIO.BIRTH_CITY EV_BIRTH_CITY
, BIO.BIRTH_CNTRY_CODE EV_BIRTH_CNTRY_CODE
, BIO.CITIZEN_CNTRY_CODE EV_CITIZEN_CNTRY_CODE
, BIO.LEGAL_RES_CNTRY_CODE EV_PERM_RES_CNTRY_CODE
, BIO.VISA_TYPE EV_VISA_TYPE
, BIO.CATEGORY_CODE CATEGORY_CODE
, BIO.BIRTH_CNTRY_RESN_CODE
FROM IGS_SV_BIO_INFO BIO