VIEW: APPS.IGF_AP_INS_VERN_ITEM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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