eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_FI_FEE_AS_RATE_F_TYPE_V

Product:	IGS - Student System (Obsolete)
Description:	No longer used
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT FAR.FEE_TYPE
, FAR.FEE_CAL_TYPE
, FAR.FEE_CI_SEQUENCE_NUMBER
, FAR.S_RELATION_TYPE
, FCFL.FEE_CAT
, FAR.RATE_NUMBER
, 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.UNIT_CLASS
, SUBSTR(IGS_FI_GEN_001.FINP_GET_CURRENCY(FAR.FEE_CAL_TYPE
, FAR.FEE_CI_SEQUENCE_NUMBER
, FAR.S_RELATION_TYPE
, FAR.FEE_TYPE
, FCFL.FEE_CAT)
, 1
, 15) CURRENCY_CD
, FAR.CREATED_BY
, FAR.CREATION_DATE
, FAR.LAST_UPDATED_BY
, FAR.LAST_UPDATE_DATE
, FAR.LAST_UPDATE_LOGIN
, FAR.RESIDENCY_STATUS_CD
, FAR.COURSE_CD
, FAR.VERSION_NUMBER
, FAR.ORG_PARTY_ID
, HP.PARTY_NUMBER ORG_UNIT_CD
, FAR.CLASS_STANDING
, FAR.UNIT_SET_CD UNIT_SET_CD
, FAR.US_VERSION_NUMBER US_VERSION_NUMBER
FROM IGS_FI_FEE_AS_RATE FAR
, IGS_FI_F_CAT_FEE_LBL FCFL
, HZ_PARTIES HP
WHERE FAR.S_RELATION_TYPE = 'FCFL'
AND FAR.LOGICAL_DELETE_DT IS NULL
AND FCFL.FEE_CAT = FAR.FEE_CAT
AND FCFL.FEE_CAL_TYPE = FAR.FEE_CAL_TYPE
AND FCFL.FEE_CI_SEQUENCE_NUMBER = FAR.FEE_CI_SEQUENCE_NUMBER
AND FCFL.FEE_TYPE = FAR.FEE_TYPE
AND FAR.ORG_PARTY_ID = HP.PARTY_ID (+) UNION ALL SELECT FAR.FEE_TYPE
, FAR.FEE_CAL_TYPE
, FAR.FEE_CI_SEQUENCE_NUMBER
, FAR.S_RELATION_TYPE
, FCFL.FEE_CAT
, FAR.RATE_NUMBER
, 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.UNIT_CLASS
, SUBSTR(IGS_FI_GEN_001.FINP_GET_CURRENCY(FAR.FEE_CAL_TYPE
, FAR.FEE_CI_SEQUENCE_NUMBER
, FAR.S_RELATION_TYPE
, FAR.FEE_TYPE
, FCFL.FEE_CAT)
, 1
, 15) CURRENCY_CD
, FAR.CREATED_BY
, FAR.CREATION_DATE
, FAR.LAST_UPDATED_BY
, FAR.LAST_UPDATE_DATE
, FAR.LAST_UPDATE_LOGIN
, FAR.RESIDENCY_STATUS_CD
, FAR.COURSE_CD
, FAR.VERSION_NUMBER
, FAR.ORG_PARTY_ID
, HP.PARTY_NUMBER ORG_UNIT_CD
, FAR.CLASS_STANDING
, FAR.UNIT_SET_CD UNIT_SET_CD
, FAR.US_VERSION_NUMBER US_VERSION_NUMBER FROM IGS_FI_FEE_AS_RATE FAR
, IGS_FI_F_CAT_FEE_LBL FCFL
, HZ_PARTIES HP WHERE FAR.S_RELATION_TYPE = 'FTCI'
AND FAR.LOGICAL_DELETE_DT IS NULL
AND FCFL.FEE_TYPE = FAR.FEE_TYPE
AND FCFL.FEE_CAL_TYPE = FAR.FEE_CAL_TYPE
AND FCFL.FEE_CI_SEQUENCE_NUMBER = FAR.FEE_CI_SEQUENCE_NUMBER
AND NOT EXISTS (SELECT '1' FROM IGS_FI_FEE_AS_RATE FAR1 WHERE FAR1.FEE_TYPE = FCFL.FEE_TYPE
AND FAR1.FEE_CAL_TYPE = FCFL.FEE_CAL_TYPE
AND FAR1.FEE_CI_SEQUENCE_NUMBER = FCFL.FEE_CI_SEQUENCE_NUMBER
AND FAR1.S_RELATION_TYPE = 'FCFL'
AND FAR1.FEE_CAT = FCFL.FEE_CAT
AND FAR1.LOGICAL_DELETE_DT IS NULL)
AND FAR.ORG_PARTY_ID = HP.PARTY_ID (+)

Columns

Name
FEE_TYPE
FEE_CAL_TYPE
FEE_CI_SEQUENCE_NUMBER
S_RELATION_TYPE
FEE_CAT
RATE_NUMBER
LOCATION_CD
ATTENDANCE_TYPE
ATTENDANCE_MODE
ORDER_OF_PRECEDENCE
GOVT_HECS_PAYMENT_OPTION
GOVT_HECS_CNTRBTN_BAND
CHG_RATE
UNIT_CLASS
CURRENCY_CD
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
RESIDENCY_STATUS_CD
COURSE_CD
VERSION_NUMBER
ORG_PARTY_ID
ORG_UNIT_CD
CLASS_STANDING
UNIT_SET_CD
US_VERSION_NUMBER