View: IGFFV_VERIFICATION_WORKSHEETS

Product:	IGF - Financial Aid
Description:	Full View for the Entity that holds the information about the verification values for all user-defined ISIR fields
Implementation/DBA Data:	APPS.IGFFV_VERIFICATION_WORKSHEETS

View Text

SELECT HZ_PARTIES.PARTY_NUMBER
, HZ_PARTIES.PARTY_NAME
, IVI.ITEM_VALUE
, '_LA:IVI.WAIVE_FLAG:IGF_LOOKUPS_VIEW:YES_NO:MEANING'
, IVI.ISIR_MAP_COL
, '_LA:SARCD.SAR_FIELD_NAME:IGF_LOOKUPS_VIEW:IGF_AP_SAR_FIELD_MAP:MEANING'
, '_LA:IVI.INCL_IN_TOLERANCE:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:IVI.LEGACY_RECORD_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:IVI.USE_BLANK_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, FA_DETAIL.CI_CAL_TYPE
, FA_DETAIL.CI_SEQUENCE_NUMBER
, IVI.UDF_VERN_ITEM_SEQ_NUM
, IVI.BASE_ID
, FA_DETAIL.PERSON_ID
, IVI.CREATED_BY
, IVI.CREATION_DATE
, IVI.LAST_UPDATED_BY
, IVI.LAST_UPDATE_DATE
FROM IGF_AP_INST_VER_ITEM_ALL IVI
, IGF_AP_FA_BASE_REC_ALL FA_DETAIL
, IGF_FC_SAR_CD_MST SARCD
, IGS_CA_INST_ALL CI
, HZ_PARTIES HZ_PARTIES
, IGF_AP_BATCH_AW_MAP_ALL BAM
WHERE IVI.BASE_ID = FA_DETAIL.BASE_ID
AND FA_DETAIL.PERSON_ID = HZ_PARTIES.PARTY_ID
AND FA_DETAIL.CI_CAL_TYPE = CI.CAL_TYPE
AND FA_DETAIL.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND IVI.ISIR_MAP_COL = SARCD.SAR_FIELD_NUMBER
AND SARCD.SYS_AWARD_YEAR = BAM.SYS_AWARD_YEAR
AND BAM.CI_CAL_TYPE = FA_DETAIL.CI_CAL_TYPE
AND BAM.CI_SEQUENCE_NUMBER = FA_DETAIL.CI_SEQUENCE_NUMBER WITH READ ONLY

Columns