VIEW: APPS.IGS_FI_FEE_RET_SCHD_V

Source

View Text - Preformatted

SELECT frtns.rowid row_id, frtns.fee_cal_type, frtns.fee_ci_sequence_number, frtns.s_relation_type, frtns.sequence_number, frtns.FEE_TYPE, frtns.FEE_CAT, frtns.schedule_number, frtns.DT_ALIAS, frtns.dai_sequence_number, IGS_CA_GEN_001.calp_get_alias_val(frtns.DT_ALIAS, frtns.dai_sequence_number, frtns.fee_cal_type, frtns.fee_ci_sequence_number) start_dt, IGS_FI_GEN_001.finp_get_frtns_end_dt(frtns.fee_cal_type, frtns.fee_ci_sequence_number, frtns.s_relation_type, frtns.FEE_TYPE, frtns.FEE_CAT, frtns.DT_ALIAS, frtns.dai_sequence_number) end_dt, frtns.retention_percentage, frtns.retention_amount, frtns.deduction_amount, SUBSTR(IGS_FI_GEN_001.finp_get_currency(frtns.fee_cal_type, frtns.fee_ci_sequence_number, frtns.s_relation_type, frtns.FEE_TYPE, frtns.FEE_CAT),1,15) currency_cd, frtns.created_by, frtns.creation_date, frtns.last_updated_by, frtns.last_update_date, frtns.last_update_login FROM IGS_FI_FEE_RET_SCHD frtns

View Text - HTML Formatted

SELECT FRTNS.ROWID ROW_ID
, FRTNS.FEE_CAL_TYPE
, FRTNS.FEE_CI_SEQUENCE_NUMBER
, FRTNS.S_RELATION_TYPE
, FRTNS.SEQUENCE_NUMBER
, FRTNS.FEE_TYPE
, FRTNS.FEE_CAT
, FRTNS.SCHEDULE_NUMBER
, FRTNS.DT_ALIAS
, FRTNS.DAI_SEQUENCE_NUMBER
, IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(FRTNS.DT_ALIAS
, FRTNS.DAI_SEQUENCE_NUMBER
, FRTNS.FEE_CAL_TYPE
, FRTNS.FEE_CI_SEQUENCE_NUMBER) START_DT
, IGS_FI_GEN_001.FINP_GET_FRTNS_END_DT(FRTNS.FEE_CAL_TYPE
, FRTNS.FEE_CI_SEQUENCE_NUMBER
, FRTNS.S_RELATION_TYPE
, FRTNS.FEE_TYPE
, FRTNS.FEE_CAT
, FRTNS.DT_ALIAS
, FRTNS.DAI_SEQUENCE_NUMBER) END_DT
, FRTNS.RETENTION_PERCENTAGE
, FRTNS.RETENTION_AMOUNT
, FRTNS.DEDUCTION_AMOUNT
, SUBSTR(IGS_FI_GEN_001.FINP_GET_CURRENCY(FRTNS.FEE_CAL_TYPE
, FRTNS.FEE_CI_SEQUENCE_NUMBER
, FRTNS.S_RELATION_TYPE
, FRTNS.FEE_TYPE
, FRTNS.FEE_CAT)
, 1
, 15) CURRENCY_CD
, FRTNS.CREATED_BY
, FRTNS.CREATION_DATE
, FRTNS.LAST_UPDATED_BY
, FRTNS.LAST_UPDATE_DATE
, FRTNS.LAST_UPDATE_LOGIN
FROM IGS_FI_FEE_RET_SCHD FRTNS