VIEW: APPS.IGS_FI_F_CAT_FEE_LBL_ALL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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