VIEW: APPS.IGFFV_ISIR_CORRECTIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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