VIEW: APPS.IGF_AP_PERSON_MATCH_V

Source

View Text - Preformatted

SELECT apm.apm_id, amd.amd_id, apm.css_id, apm.si_id, apm.record_type, apm.date_run, apm.ci_cal_type, apm.ci_sequence_number, amd.person_id, pe.person_last_name||','||person_first_name name, amd.ssn_match, amd.given_name_match, amd.surname_match , amd.dob_match, amd.address_match, amd.city_match, amd.zip_match, amd.match_score, amd.record_status, amd.created_by, amd.creation_date, amd.last_updated_by, amd.last_update_date, amd.last_update_login, pe.party_number FROM igf_ap_person_match apm , igf_ap_match_details amd , hz_parties pe WHERE apm.apm_id = amd.apm_id AND pe.party_id = amd.person_id AND apm.record_status = 'REVIEW'

View Text - HTML Formatted

SELECT APM.APM_ID
, AMD.AMD_ID
, APM.CSS_ID
, APM.SI_ID
, APM.RECORD_TYPE
, APM.DATE_RUN
, APM.CI_CAL_TYPE
, APM.CI_SEQUENCE_NUMBER
, AMD.PERSON_ID
, PE.PERSON_LAST_NAME||'
, '||PERSON_FIRST_NAME NAME
, AMD.SSN_MATCH
, AMD.GIVEN_NAME_MATCH
, AMD.SURNAME_MATCH
, AMD.DOB_MATCH
, AMD.ADDRESS_MATCH
, AMD.CITY_MATCH
, AMD.ZIP_MATCH
, AMD.MATCH_SCORE
, AMD.RECORD_STATUS
, AMD.CREATED_BY
, AMD.CREATION_DATE
, AMD.LAST_UPDATED_BY
, AMD.LAST_UPDATE_DATE
, AMD.LAST_UPDATE_LOGIN
, PE.PARTY_NUMBER
FROM IGF_AP_PERSON_MATCH APM
, IGF_AP_MATCH_DETAILS AMD
, HZ_PARTIES PE
WHERE APM.APM_ID = AMD.APM_ID
AND PE.PARTY_ID = AMD.PERSON_ID
AND APM.RECORD_STATUS = 'REVIEW'