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_TRG_GRP_V

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

View Text

SELECT CFT.FEE_CAT
, CFT.FEE_CAL_TYPE
, CFT.FEE_CI_SEQUENCE_NUMBER
, CFT.FEE_TYPE
, CFT.FEE_TRIGGER_GROUP_NUMBER
, LKP.MEANING TRIGGER_TYPE
, CFT.COURSE_CD CODE
, CFT.VERSION_NUMBER
, CRV.TITLE
, CFT.CREATED_BY
, CFT.CREATION_DATE
, CFT.LAST_UPDATED_BY
, CFT.LAST_UPDATE_DATE
, CFT.LAST_UPDATE_LOGIN
, LKP.LOOKUP_CODE TRIGGER_TYPE_CODE
FROM IGS_PS_FEE_TRG CFT
, IGS_PS_VER CRV
, IGS_LOOKUP_VALUES LKP
WHERE LKP.LOOKUP_TYPE = 'IGS_FI_TRIGGER_GROUP'
AND LKP.LOOKUP_CODE = 'COURSE'
AND CFT.FEE_TRIGGER_GROUP_NUMBER IS NOT NULL
AND CFT.LOGICAL_DELETE_DT IS NULL
AND CFT.COURSE_CD = CRV.COURSE_CD
AND (CFT.VERSION_NUMBER = CRV.VERSION_NUMBER OR (CFT.VERSION_NUMBER IS NULL
AND CRV.VERSION_NUMBER = ( SELECT MAX(CRV2.VERSION_NUMBER) FROM IGS_PS_VER CRV2 WHERE CRV2.COURSE_CD = CRV.COURSE_CD))) UNION ALL SELECT UFT.FEE_CAT
, UFT.FEE_CAL_TYPE
, UFT.FEE_CI_SEQUENCE_NUMBER
, UFT.FEE_TYPE
, UFT.FEE_TRIGGER_GROUP_NUMBER
, LKP.MEANING TRIGGER_TYPE
, UFT.UNIT_CD CODE
, UFT.VERSION_NUMBER
, UV.TITLE
, UFT.CREATED_BY
, UFT.CREATION_DATE
, UFT.LAST_UPDATED_BY
, UFT.LAST_UPDATE_DATE
, UFT.LAST_UPDATE_LOGIN
, LKP.LOOKUP_CODE TRIGGER_TYPE_CODE FROM IGS_FI_UNIT_FEE_TRG UFT
, IGS_PS_UNIT_VER UV
, IGS_LOOKUP_VALUES LKP WHERE LKP.LOOKUP_TYPE = 'IGS_FI_TRIGGER_GROUP'
AND LKP.LOOKUP_CODE = 'UNIT'
AND UFT.FEE_TRIGGER_GROUP_NUMBER IS NOT NULL
AND UFT.LOGICAL_DELETE_DT IS NULL
AND UFT.UNIT_CD = UV.UNIT_CD
AND (UFT.VERSION_NUMBER = UV.VERSION_NUMBER OR (UFT.VERSION_NUMBER IS NULL
AND UV.VERSION_NUMBER = ( SELECT MAX(UV2.VERSION_NUMBER) FROM IGS_PS_UNIT_VER UV2 WHERE UV2.UNIT_CD = UV.UNIT_CD))) UNION ALL SELECT USFT.FEE_CAT
, USFT.FEE_CAL_TYPE
, USFT.FEE_CI_SEQUENCE_NUMBER
, USFT.FEE_TYPE
, USFT.FEE_TRIGGER_GROUP_NUMBER
, LKP.MEANING TRIGGER_TYPE
, USFT.UNIT_SET_CD CODE
, USFT.VERSION_NUMBER
, US.TITLE
, USFT.CREATED_BY
, USFT.CREATION_DATE
, USFT.LAST_UPDATED_BY
, USFT.LAST_UPDATE_DATE
, USFT.LAST_UPDATE_LOGIN
, LKP.LOOKUP_CODE TRIGGER_TYPE_CODE FROM IGS_EN_UNITSETFEETRG USFT
, IGS_EN_UNIT_SET US
, IGS_LOOKUP_VALUES LKP WHERE LKP.LOOKUP_TYPE = 'IGS_FI_TRIGGER_GROUP'
AND LKP.LOOKUP_CODE = 'UNITSET'
AND USFT.FEE_TRIGGER_GROUP_NUMBER IS NOT NULL
AND USFT.LOGICAL_DELETE_DT IS NULL
AND USFT.UNIT_SET_CD = US.UNIT_SET_CD
AND USFT.VERSION_NUMBER = US.VERSION_NUMBER

Columns

Name
FEE_CAT
FEE_CAL_TYPE
FEE_CI_SEQUENCE_NUMBER
FEE_TYPE
FEE_TRIGGER_GROUP_NUMBER
TRIGGER_TYPE
CODE
VERSION_NUMBER
TITLE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
TRIGGER_TYPE_CODE