Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_AP_PERSON_MATCH_V |
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'