[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | No longer used. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT FAS.PERSON_ID
, FTCI.FIN_CAL_TYPE
, FTCI.FIN_CI_SEQUENCE_NUMBER
, FAS.FEE_TYPE
, FAS.FEE_CAL_TYPE
, FAS.FEE_CI_SEQUENCE_NUMBER
, FAS.FEE_CAT
, FAS.COURSE_CD
, MAX(FAS.TRANSACTION_DT) LAST_TRANSACTION_DT
, MAX(FAS.EFFECTIVE_DT) LAST_EFFECTIVE_ASSESSMENT_DT
, MAX(FAS.NOTIFICATION_DT) LAST_NOTIFICATION_DT
, SUM(FAS.TRANSACTION_AMOUNT) ASSESSMENT_AMOUNT
, FAS.CURRENCY_CD
, CTRL.CURRENCY_CD LOCAL_CURRENCY_CD
, SUM(FAS.TRANSACTION_AMOUNT/FAS.EXCHANGE_RATE) LOCAL_ASSESSMENT_AMOUNT
, SUBSTR(IGS_FI_GEN_001.FINP_GET_FAS_MAN_IND( FAS.PERSON_ID
, FAS.FEE_TYPE
, FAS.FEE_CAL_TYPE
, FAS.FEE_CI_SEQUENCE_NUMBER
, FAS.FEE_CAT
, FAS.COURSE_CD
, 'DEBT')
, 1
, 1) MANUAL_ENTRY_IND
FROM IGS_FI_FEE_AS FAS
, IGS_FI_F_TYP_CA_INST FTCI
, IGS_FI_CONTROL CTRL
WHERE FAS.S_TRANSACTION_TYPE IN (SELECT STRTY.LOOKUP_CODE FROM IGS_LOOKUPS_VIEW STRTY WHERE STRTY.LOOKUP_CODE = FAS.S_TRANSACTION_TYPE
AND STRTY.TRANSACTION_CAT = 'DEBT'
AND STRTY.LOOKUP_TYPE = 'TRANSACTION_TYPE')
AND FAS.LOGICAL_DELETE_DT IS NULL
AND FTCI.FEE_TYPE = FAS.FEE_TYPE
AND FTCI.FEE_CAL_TYPE = FAS.FEE_CAL_TYPE
AND FTCI.FEE_CI_SEQUENCE_NUMBER = FAS.FEE_CI_SEQUENCE_NUMBER GROUP BY FAS.PERSON_ID
, FTCI.FIN_CAL_TYPE
, FTCI.FIN_CI_SEQUENCE_NUMBER
, FAS.FEE_TYPE
, FAS.FEE_CAL_TYPE
, FAS.FEE_CI_SEQUENCE_NUMBER
, FAS.FEE_CAT
, FAS.CURRENCY_CD
, FAS.COURSE_CD
, CTRL.CURRENCY_CD