VIEW: APPS.IGS_FI_F_CAT_CA_INST_AS_V

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))