VIEW: APPS.IGF_AP_RW_UNMATCH_REC_V

Source

View Text - Preformatted

SELECT DISTINCT ci.alternate_code award_year, rw.record_type, rw.ci_sequence_number, rw.ci_cal_type FROM igf_ap_review_det_v rw, igs_ca_inst ci WHERE ci.sequence_number = rw.ci_sequence_number AND ci.cal_type = rw.ci_cal_type

View Text - HTML Formatted

SELECT DISTINCT CI.ALTERNATE_CODE AWARD_YEAR
, RW.RECORD_TYPE
, RW.CI_SEQUENCE_NUMBER
, RW.CI_CAL_TYPE
FROM IGF_AP_REVIEW_DET_V RW
, IGS_CA_INST CI
WHERE CI.SEQUENCE_NUMBER = RW.CI_SEQUENCE_NUMBER
AND CI.CAL_TYPE = RW.CI_CAL_TYPE