Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_AP_ISIR_CORRECTION_DTL_V |
SELECT IC.ROW_ID
, IC.ISIR_ID
, IC.ISIRC_ID
, IC.CI_SEQUENCE_NUMBER
, IC.CI_CAL_TYPE
, IC.SAR_FIELD_NUMBER
, LKUP.MEANING
, IC.ORIGINAL_VALUE
, IC.CORRECTED_VALUE
, IC.BATCH_ID
, IC.CORRECTION_STATUS
, FLK1.MEANING
, IC.CREATED_BY
, IC.CREATION_DATE
, IC.LAST_UPDATED_BY
, IC.LAST_UPDATE_DATE
, IC.LAST_UPDATE_LOGIN
FROM IGF_AP_ISIR_CORR IC
, IGF_LOOKUPS_VIEW FLK1
, IGF_AP_BATCH_AW_MAP MAP
, IGF_FC_SAR_CD_MST SAR
, IGF_LOOKUPS_VIEW LKUP
WHERE FLK1.LOOKUP_TYPE = 'IGF_CORR_STATUS'
AND FLK1.LOOKUP_CODE = IC.CORRECTION_STATUS
AND MAP.CI_CAL_TYPE = IC.CI_CAL_TYPE
AND MAP.CI_SEQUENCE_NUMBER = IC.CI_SEQUENCE_NUMBER
AND SAR.SYS_AWARD_YEAR = MAP.SYS_AWARD_YEAR
AND SAR.SAR_FIELD_NUMBER = IC.SAR_FIELD_NUMBER
AND LKUP.LOOKUP_TYPE = 'IGF_AP_SAR_FIELD_MAP'
AND LKUP.LOOKUP_CODE = SAR.SAR_FIELD_NAME