VIEW: APPS.IGF_AP_ISIR_CORRECTION_DTL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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