VIEW: APPS.IGS_SV_CRT_DPND_BLK_V

Source

View Text - Preformatted

SELECT dpdt.batch_id, dpdt.person_id, dpdt.print_form, dpdt.last_name, dpdt.first_name, dpdt.middle_name, dpdt.suffix, dpdt.birth_date, dpdt.gender, dpdt.birth_cntry_code, dpdt.citizen_cntry_code citizenship_cntry_code, dpdt.visa_type, dpdt.relationship, dpdt.depdnt_ID, dpdt.remarks FROM igs_sv_depdnt_info dpdt, IGS_SV_BTCH_SUMMARY depSumm WHERE dpdt.depdnt_action_type = 'A' AND dpdt.person_id = depSumm.person_id and dpdt.batch_id = depSumm.batch_id and depSumm.TAG_CODE = 'SV_DEPDNT' AND depSumm.ADM_ACTION_CODE = 'SEND' AND dpdt.depdnt_ID = depSumm.owner_table_identifier

View Text - HTML Formatted

SELECT DPDT.BATCH_ID
, DPDT.PERSON_ID
, DPDT.PRINT_FORM
, DPDT.LAST_NAME
, DPDT.FIRST_NAME
, DPDT.MIDDLE_NAME
, DPDT.SUFFIX
, DPDT.BIRTH_DATE
, DPDT.GENDER
, DPDT.BIRTH_CNTRY_CODE
, DPDT.CITIZEN_CNTRY_CODE CITIZENSHIP_CNTRY_CODE
, DPDT.VISA_TYPE
, DPDT.RELATIONSHIP
, DPDT.DEPDNT_ID
, DPDT.REMARKS
FROM IGS_SV_DEPDNT_INFO DPDT
, IGS_SV_BTCH_SUMMARY DEPSUMM
WHERE DPDT.DEPDNT_ACTION_TYPE = 'A'
AND DPDT.PERSON_ID = DEPSUMM.PERSON_ID
AND DPDT.BATCH_ID = DEPSUMM.BATCH_ID
AND DEPSUMM.TAG_CODE = 'SV_DEPDNT'
AND DEPSUMM.ADM_ACTION_CODE = 'SEND'
AND DPDT.DEPDNT_ID = DEPSUMM.OWNER_TABLE_IDENTIFIER