VIEW: APPS.IGS_FI_FEE_AS_RATE_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)