VIEW: APPS.IGS_FI_F_CAT_FEE_LBL_V

Source

View Text - Preformatted

SELECT fcfl.FEE_CAT, fcfl.fee_cal_type, fcfl.fee_ci_sequence_number, fcfl.FEE_TYPE, fcfl.fee_liability_status, NVL(fcfl.start_dt_alias, SUBSTR(IGS_FI_GEN_001.finp_get_fcfl_dai('START_DT_ALIAS', 'START_DAI_SEQUENCE_NUMBER', 'START_DT_ALIAS', fcfl.FEE_CAT, fcfl.fee_cal_type, fcfl.fee_ci_sequence_number, fcfl.FEE_TYPE),1,10)) start_dt_alias, NVL(fcfl.start_dai_sequence_number, TO_NUMBER(IGS_FI_GEN_001.finp_get_fcfl_dai('START_DT_ALIAS', 'START_DAI_SEQUENCE_NUMBER', 'START_DAI_SEQUENCE_NUMBER', fcfl.FEE_CAT, fcfl.fee_cal_type, fcfl.fee_ci_sequence_number, fcfl.FEE_TYPE))) start_dai_sequence_number, SUBSTR(IGS_FI_GEN_001.finp_get_fcfl_dai('END_DT_ALIAS', 'END_DAI_SEQUENCE_NUMBER', 'END_DT_ALIAS', fcfl.FEE_CAT, fcfl.fee_cal_type, fcfl.fee_ci_sequence_number, fcfl.FEE_TYPE),1,10) end_dt_alias, TO_NUMBER(IGS_FI_GEN_001.finp_get_fcfl_dai('END_DT_ALIAS', 'END_DAI_SEQUENCE_NUMBER', 'END_DAI_SEQUENCE_NUMBER', fcfl.FEE_CAT, fcfl.fee_cal_type, fcfl.fee_ci_sequence_number, fcfl.FEE_TYPE)) end_dai_sequence_number, SUBSTR(IGS_FI_GEN_001.finp_get_fcfl_dai('RETRO_DT_ALIAS', 'RETRO_DAI_SEQUENCE_NUMBER', 'RETRO_DT_ALIAS', fcfl.FEE_CAT, fcfl.fee_cal_type, fcfl.fee_ci_sequence_number, fcfl.FEE_TYPE),1,10) retro_dt_alias, TO_NUMBER(IGS_FI_GEN_001.finp_get_fcfl_dai('RETRO_DT_ALIAS', 'RETRO_DAI_SEQUENCE_NUMBER', 'RETRO_DAI_SEQUENCE_NUMBER', fcfl.FEE_CAT, fcfl.fee_cal_type, fcfl.fee_ci_sequence_number, fcfl.FEE_TYPE)) retro_dai_sequence_number, NVL(fcfl.s_chg_method_type, ftci.s_chg_method_type) s_chg_method_type, NVL(fcfl.rul_sequence_number, ftci.rul_sequence_number) rul_sequence_number, SUBSTR(IGS_FI_GEN_001.finp_get_currency(fcfl.fee_cal_type, fcfl.fee_ci_sequence_number, NULL, fcfl.FEE_TYPE, fcfl.FEE_CAT),1,15) currency_cd, NVL(fcfl.payment_hierarchy_rank, ftci.payment_hierarchy_rank) payment_hierarchy_rank, fcfl.created_by, fcfl.creation_date, fcfl.last_updated_by, fcfl.last_update_date, fcfl.last_update_login, FTCI.SCOPE_RUL_SEQUENCE_NUM, FTCI.ELM_RNG_ORDER_NAME, FCFL.WAIVER_CALC_FLAG, FTCI.MAX_CHG_ELEMENTS FROM IGS_FI_F_CAT_FEE_LBL fcfl, IGS_FI_F_TYP_CA_INST ftci WHERE ftci.FEE_TYPE = fcfl.FEE_TYPE AND ftci.fee_cal_type = fcfl.fee_cal_type AND ftci.fee_ci_sequence_number = fcfl.fee_ci_sequence_number

View Text - HTML Formatted

SELECT FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE
, FCFL.FEE_LIABILITY_STATUS
, NVL(FCFL.START_DT_ALIAS
, SUBSTR(IGS_FI_GEN_001.FINP_GET_FCFL_DAI('START_DT_ALIAS'
, 'START_DAI_SEQUENCE_NUMBER'
, 'START_DT_ALIAS'
, FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE)
, 1
, 10)) START_DT_ALIAS
, NVL(FCFL.START_DAI_SEQUENCE_NUMBER
, TO_NUMBER(IGS_FI_GEN_001.FINP_GET_FCFL_DAI('START_DT_ALIAS'
, 'START_DAI_SEQUENCE_NUMBER'
, 'START_DAI_SEQUENCE_NUMBER'
, FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE))) START_DAI_SEQUENCE_NUMBER
, SUBSTR(IGS_FI_GEN_001.FINP_GET_FCFL_DAI('END_DT_ALIAS'
, 'END_DAI_SEQUENCE_NUMBER'
, 'END_DT_ALIAS'
, FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE)
, 1
, 10) END_DT_ALIAS
, TO_NUMBER(IGS_FI_GEN_001.FINP_GET_FCFL_DAI('END_DT_ALIAS'
, 'END_DAI_SEQUENCE_NUMBER'
, 'END_DAI_SEQUENCE_NUMBER'
, FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE)) END_DAI_SEQUENCE_NUMBER
, SUBSTR(IGS_FI_GEN_001.FINP_GET_FCFL_DAI('RETRO_DT_ALIAS'
, 'RETRO_DAI_SEQUENCE_NUMBER'
, 'RETRO_DT_ALIAS'
, FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE)
, 1
, 10) RETRO_DT_ALIAS
, TO_NUMBER(IGS_FI_GEN_001.FINP_GET_FCFL_DAI('RETRO_DT_ALIAS'
, 'RETRO_DAI_SEQUENCE_NUMBER'
, 'RETRO_DAI_SEQUENCE_NUMBER'
, FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE)) RETRO_DAI_SEQUENCE_NUMBER
, NVL(FCFL.S_CHG_METHOD_TYPE
, FTCI.S_CHG_METHOD_TYPE) S_CHG_METHOD_TYPE
, NVL(FCFL.RUL_SEQUENCE_NUMBER
, FTCI.RUL_SEQUENCE_NUMBER) RUL_SEQUENCE_NUMBER
, SUBSTR(IGS_FI_GEN_001.FINP_GET_CURRENCY(FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, NULL
, FCFL.FEE_TYPE
, FCFL.FEE_CAT)
, 1
, 15) CURRENCY_CD
, NVL(FCFL.PAYMENT_HIERARCHY_RANK
, FTCI.PAYMENT_HIERARCHY_RANK) PAYMENT_HIERARCHY_RANK
, FCFL.CREATED_BY
, FCFL.CREATION_DATE
, FCFL.LAST_UPDATED_BY
, FCFL.LAST_UPDATE_DATE
, FCFL.LAST_UPDATE_LOGIN
, FTCI.SCOPE_RUL_SEQUENCE_NUM
, FTCI.ELM_RNG_ORDER_NAME
, FCFL.WAIVER_CALC_FLAG
, FTCI.MAX_CHG_ELEMENTS
FROM IGS_FI_F_CAT_FEE_LBL FCFL
, IGS_FI_F_TYP_CA_INST FTCI
WHERE FTCI.FEE_TYPE = FCFL.FEE_TYPE
AND FTCI.FEE_CAL_TYPE = FCFL.FEE_CAL_TYPE
AND FTCI.FEE_CI_SEQUENCE_NUMBER = FCFL.FEE_CI_SEQUENCE_NUMBER