View: IGS_FI_REFUNDS_V

Product:	IGS - Student System
Description:	Contains all refund transactions which have been created due to excess unapplied credits along with information about payee.
Implementation/DBA Data:	APPS.IGS_FI_REFUNDS_V

View Text

SELECT RFND.ROWID
, RFND.REFUND_ID
, RFND.VOUCHER_DATE
, RFND.PERSON_ID
, RFND.PAY_PERSON_ID
, PE.PERSON_NUMBER
, PE.FULL_NAME
, RFND.DR_GL_CCID
, RFND.CR_GL_CCID
, RFND.DR_ACCOUNT_CD
, ACC1.DESCRIPTION
, RFND.CR_ACCOUNT_CD
, ACC2.DESCRIPTION
, RFND.REFUND_AMOUNT
, RFND.FEE_TYPE
, RFND.FEE_CAL_TYPE
, RFND.FEE_CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CAT.DESCRIPTION
, RFND.PAYMENT_NUMBER
, RFND.PAYMENT_DATE
, RFND.PAYMENT_MODE
, NULL
, RFND.SOURCE_REFUND_ID
, RFND.INVOICE_ID
, INV.INVOICE_NUMBER
, RFND.TRANSFER_STATUS
, LKP1.MEANING
, RFND.REVERSAL_IND
, RFND.REASON
, RFND.ATTRIBUTE_CATEGORY
, RFND.ATTRIBUTE1
, RFND.ATTRIBUTE2
, RFND.ATTRIBUTE3
, RFND.ATTRIBUTE4
, RFND.ATTRIBUTE5
, RFND.ATTRIBUTE6
, RFND.ATTRIBUTE7
, RFND.ATTRIBUTE8
, RFND.ATTRIBUTE9
, RFND.ATTRIBUTE10
, RFND.ATTRIBUTE11
, RFND.ATTRIBUTE12
, RFND.ATTRIBUTE13
, RFND.ATTRIBUTE14
, RFND.ATTRIBUTE15
, RFND.ATTRIBUTE16
, RFND.ATTRIBUTE17
, RFND.ATTRIBUTE18
, RFND.ATTRIBUTE19
, RFND.ATTRIBUTE20
, RFND.CREATED_BY
, RFND.CREATION_DATE
, RFND.LAST_UPDATED_BY
, RFND.LAST_UPDATE_DATE
, RFND.LAST_UPDATE_LOGIN
, RFND.REQUEST_ID
, RFND.PROGRAM_APPLICATION_ID
, RFND.PROGRAM_ID
, RFND.PROGRAM_UPDATE_DATE
, RFND.GL_DATE
, RFND.REVERSAL_GL_DATE
FROM IGS_FI_REFUNDS RFND
, IGS_LOOKUP_VALUES LKP1
, IGS_FI_PARTIES_V PE
, IGS_CA_TYPE CAT
, IGS_CA_INST CI
, IGS_FI_INV_INT INV
, IGS_FI_ACC ACC1
, IGS_FI_ACC ACC2
WHERE RFND.PAY_PERSON_ID=PE.PERSON_ID
AND RFND.FEE_CAL_TYPE=CI.CAL_TYPE
AND RFND.FEE_CI_SEQUENCE_NUMBER=CI.SEQUENCE_NUMBER
AND RFND.FEE_CAL_TYPE=CAT.CAL_TYPE
AND RFND.INVOICE_ID=INV.INVOICE_ID(+)
AND RFND.TRANSFER_STATUS=LKP1.LOOKUP_CODE
AND LKP1.LOOKUP_TYPE='REFUND_TRANSFER_STATUS'
AND ACC1.ACCOUNT_CD(+) =RFND.DR_ACCOUNT_CD
AND ACC2.ACCOUNT_CD(+) =RFND.CR_ACCOUNT_CD

Columns