VIEW: APPS.IGF_AW_FISAP_REPSET_V

Source

View Text - Preformatted

SELECT A.ROWID , A.CATEGORY_ID , A.FISAP_SECTION, A.DEPEND_STAT, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_FISAP_DEPEND', A.DEPEND_STAT), A.CLASS_STANDING, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_FISAP_CLASS_STG', A.CLASS_STANDING), A.CI_CAL_TYPE, A.CI_SEQUENCE_NUMBER, CI.ALTERNATE_CODE, CI.START_DT, CI.END_DT, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN FROM IGF_AW_FISAP_REPSET A, IGS_CA_INST CI WHERE A.FISAP_SECTION IN ('SECTION_II','SECTION_VI') AND CI.CAL_TYPE =A.CI_CAL_TYPE AND CI.SEQUENCE_NUMBER =A.CI_SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT A.ROWID
, A.CATEGORY_ID
, A.FISAP_SECTION
, A.DEPEND_STAT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_FISAP_DEPEND'
, A.DEPEND_STAT)
, A.CLASS_STANDING
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_FISAP_CLASS_STG'
, A.CLASS_STANDING)
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
FROM IGF_AW_FISAP_REPSET A
, IGS_CA_INST CI
WHERE A.FISAP_SECTION IN ('SECTION_II'
, 'SECTION_VI')
AND CI.CAL_TYPE =A.CI_CAL_TYPE
AND CI.SEQUENCE_NUMBER =A.CI_SEQUENCE_NUMBER