VIEW: APPS.IGS_SV_EV_ADD_DPD_BLK_V

Source

View Text - Preformatted

SELECT dpdt.batch_id batch_id, dpdt.person_id person_id, dpdt.last_name last_name, dpdt.first_name first_name, dpdt.middle_name middle_name, dpdt.suffix suffix, dpdt.birth_date birth_date, dpdt.gender gender, dpdt.birth_city birth_city, dpdt.birth_cntry_code birth_cntry_code, dpdt.citizen_cntry_code citizenship_cntry_code, dpdt.legal_res_cntry_code perm_residency_code, dpdt.relationship relationship, dpdt.depdnt_ID depdnt_id, dpdt.remarks remarks, ltrim(to_char(substr(dpdt.depdnt_ID, 1, 10), '0000000000')) person_number, ltrim(to_char(substr(dpdt.depdnt_ID, 1, 14), '00000000000000')) person_id_long, dpdt.BIRTH_CNTRY_RESN_CODE FROM igs_sv_depdnt_info dpdt WHERE dpdt.depdnt_action_type = 'A'

View Text - HTML Formatted

SELECT DPDT.BATCH_ID BATCH_ID
, DPDT.PERSON_ID PERSON_ID
, DPDT.LAST_NAME LAST_NAME
, DPDT.FIRST_NAME FIRST_NAME
, DPDT.MIDDLE_NAME MIDDLE_NAME
, DPDT.SUFFIX SUFFIX
, DPDT.BIRTH_DATE BIRTH_DATE
, DPDT.GENDER GENDER
, DPDT.BIRTH_CITY BIRTH_CITY
, DPDT.BIRTH_CNTRY_CODE BIRTH_CNTRY_CODE
, DPDT.CITIZEN_CNTRY_CODE CITIZENSHIP_CNTRY_CODE
, DPDT.LEGAL_RES_CNTRY_CODE PERM_RESIDENCY_CODE
, DPDT.RELATIONSHIP RELATIONSHIP
, DPDT.DEPDNT_ID DEPDNT_ID
, DPDT.REMARKS REMARKS
, LTRIM(TO_CHAR(SUBSTR(DPDT.DEPDNT_ID
, 1
, 10)
, '0000000000')) PERSON_NUMBER
, LTRIM(TO_CHAR(SUBSTR(DPDT.DEPDNT_ID
, 1
, 14)
, '00000000000000')) PERSON_ID_LONG
, DPDT.BIRTH_CNTRY_RESN_CODE
FROM IGS_SV_DEPDNT_INFO DPDT
WHERE DPDT.DEPDNT_ACTION_TYPE = 'A'