Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view contains information from two views IGS_FI_INV_INT and IGS_FI_CREDITS_V and a table IGS_FI_CR_ACTIVITES using UNION to collate information for Account History Form. |
Implementation/DBA Data: | Not implemented in this database |
SELECT INV.PERSON_ID
, INV.SUBACCOUNT_ID
, INV.INVOICE_ID
, INV.INVOICE_NUMBER
, INV.INVOICE_CREATION_DATE
, INV.INVOICE_AMOUNT
, INV.BILL_NUMBER
, INV.BILL_DATE
, INV.FEE_TYPE
, NULL CREDIT_TYPE_NAME
, INV.INVOICE_DESC
, INV.ORG_ID
, INV.LAST_UPDATED_BY
, INV.LAST_UPDATE_DATE
, INV.LAST_UPDATE_LOGIN
, INV.CREATED_BY
, INV.CREATION_DATE
FROM IGS_FI_INV_INT INV UNION ALL SELECT CRD.PARTY_ID
, CRD.SUBACCOUNT_ID
, CRDA.CREDIT_ACTIVITY_ID
, CRD.CREDIT_NUMBER
, CRDA.TRANSACTION_DATE
, -(CRDA.AMOUNT)
, CRDA.BILL_NUMBER
, CRDA.BILL_DATE
, NULL FEE_TYPE
, CRD.CREDIT_TYPE_NAME
, CRD.DESCRIPTION
, CRD.ORG_ID
, CRDA.LAST_UPDATED_BY
, CRDA.LAST_UPDATE_DATE
, CRDA.LAST_UPDATE_LOGIN
, CRDA.CREATED_BY
, CRDA.CREATION_DATE
FROM IGS_FI_CREDITS_V CRD
, IGS_FI_CR_ACTIVITIES CRDA
, IGS_FI_CR_TYPES CRT
WHERE CRD.CREDIT_ID = CRDA.CREDIT_ID
AND CRD.CREDIT_TYPE_ID = CRT.CREDIT_TYPE_ID
AND CRT.CREDIT_CLASS NOT IN ('ENRDEPOSIT'
, 'OTHDEPOSIT')