Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Retrieves all the External Charges incurred by the student. |
Implementation/DBA Data: | Not implemented in this database |
SELECT CHG.ROWID
, CHG.PERSON_ID
, HZ.PARTY_NUMBER
, CHG.INVOICE_ID
, LN.INVOICE_LINES_ID
, CHG.FEE_TYPE
, CHG.FEE_CAL_TYPE
, CHG.FEE_CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CHG.INVOICE_NUMBER
, CHG.INVOICE_CREATION_DATE
, CHG.EFFECTIVE_DATE
, CHG.INVOICE_AMOUNT
, CHG.INVOICE_AMOUNT_DUE
, LN.GL_DATE
, LN.REC_ACCOUNT_CD
, LN.REV_ACCOUNT_CD
, LN.REC_GL_CCID
, LN.REV_GL_CCID
, CHG.WAIVER_FLAG
, LN.ATTRIBUTE_CATEGORY
, LN.ATTRIBUTE1
, LN.ATTRIBUTE2
, LN.ATTRIBUTE3
, LN.ATTRIBUTE4
, LN.ATTRIBUTE5
, LN.ATTRIBUTE6
, LN.ATTRIBUTE7
, LN.ATTRIBUTE8
, LN.ATTRIBUTE9
, LN.ATTRIBUTE10
, LN.ATTRIBUTE11
, LN.ATTRIBUTE12
, LN.ATTRIBUTE13
, LN.ATTRIBUTE14
, LN.ATTRIBUTE15
, LN.ATTRIBUTE16
, LN.ATTRIBUTE17
, LN.ATTRIBUTE18
, LN.ATTRIBUTE19
, LN.ATTRIBUTE20
, LN.POSTING_ID
, LN.POSTING_CONTROL_ID
, CHG.CREATED_BY
, CHG.CREATION_DATE
, CHG.LAST_UPDATED_BY
, CHG.LAST_UPDATE_DATE
, CHG.LAST_UPDATE_LOGIN
FROM IGS_FI_INV_INT_ALL CHG
, IGS_FI_INVLN_INT_ALL LN
, HZ_PARTIES HZ
, IGS_CA_INST CI
WHERE CHG.TRANSACTION_TYPE = 'EXTERNAL'
AND CHG.INVOICE_ID = LN.INVOICE_ID
AND CHG.PERSON_ID = HZ.PARTY_ID
AND CHG.FEE_CAL_TYPE = CI.CAL_TYPE
AND CHG.FEE_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER