VIEW: APPS.IGFBV_VERIFICATION_WORKSHEETS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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