View: IGFFV_ISIR_CORRECTIONS

Product:	IGF - Financial Aid
Description:	Maintains ISIR correction records
Implementation/DBA Data:	APPS.IGFFV_ISIR_CORRECTIONS

View Text

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, ISIRC.SAR_FIELD_NUMBER
, '_LA:ISIRC.CORRECTION_STATUS:IGF_LOOKUPS_VIEW:IGF_ISIR_CORR_STATUS:MEANING'
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, ISIRC.ORIGINAL_VALUE
, ISIRC.CORRECTED_VALUE
, ISIRC.BATCH_ID
, ISIRC.ISIRC_ID
, ISIRC.ISIR_ID
, ISIRC.CI_CAL_TYPE
, ISIRC.CI_SEQUENCE_NUMBER
, ISIRC.CREATED_BY
, ISIRC.CREATION_DATE
, ISIRC.LAST_UPDATED_BY
, ISIRC.LAST_UPDATE_DATE
, FA_DETAIL.PERSON_ID
FROM IGF_AP_ISIR_CORR_ALL ISIRC
, IGF_AP_ISIR_MATCHED_ALL ISIRM
, IGF_AP_FA_BASE_REC_ALL FA_DETAIL
, HZ_PARTIES HP
, IGS_CA_INST_ALL CI
WHERE ISIRC.ISIR_ID = ISIRM.ISIR_ID AND ISIRM.BASE_ID = FA_DETAIL.BASE_ID AND FA_DETAIL.PERSON_ID = HP.PARTY_ID AND ISIRC.CI_CAL_TYPE = CI.CAL_TYPE AND ISIRC.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY

Columns