VIEW: APPS.IGS_FI_F_CAT_FEE_LBL_SCA_RT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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