[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Stores all refund transactions, which have been created due to excess unapplied credits. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT RE1.FEE_TYPE
, RE1.FEE_CAL_TYPE
, RE1.REVERSAL_IND
, RE1.VOUCHER_DATE
, RE1.GL_DATE
, RE1.REFUND_AMOUNT
, '_LA:RE1.TRANSFER_STATUS:IGS_LOOKUP_VALUES:REFUND_TRANSFER_STATUS:MEANING'
, RE1.REASON
, RE1.REVERSAL_GL_DATE
, RE1.DR_ACCOUNT_CD
, RE1.CR_ACCOUNT_CD
, '_KF:SQLGL:GL#:GCC1'
, '_KF:SQLGL:GL#:GCC2'
, PA1.PARTY_NUMBER
, PA1.PARTY_NAME
, PA2.PARTY_NUMBER
, PA2.PARTY_NAME
, FE.DESCRIPTION
, CI.START_DT
, CI.END_DT
, CI.DESCRIPTION
, CI.ALTERNATE_CODE
, IV.INVOICE_NUMBER
, AC1.DESCRIPTION
, AC2.DESCRIPTION
, RE2.VOUCHER_DATE
, '_DF:IGS:IGS_FI_REFUNDS_FLEX:RE1'
, RE1.DR_GL_CCID
, RE1.CR_GL_CCID
, RE1.REFUND_ID
, RE1.PERSON_ID
, RE1.PAY_PERSON_ID
, RE1.FEE_CI_SEQUENCE_NUMBER
, RE1.INVOICE_ID
, RE1.SOURCE_REFUND_ID
, RE1.CREATION_DATE
, RE1.CREATED_BY
, RE1.LAST_UPDATE_DATE
, RE1.LAST_UPDATED_BY
FROM IGS_FI_REFUNDS RE1
, IGS_FI_REFUNDS RE2
, HZ_PARTIES PA1
, HZ_PARTIES PA2
, IGS_FI_FEE_TYPE_ALL FE
, IGS_CA_INST_ALL CI
, IGS_FI_INV_INT_ALL IV
, IGS_FI_ACC_ALL AC1
, IGS_FI_ACC_ALL AC2
, GL_CODE_COMBINATIONS GCC1
, GL_CODE_COMBINATIONS GCC2
WHERE RE1.SOURCE_REFUND_ID = RE2.REFUND_ID(+)
AND RE1.PERSON_ID = PA1.PARTY_ID
AND RE1.PAY_PERSON_ID = PA2.PARTY_ID
AND RE1.INVOICE_ID = IV.INVOICE_ID
AND RE1.FEE_TYPE = FE.FEE_TYPE
AND RE1.FEE_CAL_TYPE = CI.CAL_TYPE
AND RE1.FEE_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND RE1.DR_ACCOUNT_CD = AC1.ACCOUNT_CD(+)
AND RE1.CR_ACCOUNT_CD = AC2.ACCOUNT_CD(+)
AND RE1.DR_GL_CCID = GCC1.CODE_COMBINATION_ID(+)
AND RE1.CR_GL_CCID = GCC2.CODE_COMBINATION_ID(+) WITH READ ONLY