VIEW: APPS.IGS_FI_FEE_RET_SCHD_F_TYPE_V

Source

View Text - Preformatted

SELECT frsv.fee_cal_type, frsv.fee_ci_sequence_number, frsv.s_relation_type, frsv.FEE_TYPE, frsv.FEE_CAT, frsv.schedule_number, frsv.DT_ALIAS, frsv.dai_sequence_number, frsv.start_dt, frsv.end_dt, frsv.retention_percentage, frsv.retention_amount, frsv.deduction_amount, frsv.currency_cd, frsv.created_by, frsv.creation_date, frsv.last_updated_by, frsv.last_update_date, frsv.last_update_login FROM IGS_FI_FEE_RET_SCHD_V frsv, IGS_FI_F_CAT_FEE_LBL fcfl, IGS_FI_FEE_TYPE ft WHERE frsv.s_relation_type = 'FCFL' AND fcfl.FEE_CAT = frsv.FEE_CAT AND fcfl.fee_cal_type = frsv.fee_cal_type AND fcfl.fee_ci_sequence_number = frsv.fee_ci_sequence_number AND fcfl.FEE_TYPE = frsv.FEE_TYPE AND ft.FEE_TYPE = fcfl.FEE_TYPE AND ft.s_fee_trigger_cat != 'INSTITUTN' AND ft.s_fee_type != 'HECS' UNION SELECT frsv.fee_cal_type, frsv.fee_ci_sequence_number, frsv.s_relation_type, frsv.FEE_TYPE, fcfl.FEE_CAT, frsv.schedule_number, frsv.DT_ALIAS, frsv.dai_sequence_number, frsv.start_dt, frsv.end_dt, frsv.retention_percentage, frsv.retention_amount, frsv.deduction_amount, frsv.currency_cd, frsv.created_by, frsv.creation_date, frsv.last_updated_by, frsv.last_update_date, frsv.last_update_login FROM IGS_FI_FEE_RET_SCHD_V frsv, IGS_FI_F_CAT_FEE_LBL fcfl WHERE frsv.s_relation_type = 'FTCI' and fcfl.FEE_TYPE = frsv.FEE_TYPE AND fcfl.fee_cal_type = frsv.fee_cal_type AND fcfl.fee_ci_sequence_number = frsv.fee_ci_sequence_number AND 0 = (SELECT count(*) FROM IGS_FI_FEE_RET_SCHD frs WHERE frs.fee_cal_type = frsv.fee_cal_type AND frs.fee_ci_sequence_number = frsv.fee_ci_sequence_number AND frs.s_relation_type = 'FCFL' AND frs.FEE_TYPE = fcfl.FEE_TYPE AND frs.FEE_CAT = frsv.FEE_CAT) UNION SELECT frsv.fee_cal_type, frsv.fee_ci_sequence_number, frsv.s_relation_type, fcfl.FEE_TYPE, frsv.FEE_CAT, frsv.schedule_number, frsv.DT_ALIAS, frsv.dai_sequence_number, frsv.start_dt, frsv.end_dt, frsv.retention_percentage, frsv.retention_amount, frsv.deduction_amount, frsv.currency_cd, frsv.created_by, frsv.creation_date, frsv.last_updated_by, frsv.last_update_date, frsv.last_update_login FROM IGS_FI_FEE_RET_SCHD_V frsv, IGS_FI_F_CAT_FEE_LBL fcfl, IGS_FI_FEE_TYPE ft WHERE frsv.s_relation_type = 'FCCI' AND fcfl.fee_cal_type = frsv.fee_cal_type AND fcfl.fee_ci_sequence_number = frsv.fee_ci_sequence_number AND fcfl.FEE_CAT = frsv.FEE_CAT AND 0 = (SELECT count(*) FROM IGS_FI_FEE_RET_SCHD frs WHERE frs.fee_cal_type = frsv.fee_cal_type AND frs.fee_ci_sequence_number = frsv.fee_ci_sequence_number AND frs.s_relation_type = 'FCFL' AND frs.FEE_TYPE = fcfl.FEE_TYPE AND frs.FEE_CAT = fcfl.FEE_CAT) AND ft.FEE_TYPE = fcfl.FEE_TYPE AND ft.s_fee_trigger_cat != 'INSTITUTN' AND ft.s_fee_type != 'HECS' AND 0 = (SELECT count(*) FROM IGS_FI_FEE_RET_SCHD frs1 WHERE frs1.fee_cal_type = frsv.fee_cal_type AND frs1.fee_ci_sequence_number = frsv.fee_ci_sequence_number AND frs1.s_relation_type = 'FTCI' AND frs1.FEE_TYPE = fcfl.FEE_TYPE)

View Text - HTML Formatted

SELECT FRSV.FEE_CAL_TYPE
, FRSV.FEE_CI_SEQUENCE_NUMBER
, FRSV.S_RELATION_TYPE
, FRSV.FEE_TYPE
, FRSV.FEE_CAT
, FRSV.SCHEDULE_NUMBER
, FRSV.DT_ALIAS
, FRSV.DAI_SEQUENCE_NUMBER
, FRSV.START_DT
, FRSV.END_DT
, FRSV.RETENTION_PERCENTAGE
, FRSV.RETENTION_AMOUNT
, FRSV.DEDUCTION_AMOUNT
, FRSV.CURRENCY_CD
, FRSV.CREATED_BY
, FRSV.CREATION_DATE
, FRSV.LAST_UPDATED_BY
, FRSV.LAST_UPDATE_DATE
, FRSV.LAST_UPDATE_LOGIN
FROM IGS_FI_FEE_RET_SCHD_V FRSV
, IGS_FI_F_CAT_FEE_LBL FCFL
, IGS_FI_FEE_TYPE FT
WHERE FRSV.S_RELATION_TYPE = 'FCFL'
AND FCFL.FEE_CAT = FRSV.FEE_CAT
AND FCFL.FEE_CAL_TYPE = FRSV.FEE_CAL_TYPE
AND FCFL.FEE_CI_SEQUENCE_NUMBER = FRSV.FEE_CI_SEQUENCE_NUMBER
AND FCFL.FEE_TYPE = FRSV.FEE_TYPE
AND FT.FEE_TYPE = FCFL.FEE_TYPE
AND FT.S_FEE_TRIGGER_CAT != 'INSTITUTN'
AND FT.S_FEE_TYPE != 'HECS' UNION SELECT FRSV.FEE_CAL_TYPE
, FRSV.FEE_CI_SEQUENCE_NUMBER
, FRSV.S_RELATION_TYPE
, FRSV.FEE_TYPE
, FCFL.FEE_CAT
, FRSV.SCHEDULE_NUMBER
, FRSV.DT_ALIAS
, FRSV.DAI_SEQUENCE_NUMBER
, FRSV.START_DT
, FRSV.END_DT
, FRSV.RETENTION_PERCENTAGE
, FRSV.RETENTION_AMOUNT
, FRSV.DEDUCTION_AMOUNT
, FRSV.CURRENCY_CD
, FRSV.CREATED_BY
, FRSV.CREATION_DATE
, FRSV.LAST_UPDATED_BY
, FRSV.LAST_UPDATE_DATE
, FRSV.LAST_UPDATE_LOGIN
FROM IGS_FI_FEE_RET_SCHD_V FRSV
, IGS_FI_F_CAT_FEE_LBL FCFL
WHERE FRSV.S_RELATION_TYPE = 'FTCI'
AND FCFL.FEE_TYPE = FRSV.FEE_TYPE
AND FCFL.FEE_CAL_TYPE = FRSV.FEE_CAL_TYPE
AND FCFL.FEE_CI_SEQUENCE_NUMBER = FRSV.FEE_CI_SEQUENCE_NUMBER
AND 0 = (SELECT COUNT(*)
FROM IGS_FI_FEE_RET_SCHD FRS
WHERE FRS.FEE_CAL_TYPE = FRSV.FEE_CAL_TYPE
AND FRS.FEE_CI_SEQUENCE_NUMBER = FRSV.FEE_CI_SEQUENCE_NUMBER
AND FRS.S_RELATION_TYPE = 'FCFL'
AND FRS.FEE_TYPE = FCFL.FEE_TYPE
AND FRS.FEE_CAT = FRSV.FEE_CAT) UNION SELECT FRSV.FEE_CAL_TYPE
, FRSV.FEE_CI_SEQUENCE_NUMBER
, FRSV.S_RELATION_TYPE
, FCFL.FEE_TYPE
, FRSV.FEE_CAT
, FRSV.SCHEDULE_NUMBER
, FRSV.DT_ALIAS
, FRSV.DAI_SEQUENCE_NUMBER
, FRSV.START_DT
, FRSV.END_DT
, FRSV.RETENTION_PERCENTAGE
, FRSV.RETENTION_AMOUNT
, FRSV.DEDUCTION_AMOUNT
, FRSV.CURRENCY_CD
, FRSV.CREATED_BY
, FRSV.CREATION_DATE
, FRSV.LAST_UPDATED_BY
, FRSV.LAST_UPDATE_DATE
, FRSV.LAST_UPDATE_LOGIN
FROM IGS_FI_FEE_RET_SCHD_V FRSV
, IGS_FI_F_CAT_FEE_LBL FCFL
, IGS_FI_FEE_TYPE FT
WHERE FRSV.S_RELATION_TYPE = 'FCCI'
AND FCFL.FEE_CAL_TYPE = FRSV.FEE_CAL_TYPE
AND FCFL.FEE_CI_SEQUENCE_NUMBER = FRSV.FEE_CI_SEQUENCE_NUMBER
AND FCFL.FEE_CAT = FRSV.FEE_CAT
AND 0 = (SELECT COUNT(*)
FROM IGS_FI_FEE_RET_SCHD FRS
WHERE FRS.FEE_CAL_TYPE = FRSV.FEE_CAL_TYPE
AND FRS.FEE_CI_SEQUENCE_NUMBER = FRSV.FEE_CI_SEQUENCE_NUMBER
AND FRS.S_RELATION_TYPE = 'FCFL'
AND FRS.FEE_TYPE = FCFL.FEE_TYPE
AND FRS.FEE_CAT = FCFL.FEE_CAT)
AND FT.FEE_TYPE = FCFL.FEE_TYPE
AND FT.S_FEE_TRIGGER_CAT != 'INSTITUTN'
AND FT.S_FEE_TYPE != 'HECS'
AND 0 = (SELECT COUNT(*)
FROM IGS_FI_FEE_RET_SCHD FRS1
WHERE FRS1.FEE_CAL_TYPE = FRSV.FEE_CAL_TYPE
AND FRS1.FEE_CI_SEQUENCE_NUMBER = FRSV.FEE_CI_SEQUENCE_NUMBER
AND FRS1.S_RELATION_TYPE = 'FTCI'
AND FRS1.FEE_TYPE = FCFL.FEE_TYPE)