This view represents the columns of the fee_cat_cal_instance table as well as including columns representing the start and end dates from the cal_instance table. It returns only those records which have a system status of 'ACTIVE'. It is
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT FCCI.FEE_CAL_TYPE , FCCI.FEE_CI_SEQUENCE_NUMBER , FCCI.FEE_CAT , FCCI.FEE_CAT_CI_STATUS , CI.START_DT , CI.END_DT , FCCI.CREATED_BY , FCCI.CREATION_DATE , FCCI.LAST_UPDATED_BY , FCCI.LAST_UPDATE_DATE , FCCI.LAST_UPDATE_LOGIN FROM IGS_CA_INST CI , IGS_FI_F_CAT_CA_INST FCCI WHERE FCCI.FEE_CAL_TYPE = CI.CAL_TYPE AND FCCI.FEE_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND FCCI.FEE_CAT_CI_STATUS IN (SELECT FSS.FEE_STRUCTURE_STATUS FROM IGS_FI_FEE_STR_STAT FSS WHERE FSS.FEE_STRUCTURE_STATUS = FCCI.FEE_CAT_CI_STATUS AND FSS.S_FEE_STRUCTURE_STATUS = 'ACTIVE') AND FCCI.FEE_CAL_TYPE IN (SELECT FCFL.FEE_CAL_TYPE FROM IGS_FI_F_CAT_FEE_LBL FCFL WHERE FCFL.FEE_CAL_TYPE = FCCI.FEE_CAL_TYPE AND FCFL.FEE_CI_SEQUENCE_NUMBER = FCCI.FEE_CI_SEQUENCE_NUMBER AND FCFL.FEE_CAT = FCCI.FEE_CAT AND FCFL.FEE_LIABILITY_STATUS IN (SELECT FSS.FEE_STRUCTURE_STATUS FROM IGS_FI_FEE_STR_STAT FSS WHERE FSS.FEE_STRUCTURE_STATUS = FCFL.FEE_LIABILITY_STATUS AND FSS.S_FEE_STRUCTURE_STATUS = 'ACTIVE'))
[Home] [Help]