View: IGS_FI_F_CAT_FEE_LBL_ALL_V

View Text

SELECT FCFL.ROWID ROW_ID
, FCFL.FEE_CAT
, FCFL.FEE_CAL_TYPE
, FCFL.FEE_CI_SEQUENCE_NUMBER
, FCFL.FEE_TYPE
, FCFL.FEE_LIABILITY_STATUS
, FCFL.START_DT_ALIAS
, FCFL.START_DAI_SEQUENCE_NUMBER
, FCFL.S_CHG_METHOD_TYPE
, FCFL.RUL_SEQUENCE_NUMBER
, FCFL.PAYMENT_HIERARCHY_RANK
, FCFL.CREATED_BY
, FCFL.CREATION_DATE
, FCFL.LAST_UPDATED_BY
, FCFL.LAST_UPDATE_DATE
, FCFL.LAST_UPDATE_LOGIN
, FCFL.REQUEST_ID
, FCFL.PROGRAM_ID
, FCFL.PROGRAM_APPLICATION_ID
, FCFL.PROGRAM_UPDATE_DATE
, LKUP.MEANING
, DAI.ALIAS_VAL ABSOLUTE_VAL
, DA.DESCRIPTION DA_DESCRIPTION
, FSST.DESCRIPTION FSST_DESCRIPTION
, FSST.S_FEE_STRUCTURE_STATUS S_FEE_STRUCTURE_STATUS
, FSST.CLOSED_IND FSST_CLOSED_IND
, FT.S_FEE_TYPE S_FEE_TYPE
, FT.DESCRIPTION FT_DESCRIPTION
, FT.CLOSED_IND FT_CLOSED_IND2
, RUL.SEQUENCE_NUMBER
, FCFL.WAIVER_CALC_FLAG
FROM IGS_FI_F_CAT_FEE_LBL FCFL
, IGS_LOOKUP_VALUES LKUP
, IGS_CA_DA_INST_V DAI
, IGS_CA_DA DA
, IGS_FI_FEE_STR_STAT FSST
, IGS_FI_FEE_TYPE FT
, IGS_RU_RULE RUL
WHERE LKUP.LOOKUP_CODE(+)= FCFL.S_CHG_METHOD_TYPE
AND LKUP.LOOKUP_TYPE(+) = 'CHG_METHOD'
AND DAI.CAL_TYPE (+)= FCFL.FEE_CAL_TYPE
AND DAI.CI_SEQUENCE_NUMBER (+)= FCFL.FEE_CI_SEQUENCE_NUMBER
AND DAI.DT_ALIAS(+)= FCFL.START_DT_ALIAS
AND DAI.SEQUENCE_NUMBER(+)= FCFL.START_DAI_SEQUENCE_NUMBER
AND DA.DT_ALIAS(+) = FCFL.START_DT_ALIAS
AND FSST.FEE_STRUCTURE_STATUS = FCFL.FEE_LIABILITY_STATUS
AND FT.FEE_TYPE = FCFL.FEE_TYPE
AND RUL.SEQUENCE_NUMBER(+) = FCFL.RUL_SEQUENCE_NUMBER

Columns