VIEW: APPS.IGS_FI_ELM_RNG_V

Source

View Text - Preformatted

SELECT ERR.ROWID, ERR.ERR_ID, ERR.FEE_TYPE, ERR.FEE_CAL_TYPE, ERR.FEE_CI_SEQUENCE_NUMBER, ERR.S_RELATION_TYPE, ERR.RANGE_NUMBER, ERR.RATE_NUMBER, ERR.CREATE_DT, ERR.FEE_CAT, ERR.LOGICAL_DELETE_DT, FAR.LOCATION_CD, FAR.ATTENDANCE_TYPE, FAR.ATTENDANCE_MODE, FAR.ORDER_OF_PRECEDENCE, FAR.GOVT_HECS_PAYMENT_OPTION, FAR.GOVT_HECS_CNTRBTN_BAND, FAR.CHG_RATE, FAR.RESIDENCY_STATUS_CD dsp_residency_status_cd, CC.meaning dsp_residency_status, FAR.COURSE_CD, FAR.VERSION_NUMBER, HP.PARTY_NUMBER, FAR.CLASS_STANDING, ERR.CREATED_BY, ERR.CREATION_DATE, ERR.LAST_UPDATED_BY, ERR.LAST_UPDATE_DATE, ERR.LAST_UPDATE_LOGIN, FAR.UNIT_SET_CD, FAR.US_VERSION_NUMBER, FAR.UNIT_TYPE_ID, PUT.LEVEL_CODE, FAR.UNIT_CLASS, FAR.UNIT_MODE, FAR.UNIT_CD, FAR.UNIT_VERSION_NUMBER, FAR.UNIT_LEVEL FROM IGS_FI_ELM_RANGE_RT ERR, IGS_FI_FEE_AS_RATE FAR, HZ_PARTIES HP, IGS_LOOKUP_VALUES CC, IGS_PS_UNIT_TYPE_LVL PUT WHERE FAR.FEE_TYPE = ERR.FEE_TYPE AND FAR.FEE_CAL_TYPE = ERR.FEE_CAL_TYPE AND FAR.FEE_CI_SEQUENCE_NUMBER = ERR.FEE_CI_SEQUENCE_NUMBER AND FAR.RATE_NUMBER = ERR.RATE_NUMBER AND FAR.S_RELATION_TYPE = ERR.S_RELATION_TYPE AND (FAR.FEE_CAT = ERR.FEE_CAT OR (FAR.FEE_CAT IS NULL AND ERR.FEE_CAT IS NULL)) AND FAR.ORG_PARTY_ID = HP.PARTY_ID (+) AND FAR.RESIDENCY_STATUS_CD = CC.LOOKUP_CODE (+) AND CC.LOOKUP_TYPE(+) = 'PE_RES_STATUS' AND FAR.UNIT_TYPE_ID = PUT.UNIT_TYPE_ID (+)

View Text - HTML Formatted

SELECT ERR.ROWID
, ERR.ERR_ID
, ERR.FEE_TYPE
, ERR.FEE_CAL_TYPE
, ERR.FEE_CI_SEQUENCE_NUMBER
, ERR.S_RELATION_TYPE
, ERR.RANGE_NUMBER
, ERR.RATE_NUMBER
, ERR.CREATE_DT
, ERR.FEE_CAT
, ERR.LOGICAL_DELETE_DT
, FAR.LOCATION_CD
, FAR.ATTENDANCE_TYPE
, FAR.ATTENDANCE_MODE
, FAR.ORDER_OF_PRECEDENCE
, FAR.GOVT_HECS_PAYMENT_OPTION
, FAR.GOVT_HECS_CNTRBTN_BAND
, FAR.CHG_RATE
, FAR.RESIDENCY_STATUS_CD DSP_RESIDENCY_STATUS_CD
, CC.MEANING DSP_RESIDENCY_STATUS
, FAR.COURSE_CD
, FAR.VERSION_NUMBER
, HP.PARTY_NUMBER
, FAR.CLASS_STANDING
, ERR.CREATED_BY
, ERR.CREATION_DATE
, ERR.LAST_UPDATED_BY
, ERR.LAST_UPDATE_DATE
, ERR.LAST_UPDATE_LOGIN
, FAR.UNIT_SET_CD
, FAR.US_VERSION_NUMBER
, FAR.UNIT_TYPE_ID
, PUT.LEVEL_CODE
, FAR.UNIT_CLASS
, FAR.UNIT_MODE
, FAR.UNIT_CD
, FAR.UNIT_VERSION_NUMBER
, FAR.UNIT_LEVEL
FROM IGS_FI_ELM_RANGE_RT ERR
, IGS_FI_FEE_AS_RATE FAR
, HZ_PARTIES HP
, IGS_LOOKUP_VALUES CC
, IGS_PS_UNIT_TYPE_LVL PUT
WHERE FAR.FEE_TYPE = ERR.FEE_TYPE
AND FAR.FEE_CAL_TYPE = ERR.FEE_CAL_TYPE
AND FAR.FEE_CI_SEQUENCE_NUMBER = ERR.FEE_CI_SEQUENCE_NUMBER
AND FAR.RATE_NUMBER = ERR.RATE_NUMBER
AND FAR.S_RELATION_TYPE = ERR.S_RELATION_TYPE
AND (FAR.FEE_CAT = ERR.FEE_CAT OR (FAR.FEE_CAT IS NULL
AND ERR.FEE_CAT IS NULL))
AND FAR.ORG_PARTY_ID = HP.PARTY_ID (+)
AND FAR.RESIDENCY_STATUS_CD = CC.LOOKUP_CODE (+)
AND CC.LOOKUP_TYPE(+) = 'PE_RES_STATUS'
AND FAR.UNIT_TYPE_ID = PUT.UNIT_TYPE_ID (+)