VIEW: APPS.IGS_SV_EV_EDT_BIO_V

Source

View Text - Preformatted

SELECT bio.batch_id batch_id, bio.person_id person_id, bio.last_name last_name, bio.first_name first_name, bio.middle_name middle_name, bio.suffix suffix, bio.birth_date birth_date, bio.gender gender, bio.birth_city birth_city, bio.birth_cntry_code birth_cntry_code, bio.citizen_cntry_code citizen_cntry_code, bio.legal_res_cntry_code perm_res_cntry_code, bio.position_code position_code, bio.remarks remarks, bio.BIRTH_CNTRY_RESN_CODE, bio.PRINT_FORM FROM igs_sv_bio_info bio , igs_sv_btch_summary bioSumm WHERE bio.person_id = bioSumm.person_id AND bio.batch_id = bioSumm.batch_id AND bioSumm.TAG_CODE = 'SV_BIO' AND bioSumm.ADM_ACTION_CODE = 'SEND'

View Text - HTML Formatted

SELECT BIO.BATCH_ID BATCH_ID
, BIO.PERSON_ID PERSON_ID
, BIO.LAST_NAME LAST_NAME
, BIO.FIRST_NAME FIRST_NAME
, BIO.MIDDLE_NAME MIDDLE_NAME
, BIO.SUFFIX SUFFIX
, BIO.BIRTH_DATE BIRTH_DATE
, BIO.GENDER GENDER
, BIO.BIRTH_CITY BIRTH_CITY
, BIO.BIRTH_CNTRY_CODE BIRTH_CNTRY_CODE
, BIO.CITIZEN_CNTRY_CODE CITIZEN_CNTRY_CODE
, BIO.LEGAL_RES_CNTRY_CODE PERM_RES_CNTRY_CODE
, BIO.POSITION_CODE POSITION_CODE
, BIO.REMARKS REMARKS
, BIO.BIRTH_CNTRY_RESN_CODE
, BIO.PRINT_FORM
FROM IGS_SV_BIO_INFO BIO
, IGS_SV_BTCH_SUMMARY BIOSUMM
WHERE BIO.PERSON_ID = BIOSUMM.PERSON_ID
AND BIO.BATCH_ID = BIOSUMM.BATCH_ID
AND BIOSUMM.TAG_CODE = 'SV_BIO'
AND BIOSUMM.ADM_ACTION_CODE = 'SEND'