View: IGS_FI_F_CAT_FEE_LBL_SCA_RT_V

View Text

SELECT SCAFCFLV.PERSON_ID
, SCAFCFLV.COURSE_CD
, SCAFCFLV.VERSION_NUMBER
, SCAFCFLV.CAL_TYPE
, SCAFCFLV.LOCATION_CD
, SCAFCFLV.ATTENDANCE_MODE
, SCAFCFLV.ATTENDANCE_TYPE
, SCAFCFLV.HECS_PAYMENT_OPTION
, SCAFCFLV.FEE_ASS_IND
, SCAFCFLV.FEE_CAT
, SCAFCFLV.FEE_CAL_TYPE
, SCAFCFLV.FEE_CI_SEQUENCE_NUMBER
, SCAFCFLV.FEE_TYPE
, SCAFCFLV.S_FEE_TYPE
, SCAFCFLV.S_FEE_TRIGGER_CAT
, SCAFCFLV.FEE_LIABILITY_STATUS
, SCAFCFLV.START_DT
, SCAFCFLV.END_DT
, SCAFCFLV.RETRO_DT
, SCAFCFLV.S_CHG_METHOD_TYPE
, SCAFCFLV.RUL_SEQUENCE_NUMBER
, FTFARV.CHG_RATE
, SCAFCFLV.CURRENCY_CD
, FTFARV.LOCATION_CD CHG_RATE_LOCATION_CD
, FTFARV.ATTENDANCE_TYPE CHG_RATE_ATTENDANCE_TYPE
, FTFARV.ATTENDANCE_MODE CHG_RATE_ATTENDANCE_MODE
, CFAR.START_DT CONTRACT_START_DT
, CFAR.END_DT CONTRACT_END_DT
, CFAR.CHG_RATE CONTRACT_RATE
, CFAR.LOCATION_CD CONTRACT_LOCATION_CD
, CFAR.ATTENDANCE_TYPE CONTRACT_ATTENDANCE_TYPE
, CFAR.ATTENDANCE_MODE CONTRACT_ATTENDANCE_MODE
, CFAR.LOWER_NRML_RATE_OVRD_IND
, SCAFCFLV.CREATED_BY
, SCAFCFLV.CREATION_DATE
, SCAFCFLV.LAST_UPDATED_BY
, SCAFCFLV.LAST_UPDATE_DATE
, SCAFCFLV.LAST_UPDATE_LOGIN
FROM IGS_FI_F_CAT_FEE_LBL_SCA_V SCAFCFLV
, IGS_FI_FEE_AS_RATE_F_TYPE_V FTFARV
, IGS_FI_FEE_AS_RT CFAR
WHERE FTFARV.FEE_TYPE(+) = SCAFCFLV.FEE_TYPE
AND FTFARV.FEE_CAL_TYPE(+) = SCAFCFLV.FEE_CAL_TYPE
AND FTFARV.FEE_CI_SEQUENCE_NUMBER(+) = SCAFCFLV.FEE_CI_SEQUENCE_NUMBER
AND FTFARV.FEE_CAT(+) = SCAFCFLV.FEE_CAT
AND NVL(FTFARV.LOCATION_CD(+)
, SCAFCFLV.LOCATION_CD) = SCAFCFLV.LOCATION_CD
AND NVL(FTFARV.ATTENDANCE_TYPE(+)
, SCAFCFLV.ATTENDANCE_TYPE) = SCAFCFLV.ATTENDANCE_TYPE
AND NVL(FTFARV.ATTENDANCE_MODE(+)
, SCAFCFLV.ATTENDANCE_MODE) = SCAFCFLV.ATTENDANCE_MODE
AND NVL(FTFARV.GOVT_HECS_PAYMENT_OPTION(+)
, NVL(SCAFCFLV.HECS_PAYMENT_OPTION
, 'NULL')) = NVL(SCAFCFLV.HECS_PAYMENT_OPTION
, 'NULL')
AND CFAR.PERSON_ID(+) = SCAFCFLV.PERSON_ID
AND CFAR.COURSE_CD(+) = SCAFCFLV.COURSE_CD
AND CFAR.FEE_TYPE(+) = SCAFCFLV.FEE_TYPE

Columns