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.

[Home] [Help]

VIEW: APPS.IGS_SV_EDT_BIO_V

Source

View Text - Preformatted


SELECT bio.batch_id, bio.person_id, bio.print_form, bio.first_name, bio.last_name, bio.middle_name, bio.birth_date, bio.gender, bio.birth_cntry_code, bio.citizen_cntry_code ctznship_cntry_code, bio.commuter, bio.suffix FROM igs_sv_bio_info bio, igs_sv_btch_summary bioSumm WHERE bio.batch_id = bioSumm.batch_id and bio.person_id = bioSumm.person_id and bioSumm.TAG_CODE = 'SV_BIO' AND bioSumm.ADM_ACTION_CODE = 'SEND'

View Text - HTML Formatted

SELECT BIO.BATCH_ID
, BIO.PERSON_ID
, BIO.PRINT_FORM
, BIO.FIRST_NAME
, BIO.LAST_NAME
, BIO.MIDDLE_NAME
, BIO.BIRTH_DATE
, BIO.GENDER
, BIO.BIRTH_CNTRY_CODE
, BIO.CITIZEN_CNTRY_CODE CTZNSHIP_CNTRY_CODE
, BIO.COMMUTER
, BIO.SUFFIX
FROM IGS_SV_BIO_INFO BIO
, IGS_SV_BTCH_SUMMARY BIOSUMM
WHERE BIO.BATCH_ID = BIOSUMM.BATCH_ID
AND BIO.PERSON_ID = BIOSUMM.PERSON_ID
AND BIOSUMM.TAG_CODE = 'SV_BIO'
AND BIOSUMM.ADM_ACTION_CODE = 'SEND'