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: APPS.IGS_FI_FEE_TRG_GRP_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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