Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_AP_INS_VERN_ITEM_V |
SELECT IVI.ROW_ID ROW_ID
, IVI.BASE_ID
, NULL
, LKUP.MEANING
, IVI.ISIR_MAP_COL
, NULL
, NULL
, NULL
, IVI.ITEM_VALUE
, IVI.WAIVE_FLAG
, IVI.LEGACY_RECORD_FLAG
, IVI.CREATED_BY
, IVI.CREATION_DATE
, IVI.LAST_UPDATED_BY
, IVI.LAST_UPDATE_DATE
, IVI.LAST_UPDATE_LOGIN
, IVI. INCL_IN_TOLERANCE
FROM IGF_AP_INST_VER_ITEM IVI
, IGF_AP_FA_BASE_REC_ALL FABASE
, IGF_AP_BATCH_AW_MAP MAP
, IGF_FC_SAR_CD_MST SAR
, IGF_LOOKUPS_VIEW LKUP
WHERE FABASE.BASE_ID = IVI.BASE_ID
AND MAP.CI_CAL_TYPE = FABASE.CI_CAL_TYPE
AND MAP.CI_SEQUENCE_NUMBER = FABASE.CI_SEQUENCE_NUMBER
AND SAR.SYS_AWARD_YEAR = MAP.SYS_AWARD_YEAR
AND SAR.SAR_FIELD_NUMBER = IVI.ISIR_MAP_COL
AND LKUP.LOOKUP_TYPE = 'IGF_AP_SAR_FIELD_MAP'
AND LKUP.LOOKUP_CODE = SAR.SAR_FIELD_NAME