View: IGS_FI_FEE_AS_RATE_V

View Text

SELECT FAR.ROWID ROW_ID
, FAR.FAR_ID FAR_ID
, FAR.FEE_TYPE FEE_TYPE
, FAR.FEE_CAL_TYPE FEE_CAL_TYPE
, FAR.FEE_CI_SEQUENCE_NUMBER FEE_CI_SEQUENCE_NUMBER
, FAR.S_RELATION_TYPE S_RELATION_TYPE
, FAR.RATE_NUMBER RATE_NUMBER
, FAR.FEE_CAT FEE_CAT
, FAR.LOCATION_CD LOCATION_CD
, ADL.DESCRIPTION DSP_DESCRIPTION5
, ADL.CLOSED_IND DSP_CLOSED_IND5
, FAR.ATTENDANCE_TYPE ATTENDANCE_TYPE
, EAT.DESCRIPTION DSP_DESCRIPTION3
, EAT.CLOSED_IND DSP_CLOSED_IND3
, FAR.ATTENDANCE_MODE ATTENDANCE_MODE
, EAM.DESCRIPTION DSP_DESCRIPTION4
, EAM.CLOSED_IND DSP_CLOSED_IND4
, FAR.ORDER_OF_PRECEDENCE ORDER_OF_PRECEDENCE
, FAR.GOVT_HECS_PAYMENT_OPTION GOVT_HECS_PAYMENT_OPTION
, HPO.DESCRIPTION DSP_DESCRIPTION2
, HPO.CLOSED_IND DSP_CLOSED_IND2
, FAR.GOVT_HECS_CNTRBTN_BAND GOVT_HECS_CNTRBTN_BAND
, GHC.DESCRIPTION DSP_DESCRIPTION
, GHC.CLOSED_IND DSP_CLOSED_IND
, FAR.CHG_RATE CHG_RATE
, FAR.LOGICAL_DELETE_DT LOGICAL_DELETE_DT
, FAR.UNIT_CLASS UNIT_CLASS
, AUC.DESCRIPTION DSP_DESCRIPTION6
, AUC.CLOSED_IND DSP_CLOSED_IND6
, FAR.CREATED_BY CREATED_BY
, FAR.CREATION_DATE CREATION_DATE
, FAR.LAST_UPDATED_BY LAST_UPDATED_BY
, FAR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FAR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FAR.REQUEST_ID REQUEST_ID
, FAR.PROGRAM_ID PROGRAM_ID
, FAR.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, FAR.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, FAR.RESIDENCY_STATUS_CD RESIDENCY_STATUS_CD
, CC.MEANING DSP_RESIDENCY_STATUS
, FAR.COURSE_CD COURSE_CD
, FAR.VERSION_NUMBER VERSION_NUMBER
, PS.TITLE DSP_PROG_TITLE
, FAR.ORG_PARTY_ID
, HP.PARTY_NUMBER ORG_UNIT_CD
, HP.PARTY_NAME DSP_ORG_UNIT_CD
, FAR.CLASS_STANDING
, CS.DESCRIPTION DSP_CLASS_STANDING
, FAR.UNIT_SET_CD UNIT_SET_CD
, FAR.US_VERSION_NUMBER US_VERSION_NUMBER
, US.TITLE UNIT_SET_DESC
, FAR.UNIT_CD
, FAR.UNIT_VERSION_NUMBER
, UV.TITLE
, FAR.UNIT_LEVEL
, UL.DESCRIPTION
, FAR.UNIT_TYPE_ID
, PUT.LEVEL_CODE
, PUT.DESCRIPTION
, FAR.UNIT_MODE
, AUM.DESCRIPTION
FROM IGS_FI_FEE_AS_RATE FAR
, IGS_AD_LOCATION ADL
, IGS_EN_ATD_TYPE EAT
, IGS_EN_ATD_MODE EAM
, IGS_FI_GOV_HEC_PA_OP HPO
, IGS_FI_GOVT_HEC_CNTB GHC
, IGS_AS_UNIT_CLASS AUC
, IGS_LOOKUP_VALUES CC
, IGS_PS_VER PS
, HZ_PARTIES HP
, IGS_PR_CLASS_STD CS
, IGS_EN_UNIT_SET US
, IGS_PS_UNIT_VER_ALL UV
, IGS_PS_UNIT_LEVEL_ALL UL
, IGS_PS_UNIT_TYPE_LVL PUT
, IGS_AS_UNIT_MODE AUM
WHERE FAR.LOCATION_CD = ADL.LOCATION_CD(+)
AND FAR.ATTENDANCE_TYPE = EAT.ATTENDANCE_TYPE(+)
AND FAR.ATTENDANCE_MODE = EAM.ATTENDANCE_MODE(+)
AND FAR.GOVT_HECS_PAYMENT_OPTION = HPO.GOVT_HECS_PAYMENT_OPTION(+)
AND FAR.GOVT_HECS_CNTRBTN_BAND = GHC.GOVT_HECS_CNTRBTN_BAND(+)
AND FAR.UNIT_CLASS = AUC.UNIT_CLASS(+)
AND FAR.RESIDENCY_STATUS_CD = CC.LOOKUP_CODE (+)
AND CC.LOOKUP_TYPE(+) = 'PE_RES_STATUS'
AND FAR.COURSE_CD = PS.COURSE_CD (+)
AND FAR.VERSION_NUMBER = PS.VERSION_NUMBER (+)
AND FAR.ORG_PARTY_ID = HP.PARTY_ID (+)
AND FAR.CLASS_STANDING = CS.CLASS_STANDING(+)
AND FAR.UNIT_SET_CD = US.UNIT_SET_CD (+)
AND FAR.US_VERSION_NUMBER = US.VERSION_NUMBER (+)
AND FAR.UNIT_CD = UV.UNIT_CD (+)
AND FAR.UNIT_VERSION_NUMBER = UV.VERSION_NUMBER (+)
AND FAR.UNIT_LEVEL = UL.UNIT_LEVEL(+)
AND FAR.UNIT_TYPE_ID = PUT.UNIT_TYPE_ID (+)
AND FAR.UNIT_MODE = AUM.UNIT_MODE (+)

Columns