View: IGF_AP_RW_UNMATCH_REC_V

Product:	IGF - Financial Aid
Description:	View to implement the master block in 'Review Unmacted Records' form.
Implementation/DBA Data:	APPS.IGF_AP_RW_UNMATCH_REC_V

View Text

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

Columns