VIEW: APPS.IGF_AP_REVIEW_DET_V

Source

View Text - Preformatted

SELECT si.current_ssn ssn,si.si_id, pm.apm_id, si.last_name||','||si.first_name student_name, pm.date_run, pm.ci_sequence_number, pm.ci_cal_type ,pm.record_type FROM igf_ap_person_match pm, igf_ap_isir_intrface si WHERE pm.si_id = si.si_id and pm.record_status = 'REVIEW' and pm.record_type = 'ISIR' UNION select ci.social_security_number ssn,ci.css_id si_id , pm.apm_id, ci.last_name||','||ci.first_name student_name, pm.date_run, pm.ci_sequence_number, pm.ci_cal_type,pm.record_type FROM igf_ap_person_match pm, igf_ap_css_interface ci where pm.css_id = ci.css_id and pm.record_status = 'REVIEW' and pm.record_type = 'PROFILE'

View Text - HTML Formatted

SELECT SI.CURRENT_SSN SSN
, SI.SI_ID
, PM.APM_ID
, SI.LAST_NAME||'
, '||SI.FIRST_NAME STUDENT_NAME
, PM.DATE_RUN
, PM.CI_SEQUENCE_NUMBER
, PM.CI_CAL_TYPE
, PM.RECORD_TYPE
FROM IGF_AP_PERSON_MATCH PM
, IGF_AP_ISIR_INTRFACE SI
WHERE PM.SI_ID = SI.SI_ID
AND PM.RECORD_STATUS = 'REVIEW'
AND PM.RECORD_TYPE = 'ISIR' UNION SELECT CI.SOCIAL_SECURITY_NUMBER SSN
, CI.CSS_ID SI_ID
, PM.APM_ID
, CI.LAST_NAME||'
, '||CI.FIRST_NAME STUDENT_NAME
, PM.DATE_RUN
, PM.CI_SEQUENCE_NUMBER
, PM.CI_CAL_TYPE
, PM.RECORD_TYPE
FROM IGF_AP_PERSON_MATCH PM
, IGF_AP_CSS_INTERFACE CI
WHERE PM.CSS_ID = CI.CSS_ID
AND PM.RECORD_STATUS = 'REVIEW'
AND PM.RECORD_TYPE = 'PROFILE'